DBA Data[Home] [Help]

APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_ACCOUNT_ROLES_M

Line 166: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCOUNT_ROLES_M carm, HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS relm, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS ocm, HZ_ORG_CONTACTS oc

162: null, -- from common_obj_id
163: car.cust_account_role_id, -- to cust_acct_role_id
164: oc.org_contact_id, -- to org_contact_id
165: null ) -- to common_obj_id
166: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCOUNT_ROLES_M carm, HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS relm, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS ocm, HZ_ORG_CONTACTS oc
167: where rm.customer_merge_header_id = p_customer_merge_header_id
168: and rm.customer_merge_header_id = carm.customer_merge_header_id(+)
169: and carm.party_id = relm.party_id(+)
170: and relm.relationship_id = ocm.party_relationship_id(+)