View: HZ_DUP_SET_PARTIES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_DUP_SET_PARTIES_V

View Text

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(+)

Columns