VIEW: APPS.HZ_DUP_BATCH_REVIEW_DTL_V

Source

View Text - Preformatted

SELECT dsp.merge_seq_id, ds.dup_batch_id, ds.dup_set_id, dsp.dup_party_id, ds.winner_party_id, dsp.group_set from hz_dup_sets ds, hz_dup_set_parties dsp WHERE dsp.dup_set_id = ds.dup_set_id and dsp.merge_flag = 'Y' and dsp.merge_seq_id > 0

View Text - HTML Formatted

SELECT DSP.MERGE_SEQ_ID
, DS.DUP_BATCH_ID
, DS.DUP_SET_ID
, DSP.DUP_PARTY_ID
, DS.WINNER_PARTY_ID
, DSP.GROUP_SET
FROM HZ_DUP_SETS DS
, HZ_DUP_SET_PARTIES DSP
WHERE DSP.DUP_SET_ID = DS.DUP_SET_ID
AND DSP.MERGE_FLAG = 'Y'
AND DSP.MERGE_SEQ_ID > 0