[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 |
APPS.HZ_DUP_SETS_V