FND Design Data [Home] [Help]

View: HZ_MERGE_PARTY_SITE_DETAILS_V

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

SELECT BATCH_PARTY_ID
, MERGE_FROM_ENTITY_ID
, DECODE(MERGE_TO_ENTITY_ID
, NULL
, 'TRANSFER'
, MERGE_FROM_ENTITY_ID
, 'TRANSFER'
, 'MERGE') OPERATION
, MERGE_TO_ENTITY_ID
, MANDATORY_MERGE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM HZ_MERGE_PARTY_DETAILS
WHERE ENTITY_NAME = 'HZ_PARTY_SITES' ORDER BY OPERATION

Columns

Name
BATCH_PARTY_ID
MERGE_FROM_ENTITY_ID
OPERATION
MERGE_TO_ENTITY_ID
MANDATORY_MERGE
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
LAST_UPDATED_BY