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_CUST_ACCOUNTS

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 187: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

183: -- SSM for merge to account obj
184: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
185: (p_init_msg_list => fnd_api.g_false,
186: p_owner_table_id => x_account_merge_obj.merge_to_account_obj.cust_acct_id,
187: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
188: p_action_type => NULL,
189: x_orig_sys_ref_objs => x_account_merge_obj.merge_to_account_obj.orig_sys_objs,
190: x_return_status => x_return_status,
191: x_msg_count => x_msg_count,

Line 203: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

199:
200: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
201: (p_init_msg_list => fnd_api.g_false,
202: p_owner_table_id => x_account_merge_obj.merge_from_account_objs(I).cust_acct_id,
203: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
204: p_action_type => NULL,
205: x_orig_sys_ref_objs => x_account_merge_obj.merge_from_account_objs(I).orig_sys_objs,
206: x_return_status => x_return_status,
207: x_msg_count => x_msg_count,

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

Line 524: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

520: ATTRIBUTE20
521: )
522: FROM HZ_ORIG_SYS_REFERENCES
523: WHERE OWNER_TABLE_ID = cm.duplicate_id
524: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
525: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
526: cm.customer_id,
527: CAST(MULTISET(
528: SELECT HZ_ORIG_SYS_REF_OBJ(

Line 570: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

566: ATTRIBUTE20
567: )
568: FROM HZ_ORIG_SYS_REFERENCES
569: WHERE OWNER_TABLE_ID = cm.customer_id
570: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
571: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
572: )
573: FROM (SELECT distinct duplicate_address_id, customer_address_id,
574: duplicate_id, customer_id, org_id, customer_createsame

Line 947: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

943: ATTRIBUTE20
944: )
945: FROM HZ_ORIG_SYS_REFERENCES
946: WHERE OWNER_TABLE_ID = duplicate_id
947: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
948: )AS HZ_ORIG_SYS_REF_OBJ_TBL),
949: customer_id,
950: CAST(MULTISET(
951: SELECT HZ_ORIG_SYS_REF_OBJ(

Line 993: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'

989: ATTRIBUTE20
990: )
991: FROM HZ_ORIG_SYS_REFERENCES
992: WHERE OWNER_TABLE_ID = customer_id
993: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
994: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
995: )
996: FROM hz_cust_acct_relate_all_m crelf, hz_cust_acct_relate_all crelt
997: WHERE ((crelf.cust_account_id = duplicate_id

Line 1084: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1080: -- SSM for merge to account obj
1081: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1082: (p_init_msg_list => fnd_api.g_false,
1083: p_owner_table_id => x_account_merge_v2_obj.merge_to_account_obj.cust_acct_id,
1084: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1085: p_action_type => NULL,
1086: x_orig_sys_ref_objs => x_account_merge_v2_obj.merge_to_account_obj.orig_sys_objs,
1087: x_return_status => x_return_status,
1088: x_msg_count => x_msg_count,

Line 1100: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1096:
1097: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1098: (p_init_msg_list => fnd_api.g_false,
1099: p_owner_table_id => x_account_merge_v2_obj.merge_from_account_objs(I).cust_acct_id,
1100: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1101: p_action_type => NULL,
1102: x_orig_sys_ref_objs => x_account_merge_v2_obj.merge_from_account_objs(I).orig_sys_objs,
1103: x_return_status => x_return_status,
1104: x_msg_count => x_msg_count,

Line 1169: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1165: ELSE
1166: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1167: (p_init_msg_list => fnd_api.g_false,
1168: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).from_parent_object_id,
1169: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1170: p_action_type => NULL,
1171: x_orig_sys_ref_objs => x_account_merge_v2_obj.customer_profile_objs(I).from_parent_obj_sys_ref_objs,
1172: x_return_status => x_return_status,
1173: x_msg_count => x_msg_count,

Line 1183: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1179:
1180: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1181: (p_init_msg_list => fnd_api.g_false,
1182: p_owner_table_id => x_account_merge_v2_obj.customer_profile_objs(I).to_parent_object_id,
1183: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1184: p_action_type => NULL,
1185: x_orig_sys_ref_objs => x_account_merge_v2_obj.customer_profile_objs(I).to_parent_obj_sys_ref_objs,
1186: x_return_status => x_return_status,
1187: x_msg_count => x_msg_count,

Line 1242: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1238: ELSE
1239: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1240: (p_init_msg_list => fnd_api.g_false,
1241: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).from_parent_object_id,
1242: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1243: p_action_type => NULL,
1244: x_orig_sys_ref_objs => x_account_merge_v2_obj.cust_profile_amt_objs(I).from_parent_obj_sys_ref_objs,
1245: x_return_status => x_return_status,
1246: x_msg_count => x_msg_count,

Line 1256: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1252:
1253: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1254: (p_init_msg_list => fnd_api.g_false,
1255: p_owner_table_id => x_account_merge_v2_obj.cust_profile_amt_objs(I).to_parent_object_id,
1256: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1257: p_action_type => NULL,
1258: x_orig_sys_ref_objs => x_account_merge_v2_obj.cust_profile_amt_objs(I).to_parent_obj_sys_ref_objs,
1259: x_return_status => x_return_status,
1260: x_msg_count => x_msg_count,

Line 1344: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1340: ELSE
1341: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1342: (p_init_msg_list => fnd_api.g_false,
1343: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).from_parent_object_id,
1344: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1345: p_action_type => NULL,
1346: x_orig_sys_ref_objs => x_account_merge_v2_obj.acct_role_objs(I).from_parent_obj_sys_ref_objs,
1347: x_return_status => x_return_status,
1348: x_msg_count => x_msg_count,

Line 1358: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

1354:
1355: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
1356: (p_init_msg_list => fnd_api.g_false,
1357: p_owner_table_id => x_account_merge_v2_obj.acct_role_objs(I).to_parent_object_id,
1358: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
1359: p_action_type => NULL,
1360: x_orig_sys_ref_objs => x_account_merge_v2_obj.acct_role_objs(I).to_parent_obj_sys_ref_objs,
1361: x_return_status => x_return_status,
1362: x_msg_count => x_msg_count,