eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on HZ_PARTIES

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

108: FROM hz_cust_accounts fa
109: WHERE fa.cust_account_id = mh.duplicate_id
110: ) AS HZ_ACCT_ORIG_SYS_REF_OBJ_TBL)
111: )
112: FROM ra_customer_merge_headers mh, hz_cust_accounts ta, hz_parties tp, hz_cust_accounts fa, hz_parties fp
113: WHERE mh.customer_merge_header_id = p_customer_merge_header_id
114: AND ta.cust_account_id = mh.customer_id
115: AND tp.party_id = ta.party_id
116: AND fa.cust_account_id = mh.duplicate_id

Line 146: p_owner_table_name => 'HZ_PARTIES',

142: -- SSM for merge-to acct party obj
143: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
144: (p_init_msg_list => fnd_api.g_false,
145: p_owner_table_id => x_account_merge_obj.merge_to_acct_party_obj.party_id,
146: p_owner_table_name => 'HZ_PARTIES',
147: p_action_type => NULL,
148: x_orig_sys_ref_objs => x_account_merge_obj.merge_to_acct_party_obj.orig_sys_objs,
149: x_return_status => x_return_status,
150: x_msg_count => x_msg_count,

Line 161: p_owner_table_name => 'HZ_PARTIES',

157: -- SSM for merge-from acct party obj
158: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
159: (p_init_msg_list => fnd_api.g_false,
160: p_owner_table_id => x_account_merge_obj.merge_from_acct_party_obj.party_id,
161: p_owner_table_name => 'HZ_PARTIES',
162: p_action_type => NULL,
163: x_orig_sys_ref_objs => x_account_merge_obj.merge_from_acct_party_obj.orig_sys_objs,
164: x_return_status => x_return_status,
165: x_msg_count => x_msg_count,

Line 343: FROM hz_parties fp, hz_merge_parties mp1

339: fp.party_number,
340: fp.party_name,
341: fp.party_type,
342: HZ_ORIG_SYS_REF_OBJ_TBL())
343: FROM hz_parties fp, hz_merge_parties mp1
344: WHERE mp1.batch_id = p_batch_id
345: AND mp1.to_party_id = p_merge_to_party_id
346: AND fp.party_id = mp1.from_party_id
347: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),

Line 354: hz_parties tp

350: FROM hz_merge_batch mb,
351: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = p_merge_to_party_id) mp,
352: hz_dup_batch db,
353: hz_dup_sets dset,
354: hz_parties tp
355: WHERE mb.batch_id = p_batch_id
356: AND tp.party_id = p_merge_to_party_id
357: AND mb.batch_id = dset.dup_set_id (+)
358: AND db.dup_batch_id (+)= dset.dup_batch_id

Line 600: p_owner_table_name => 'HZ_PARTIES',

596: -- SSM for party obj
597: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
598: (p_init_msg_list => fnd_api.g_false,
599: p_owner_table_id => x_party_merge_obj.merge_to_party_obj.party_id,
600: p_owner_table_name => 'HZ_PARTIES',
601: p_action_type => NULL,
602: x_orig_sys_ref_objs => x_party_merge_obj.merge_to_party_obj.orig_sys_objs,
603: x_return_status => x_return_status,
604: x_msg_count => x_msg_count,

Line 616: p_owner_table_name => 'HZ_PARTIES',

612:
613: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
614: (p_init_msg_list => fnd_api.g_false,
615: p_owner_table_id => x_party_merge_obj.merge_from_party_objs(I).party_id,
616: p_owner_table_name => 'HZ_PARTIES',
617: p_action_type => NULL,
618: x_orig_sys_ref_objs => x_party_merge_obj.merge_from_party_objs(I).orig_sys_objs,
619: x_return_status => x_return_status,
620: x_msg_count => x_msg_count,