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)