View: HZ_MERGE_PARTY_RELN_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.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