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_AIA_CUSTOM_PKG dependencies on HZ_MERGE_PARTIES

Line 293: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,

289: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL
290: ) IS
291: CURSOR get_related_org_cust(l_batch_id NUMBER) IS
292: SELECT distinct cr.cust_account_id, r2.object_id
293: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,
294: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,
295: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2
296: where mb.batch_id = l_batch_id
297: and mb.batch_id = mp.batch_id

Line 394: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph, HZ_MERGE_DICTIONARY md, HZ_PARTIES p

390: WHERE party_id = p_merge_to_party_id;
391:
392: CURSOR get_merge_parties(l_batch_id NUMBER) IS
393: SELECT p.party_type, from_parent_entity_id, from_entity_id, to_parent_entity_id
394: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph, HZ_MERGE_DICTIONARY md, HZ_PARTIES p
395: where mb.batch_id = l_batch_id
396: and mb.batch_id = mp.batch_id
397: and mp.batch_party_id = mph.batch_party_id
398: and mph.merge_dict_id = md.merge_dict_id

Line 422: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,

418: null, -- from common_obj_id
419: cs.cust_account_id, -- to cust_acct_id
420: mph.to_parent_entity_id, -- to party_site_id
421: null ) -- to common_obj_id
422: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,
423: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCT_SITES_ALL cs
424: where mb.batch_id = l_batch_id
425: and mb.batch_id = mp.batch_id
426: and mp.batch_party_id = mph.batch_party_id

Line 442: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,

438: null, -- from common_obj_id
439: cr.cust_account_id, -- to cust_acct_site_id
440: oc2.org_contact_id, -- to party_site_id
441: null ) -- to common_obj_id
442: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,
443: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,
444: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2
445: where mb.batch_id = l_batch_id
446: and mb.batch_id = mp.batch_id

Line 482: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,

478: null, -- from common_obj_id
479: cr.cust_account_id, -- to cust_acct_site_id
480: oc2.org_contact_id, -- to org_contact_id
481: r2.object_id) -- to party_id
482: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,
483: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,
484: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2
485: where mb.batch_id = l_batch_id
486: and mb.batch_id = mp.batch_id