FND Design Data [Home] [Help]

View: HZ_DUP_BATCH_REVIEW_V

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.HZ_DUP_BATCH_REVIEW_V
View Text

SELECT DISTINCT(DSP.MERGE_BATCH_NAME)
, DSP.MERGE_SEQ_ID
, DB.DUP_BATCH_ID
, DSP.GROUP_SET
FROM HZ_DUP_BATCH DB
, HZ_DUP_SETS DS
, HZ_DUP_SET_PARTIES DSP
WHERE DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
AND DS.DUP_SET_ID = DSP.DUP_SET_ID
AND DSP.MERGE_SEQ_ID >0

Columns

Name
MERGE_BATCH_NAME
MERGE_SEQ_ID
DUP_BATCH_ID
GROUP_SET