Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_DUP_SET_PARTIES_V |
SELECT DISTINCT(DSP.DUP_PARTY_ID)
, DB.DUP_BATCH_ID
, DS.DUP_SET_ID
, DS.WINNER_PARTY_ID
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, DSP.SCORE
, DSP.MERGE_FLAG
, DSP.NOT_DUP
, DSP.MERGE_SEQ_ID
, DSP.MERGE_BATCH_ID
, DSP.MERGE_BATCH_NAME
, DUE.DUP_EXCLUSION_ID
, DUE.FROM_DATE
, DUE.TO_DATE
, DSP.CREATED_BY
, DSP.CREATION_DATE
, DSP.LAST_UPDATE_LOGIN
, DSP.LAST_UPDATE_DATE
, DSP.LAST_UPDATED_BY
FROM HZ_PARTIES PA
, HZ_DUP_SETS DS
, HZ_DUP_SET_PARTIES DSP
, HZ_DUP_BATCH DB
, HZ_DUP_EXCLUSIONS DUE
WHERE PA.PARTY_ID = DSP.DUP_PARTY_ID
AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
AND DS.DUP_SET_ID = DSP.DUP_SET_ID
AND DSP.DUP_PARTY_ID = DUE.DUP_PARTY_ID(+)