APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on RA_CUSTOMER_MERGE_HEADERS

Line 124: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp

120: FROM hz_cust_accounts_m fa
121: WHERE fa.cust_account_id = mh.duplicate_id
122: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
123: )
124: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp
125: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
126: AND ta.cust_account_id = mh.customer_id
127: AND tp.party_id = ta.party_id
128: AND fa.cust_account_id = mh.duplicate_id

Line 373: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp

369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS
370: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUST_PROFILE_AMT_OBJS
371: HZ_ACCT_MERGE_DETAIL_OBJ_TBL() --ACCT_REL_OBJS
372: )
373: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts_m fa, hz_parties fp
374: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
375: AND ta.cust_account_id = mh.customer_id
376: AND tp.party_id = ta.party_id
377: AND fa.cust_account_id = mh.duplicate_id

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 836: FROM ra_customer_merge_headers cmh, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat

832: )
833: FROM (SELECT 'Merge' operation, cpaf.cust_acct_profile_amt_id from_profile_amt_id,
834: cpat.cust_acct_profile_amt_id to_profile_amt_id,
835: cmh.duplicate_id from_parent_id, cmh.customer_id to_parent_id
836: FROM ra_customer_merge_headers cmh, hz_cust_profile_amts_m cpaf, hz_cust_profile_amts cpat
837: WHERE cmh.customer_merge_header_id = p_customer_merge_header_id
838: AND cmh.duplicate_id <> cmh.customer_id
839: AND cpaf.customer_merge_header_id = p_customer_merge_header_id
840: AND cpaf.cust_account_id = cmh.duplicate_id

Line 1039: FROM ra_customer_merge_headers

1035: END IF;
1036:
1037: BEGIN
1038: SELECT customer_merge_header_id INTO l_header_id
1039: FROM ra_customer_merge_headers
1040: WHERE customer_merge_header_id = p_customer_merge_header_id;
1041: EXCEPTION
1042: WHEN NO_DATA_FOUND THEN
1043: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');