eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_AIA_CUSTOM_PKG dependencies on RA_CUSTOMER_MERGES

Line 149: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCT_SITES_ALL cas2

145: null, -- from common_obj_id
146: rm.customer_address_id, -- to cust_acct_site_id
147: cas2.party_site_id, -- to party_site_id
148: null ) -- to common_obj_id
149: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCT_SITES_ALL cas, HZ_CUST_ACCT_SITES_ALL cas2
150: where rm.customer_merge_header_id = p_customer_merge_header_id
151: and rm.duplicate_address_id = cas.cust_acct_site_id(+)
152: and rm.customer_address_id = cas2.cust_acct_site_id(+)
153: group by rm.duplicate_address_id, rm.customer_address_id,

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(+)