APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_CUST_ACCOUNTS_M

Line 120: FROM hz_cust_accounts_m fa

116: fa.cust_account_id,
117: fa.account_name,
118: fa.account_number,
119: HZ_ORIG_SYS_REF_OBJ_TBL())
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

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 363: FROM hz_cust_accounts_m fa

359: fa.cust_account_id,
360: fa.account_name,
361: fa.account_number,
362: HZ_ORIG_SYS_REF_OBJ_TBL())
363: FROM hz_cust_accounts_m fa
364: WHERE fa.cust_account_id = mh.duplicate_id
365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),
366: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_OBJS
367: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_SITE_USES_OBJS

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