[Home] [Help]
View: HZ_MERGE_PARTY_RELN_V
View Text
SELECT MD.BATCH_PARTY_ID
, MD.MERGE_FROM_ENTITY_ID
, DECODE(MD.MERGE_TO_ENTITY_ID
, NULL
, 'TRANSFER'
, MD.MERGE_FROM_ENTITY_ID
, 'TRANSFER'
, 'MERGE') OPERATION
, MD.MERGE_TO_ENTITY_ID
, MD.MANDATORY_MERGE
, MD.CREATED_BY
, MD.CREATION_DATE
, MD.LAST_UPDATE_LOGIN
, MD.LAST_UPDATE_DATE
, MD.LAST_UPDATED_BY
, HZ_MERGE_UTIL.GET_ORG_CONTACT_ID(PR.RELATIONSHIP_ID) ORG_CONTACT_ID
, PR.OBJECT_ID
, PR.SUBJECT_ID
FROM HZ_RELATIONSHIPS PR
, HZ_MERGE_PARTY_DETAILS MD
WHERE MD.ENTITY_NAME = 'HZ_PARTY_RELATIONSHIPS'
AND PR.RELATIONSHIP_ID = MD.MERGE_FROM_ENTITY_ID
AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND PR.DIRECTIONAL_FLAG = 'F'
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 |
ORG_CONTACT_ID |
OBJECT_ID |
SUBJECT_ID |