SELECT DISTINCT(DSP.MERGE_BATCH_NAME),DSP.MERGE_SEQ_ID,DB.DUP_BATCH_ID,DSP.GROUP_SET FROM HZ_DUP_BATCH DB, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP WHERE db.dup_batch_id = ds.dup_batch_id and ds.dup_set_id = dsp.dup_set_id and DSP.MERGE_SEQ_ID >0
SELECT DISTINCT(DSP.MERGE_BATCH_NAME)
, DSP.MERGE_SEQ_ID
, DB.DUP_BATCH_ID
, DSP.GROUP_SET
FROM HZ_DUP_BATCH DB
, HZ_DUP_SETS DS
, HZ_DUP_SET_PARTIES DSP
WHERE DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
AND DS.DUP_SET_ID = DSP.DUP_SET_ID
AND DSP.MERGE_SEQ_ID >0
|
|
|