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_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUSTOMER_PROFILES_M

Line 793: FROM ra_customer_merge_headers cmh, hz_customer_profiles_m cpf, hz_customer_profiles cpt

789: )
790: FROM (SELECT 'Merge' operation, cpf.cust_account_profile_id from_profile_id,
791: cpt.cust_account_profile_id to_profile_id,
792: cmh.duplicate_id from_parent_id, cmh.customer_id to_parent_id
793: FROM ra_customer_merge_headers cmh, hz_customer_profiles_m cpf, hz_customer_profiles cpt
794: WHERE cmh.customer_merge_header_id = p_customer_merge_header_id
795: AND cmh.duplicate_id <> cmh.customer_id
796: AND cpf.cust_account_id = cmh.duplicate_id
797: AND cpf.customer_merge_header_id = p_customer_merge_header_id

Line 809: FROM ra_customer_merges cm, hz_customer_profiles_m cpf, hz_customer_profiles cpt

805: cpf.cust_account_profile_id from_profile_id,
806: cpt.cust_account_profile_id to_profile_id,
807: cm.duplicate_site_id from_parent_id,
808: cm.customer_site_id to_parent_id
809: FROM ra_customer_merges cm, hz_customer_profiles_m cpf, hz_customer_profiles cpt
810: WHERE cm.customer_merge_header_id = p_customer_merge_header_id
811: AND cpf.customer_merge_header_id = p_customer_merge_header_id
812: AND cpf.cust_account_id = cm.duplicate_id
813: AND cpf.site_use_id = cm.duplicate_site_id

Line 1132: FROM hz_customer_profiles_m

1128:
1129: FOR I IN 1..x_account_merge_v2_obj.customer_profile_objs.count LOOP
1130: l_site_use_id := null;
1131: SELECT site_use_id INTO l_site_use_id
1132: FROM hz_customer_profiles_m
1133: WHERE cust_account_profile_id = x_account_merge_v2_obj.customer_profile_objs(I).from_object_id;
1134:
1135: IF l_site_use_id IS NOT NULL THEN
1136: