[Home] [Help]
View: HZ_DUP_BATCH_REVIEW_DTL_V
View Text
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
Columns
| Name |
| MERGE_SEQ_ID |
| DUP_BATCH_ID |
| DUP_SET_ID |
| MERGE_FROM_ID |
| MERGE_TO_ID |
| GROUP_SET |