DBA Data[Home] [Help]

APPS.HZ_AIA_CUSTOM_PKG dependencies on RA_CUSTOMER_MERGE_HEADERS

Line 177: from RA_CUSTOMER_MERGE_HEADERS mh, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS ca2

173: and rel.relationship_id = oc.party_relationship_id(+)
174: group by carm.cust_account_role_id, car.cust_account_role_id,
175: ocm.org_contact_id, oc.org_contact_id
176: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
177: from RA_CUSTOMER_MERGE_HEADERS mh, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS ca2
178: where mh.customer_merge_header_id = l_customer_merge_header_id
179: and mh.process_flag = 'Y'
180: and mh.duplicate_id = ca.cust_account_id(+)
181: and mh.customer_id = ca2.cust_account_id;