APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_ACCT_ORIG_SYS_REF_OBJ

Line 109: HZ_ACCT_ORIG_SYS_REF_OBJ(

105: fp.party_number,
106: fp.party_name,
107: fp.party_type,
108: HZ_ORIG_SYS_REF_OBJ_TBL()),
109: HZ_ACCT_ORIG_SYS_REF_OBJ(
110: ta.cust_account_id,
111: ta.account_name,
112: ta.account_number,
113: HZ_ORIG_SYS_REF_OBJ_TBL()),

Line 115: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(

111: ta.account_name,
112: ta.account_number,
113: HZ_ORIG_SYS_REF_OBJ_TBL()),
114: CAST(MULTISET (
115: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
116: fa.cust_account_id,
117: fa.account_name,
118: fa.account_number,
119: HZ_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 352: HZ_ACCT_ORIG_SYS_REF_OBJ(

348: fp.party_number,
349: fp.party_name,
350: fp.party_type,
351: HZ_ORIG_SYS_REF_OBJ_TBL()),
352: HZ_ACCT_ORIG_SYS_REF_OBJ(
353: ta.cust_account_id,
354: ta.account_name,
355: ta.account_number,
356: HZ_ORIG_SYS_REF_OBJ_TBL()),

Line 358: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(

354: ta.account_name,
355: ta.account_number,
356: HZ_ORIG_SYS_REF_OBJ_TBL()),
357: CAST(MULTISET (
358: SELECT HZ_ACCT_ORIG_SYS_REF_OBJ(
359: fa.cust_account_id,
360: fa.account_name,
361: fa.account_number,
362: HZ_ORIG_SYS_REF_OBJ_TBL())

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