VIEW: APPS.HZ_DUP_SETS_V

Source

View Text - Preformatted

SELECT DS.DUP_SET_ID, DB.DUP_BATCH_ID, DS.WINNER_PARTY_ID, PA.PARTY_NUMBER, PA.PARTY_NAME, DS.CREATED_BY , DS.CREATION_DATE , DS.LAST_UPDATE_LOGIN , DS.LAST_UPDATE_DATE , DS.LAST_UPDATED_BY FROM HZ_PARTIES PA , HZ_DUP_SETS DS, HZ_DUP_BATCH DB WHERE PA.party_id = DS.winner_party_id AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID

View Text - HTML Formatted

SELECT DS.DUP_SET_ID
, DB.DUP_BATCH_ID
, DS.WINNER_PARTY_ID
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, DS.CREATED_BY
, DS.CREATION_DATE
, DS.LAST_UPDATE_LOGIN
, DS.LAST_UPDATE_DATE
, DS.LAST_UPDATED_BY
FROM HZ_PARTIES PA
, HZ_DUP_SETS DS
, HZ_DUP_BATCH DB
WHERE PA.PARTY_ID = DS.WINNER_PARTY_ID
AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID