[Home] [Help]
View: 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
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 |
Name |