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_CUST_ACCOUNT_ROLES

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 308: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES';

304: and r.subject_Type = 'PERSON' and r.object_type = 'ORGANIZATION'
305: and r2.party_id = mp.to_party_id
306: and r2.relationship_id = oc2.party_relationship_id
307: and r2.subject_Type = 'PERSON' and r2.object_type = 'ORGANIZATION'
308: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES';
309:
310: l_ca_id NUMBER;
311: l_org_id NUMBER;
312: i NUMBER;

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 457: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'

453: and r.subject_Type = 'PERSON' and r.object_type = 'ORGANIZATION'
454: and r2.party_id = mph.to_parent_entity_id
455: and r2.relationship_id = oc2.party_relationship_id
456: and r2.subject_Type = 'PERSON' and r2.object_type = 'ORGANIZATION'
457: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'
458: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
459: from dual;
460:
461: CURSOR get_person_merge_detail(l_batch_id NUMBER, l_party_type VARCHAR2) IS

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 497: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'

493: and r.subject_Type = 'PERSON' and r.object_type = 'ORGANIZATION'
494: and r2.party_id = mp.to_party_id
495: and r2.relationship_id = oc2.party_relationship_id
496: and r2.subject_Type = 'PERSON' and r2.object_type = 'ORGANIZATION'
497: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'
498: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
499: from dual;
500:
501: l_debug_prefix VARCHAR2(30);

Line 807: FROM HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS r

803: AND rownum = 1;
804:
805: CURSOR get_cac_id(l_per_id NUMBER, l_ca_id NUMBER) IS
806: SELECT car.cust_account_role_id
807: FROM HZ_CUST_ACCOUNT_ROLES car, HZ_RELATIONSHIPS r
808: WHERE car.cust_account_id = l_ca_id
809: AND car.party_id = r.party_id
810: AND r.subject_id = l_per_id
811: AND r.subject_type = 'PERSON'