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 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 158: p_owner_table_name => 'HZ_PARTIES',

154: -- SSM for merge-to acct party obj
155: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
156: (p_init_msg_list => fnd_api.g_false,
157: p_owner_table_id => x_account_merge_obj.merge_to_acct_party_obj.party_id,
158: p_owner_table_name => 'HZ_PARTIES',
159: p_action_type => NULL,
160: x_orig_sys_ref_objs => x_account_merge_obj.merge_to_acct_party_obj.orig_sys_objs,
161: x_return_status => x_return_status,
162: x_msg_count => x_msg_count,

Line 173: p_owner_table_name => 'HZ_PARTIES',

169: -- SSM for merge-from acct party obj
170: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
171: (p_init_msg_list => fnd_api.g_false,
172: p_owner_table_id => x_account_merge_obj.merge_from_acct_party_obj.party_id,
173: p_owner_table_name => 'HZ_PARTIES',
174: p_action_type => NULL,
175: x_orig_sys_ref_objs => x_account_merge_obj.merge_from_acct_party_obj.orig_sys_objs,
176: x_return_status => x_return_status,
177: x_msg_count => x_msg_count,

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 1055: p_owner_table_name => 'HZ_PARTIES',

1051: -- SSM for merge-to acct party obj
1052: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1053: (p_init_msg_list => fnd_api.g_false,
1054: p_owner_table_id => x_account_merge_v2_obj.merge_to_acct_party_obj.party_id,
1055: p_owner_table_name => 'HZ_PARTIES',
1056: p_action_type => NULL,
1057: x_orig_sys_ref_objs => x_account_merge_v2_obj.merge_to_acct_party_obj.orig_sys_objs,
1058: x_return_status => x_return_status,
1059: x_msg_count => x_msg_count,

Line 1070: p_owner_table_name => 'HZ_PARTIES',

1066: -- SSM for merge-from acct party obj
1067: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1068: (p_init_msg_list => fnd_api.g_false,
1069: p_owner_table_id => x_account_merge_v2_obj.merge_from_acct_party_obj.party_id,
1070: p_owner_table_name => 'HZ_PARTIES',
1071: p_action_type => NULL,
1072: x_orig_sys_ref_objs => x_account_merge_v2_obj.merge_from_acct_party_obj.orig_sys_objs,
1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,

Line 1513: FROM hz_parties fp, hz_merge_parties mp1

1509: fp.party_number,
1510: fp.party_name,
1511: fp.party_type,
1512: HZ_ORIG_SYS_REF_OBJ_TBL())
1513: FROM hz_parties fp, hz_merge_parties mp1
1514: WHERE mp1.batch_id = p_batch_id
1515: AND mp1.to_party_id = l_merge_to_party_id
1516: AND fp.party_id = mp1.from_party_id
1517: AND mp1.merge_type = mp.merge_type

Line 1525: hz_parties tp

1521: FROM hz_merge_batch mb,
1522: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = l_merge_to_party_id) mp,
1523: hz_dup_batch db,
1524: hz_dup_sets dset,
1525: hz_parties tp
1526: WHERE mb.batch_id = p_batch_id
1527: AND tp.party_id = l_merge_to_party_id
1528: AND mb.batch_id = dset.dup_set_id (+)
1529: AND db.dup_batch_id (+)= dset.dup_batch_id

Line 1819: p_owner_table_name => 'HZ_PARTIES',

1815: -- SSM for party obj
1816: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1817: (p_init_msg_list => fnd_api.g_false,
1818: p_owner_table_id => x_party_merge_obj.merge_to_party_obj.party_id,
1819: p_owner_table_name => 'HZ_PARTIES',
1820: p_action_type => NULL,
1821: x_orig_sys_ref_objs => x_party_merge_obj.merge_to_party_obj.orig_sys_objs,
1822: x_return_status => x_return_status,
1823: x_msg_count => x_msg_count,

Line 1835: p_owner_table_name => 'HZ_PARTIES',

1831:
1832: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1833: (p_init_msg_list => fnd_api.g_false,
1834: p_owner_table_id => x_party_merge_obj.merge_from_party_objs(I).party_id,
1835: p_owner_table_name => 'HZ_PARTIES',
1836: p_action_type => NULL,
1837: x_orig_sys_ref_objs => x_party_merge_obj.merge_from_party_objs(I).orig_sys_objs,
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,