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_ORG_CONTACTS

Line 166: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCOUNT_ROLES_M carm, HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS relm, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS ocm, HZ_ORG_CONTACTS oc

162: null, -- from common_obj_id
163: car.cust_account_role_id, -- to cust_acct_role_id
164: oc.org_contact_id, -- to org_contact_id
165: null ) -- to common_obj_id
166: from RA_CUSTOMER_MERGES rm, HZ_CUST_ACCOUNT_ROLES_M carm, HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS relm, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS ocm, HZ_ORG_CONTACTS oc
167: where rm.customer_merge_header_id = p_customer_merge_header_id
168: and rm.customer_merge_header_id = carm.customer_merge_header_id(+)
169: and carm.party_id = relm.party_id(+)
170: and relm.relationship_id = ocm.party_relationship_id(+)

Line 294: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,

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
298: and mp.merge_reason_code = 'DUPLICATE_RELN_PARTY'

Line 295: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2

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
298: and mp.merge_reason_code = 'DUPLICATE_RELN_PARTY'
299: and mp.batch_party_id = mph.batch_party_id

Line 443: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,

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
447: and mp.batch_party_id = mph.batch_party_id

Line 444: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2

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
447: and mp.batch_party_id = mph.batch_party_id
448: and mph.merge_dict_id = md.merge_dict_id

Line 483: HZ_MERGE_DICTIONARY md, HZ_CUST_ACCOUNT_ROLES cr, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc,

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
487: and mp.merge_reason_code = 'DUPLICATE_RELN_PARTY'

Line 484: HZ_RELATIONSHIPS r2, HZ_ORG_CONTACTS oc2

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
487: and mp.merge_reason_code = 'DUPLICATE_RELN_PARTY'
488: and mp.batch_party_id = mph.batch_party_id

Line 588: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp

584: AND primary_flag = 'Y';
585:
586: CURSOR get_occp_id(l_oc_id NUMBER) IS
587: SELECT cp.contact_point_id
588: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp
589: WHERE cp.owner_table_name = 'HZ_PARTIES'
590: AND cp.contact_point_type = 'EMAIL'
591: AND cp.owner_table_id = r.party_id
592: AND cp.primary_flag = 'Y'

Line 779: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp

775: AND primary_flag = 'Y';
776:
777: CURSOR get_occp_id(l_oc_id NUMBER) IS
778: SELECT cp.contact_point_id
779: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r, HZ_CONTACT_POINTS cp
780: WHERE cp.owner_table_name = 'HZ_PARTIES'
781: AND cp.contact_point_type = 'EMAIL'
782: AND cp.owner_table_id = r.party_id
783: AND cp.primary_flag = 'Y'