Using the below query you can retrieve the records from the BO in which you execute the Match Job(manual merge) and to determine which records matched with other.
select distinct(finalquery.src_rowid), 
finalquery.party_nm,
finalquery.PARTY_ID
from
(select pm.src_rowid, 
pm.party_nm,
pm.PARTY_ID
from 
(select parentrecord.*,1 seq,'match with' parentrec,'' childrec  from
(SELECT mtch.rowid_object_matched, xr.pkey_src_object SRC_ROWID,
bo.PARTY_NM,
bo.ROWID_OBJECT PARTY_ID
FROM c_bo_party bo
INNER JOIN c_bo_party_xref XR
ON bo.rowid_object=xr.rowid_object
INNER JOIN c_bo_party_MTCH mtch
ON bo.rowid_object=mtch.rowid_object_matched
GROUP BY  mtch.rowid_object_matched,xr.pkey_src_object,
bo.PARTY_NM,
bo.ROWID_OBJECT) parentrecord
union all
select childrecords.*,2 seq,'' parentrec,'match to' childrec from 
(SELECT mtch.rowid_object_matched, xr.pkey_src_object SRC_ROWID,
bo.PARTY_NM,
bo.ROWID_OBJECT PARTY_ID
FROM c_bo_party bo
INNER JOIN c_bo_party_xref XR
ON bo.rowid_object=xr.rowid_object
INNER JOIN c_bo_party_MTCH mtch
ON bo.rowid_object=mtch.rowid_object 
GROUP BY  mtch.rowid_object_matched,xr.pkey_src_object,
bo.PARTY_NM,
bo.ROWID_OBJECT) childrecords) pm  ) finalquery;
                       
                    
0 Comment(s)