[Home] [Help]
View: HZ_DUP_SETS_V
View Text
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
Columns
Name |
DUP_SET_ID |
DUP_BATCH_ID |
WINNER_PARTY_ID |
PARTY_NUMBER |
PARTY_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |