VIEW: APPS.HZ_MERGE_PARTY_RELN_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'