[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
| 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 |