APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on RA_CUSTOMER_MERGES

Line 575: FROM ra_customer_merges cm

571: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
572: )
573: FROM (SELECT distinct duplicate_address_id, customer_address_id,
574: duplicate_id, customer_id, org_id, customer_createsame
575: FROM ra_customer_merges cm
576: WHERE customer_merge_header_id = p_customer_merge_header_id
577: AND duplicate_id <> customer_id) cm;
578:
579: CURSOR get_site_use_details IS

Line 771: FROM ra_customer_merges cm

767: WHERE OWNER_TABLE_ID = cm.customer_address_id
768: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCT_SITES_ALL'
769: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
770: )
771: FROM ra_customer_merges cm
772: WHERE customer_merge_header_id = p_customer_merge_header_id;
773:
774: CURSOR get_customer_profiles IS
775:

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 853: FROM ra_customer_merges cm, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat

849: cpaf.cust_acct_profile_amt_id from_profile_amt_id,
850: cpat.cust_acct_profile_amt_id to_profile_amt_id,
851: cm.duplicate_site_id from_parent_id,
852: cm.customer_site_id to_parent_id
853: FROM ra_customer_merges cm, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat
854: WHERE cm.customer_merge_header_id = p_customer_merge_header_id
855: AND cpaf.customer_merge_header_id = p_customer_merge_header_id
856: AND cpaf.cust_account_id = cm.duplicate_id
857: AND cpaf.site_use_id = cm.duplicate_site_id

Line 882: FROM ra_customer_merges cm

878: carf.cust_account_role_id to_role_id,
879: Nvl(carf.cust_acct_site_id,cm.duplicate_id) from_parent_id,
880: Decode(carf.cust_acct_site_id, NULL,cm.customer_id,cm.customer_address_id) to_parent_id, 'Transfer' operation
881: FROM (SELECT DISTINCT duplicate_id, duplicate_address_id, customer_address_id, customer_id
882: FROM ra_customer_merges cm
883: WHERE cm.customer_merge_header_id = p_customer_merge_header_id
884: AND cm.duplicate_id <> cm.customer_id) cm, hz_cust_account_roles_m carf
885: WHERE carf.customer_merge_header_id = p_customer_merge_header_id
886: AND ((carf.cust_account_id = cm.duplicate_id AND carf.cust_acct_site_id = cm.duplicate_address_id)

Line 1004: AND crelt.org_id IN (SELECT org_id FROM ra_customer_merges

1000: OR
1001: (crelf.related_cust_account_id = duplicate_id
1002: AND crelt.related_cust_account_id = customer_id
1003: AND crelt.cust_account_id = crelf.cust_account_id))
1004: AND crelt.org_id IN (SELECT org_id FROM ra_customer_merges
1005: WHERE customer_merge_header_id = p_customer_merge_header_id)
1006: AND crelf.org_id = crelt.org_id;
1007:
1008: l_site_use_id NUMBER;