VIEW: APPS.HZ_DUP_SET_PARTIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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