SELECT 514, 10000168,  C.contxt_id, C.contxt_elmt_ix, null, null, null, null, null, null, 1 
FROM CONTXT as P INNER JOIN CONTXT_ELMT as C on P.contxt_id = C.contxt_id
	INNER JOIN MRS_REPLICATION_OUT as S on S.ent_id=10000029 
		   AND P.contxt_id = S.pk1
	INNER JOIN MRS_TRANSACTION TRANS on TRANS.trans_id=514 
	LEFT  JOIN ON_REPL_DATA_OWNER NRDO on NRDO.non_repl_data_owner_id = C.owner_id 
	LEFT  JOIN REPL_DATA_OWNER_RSDNC RDOR on RDOR.owner_id = C.owner_id 
		   AND RDOR.rsdnc_node_id=TRANS.recv_node_id 
	LEFT  JOIN MRS_REPLICATION_OUT OUT on OUT.trans_id = 514 
	           AND OUT.ent_id=10000168 and C.contxt_id = OUT.pk1
		   AND C.contxt_elmt_ix = OUT.pk2
	INNER JOIN MRS_TRANSACTION RED_TRANS on TRANS.prov_node_id=RED_TRANS.prov_node_id
		   AND TRANS.recv_node_id=RED_TRANS.recv_node_id 
	LEFT  JOIN MRS_REPLICATION_OUT RED_OUT on RED_TRANS.cat_code = 'OUT' 
		   AND RED_TRANS.trans_type in ('X01', 'X02') 
		   AND RED_TRANS.trans_id = RED_OUT.trans_id 
WHERE S.age=0 and S.trans_id=514
	AND (NRDO.non_repl_data_owner_id is null) 
	AND (RDOR.repl_data_owner_id is null) 
	AND (OUT.trans_id is null) 
	AND (RED_OUT.trans_id is null);