DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCT_ORIG_SYS_REF_OBJ_TBL

Line 122: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)

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
125: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
126: AND ta.cust_account_id = mh.customer_id

Line 365: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL),

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
368: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --ACCT_ROLE_OBJS
369: HZ_ACCT_MERGE_DETAIL_OBJ_TBL(), --CUSTOMER_PROFILE_OBJS