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 CRMINTEG_HZ_MRGDTIL_OBJ_TBL

Line 155: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ),

151: and rm.duplicate_address_id = cas.cust_acct_site_id(+)
152: and rm.customer_address_id = cas2.cust_acct_site_id(+)
153: group by rm.duplicate_address_id, rm.customer_address_id,
154: cas.party_site_id, cas2.party_site_id
155: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ),
156: CAST(MULTISET(
157: SELECT CRMINTEG_HZ_MRGDTIL_OBJ(
158: 'CONTACT',
159: 'N',

Line 176: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))

172: and car.party_id = rel.party_id(+)
173: and rel.relationship_id = oc.party_relationship_id(+)
174: group by carm.cust_account_role_id, car.cust_account_role_id,
175: ocm.org_contact_id, oc.org_contact_id
176: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
177: from RA_CUSTOMER_MERGE_HEADERS mh, HZ_CUST_ACCOUNTS ca, HZ_CUST_ACCOUNTS ca2
178: where mh.customer_merge_header_id = l_customer_merge_header_id
179: and mh.process_flag = 'Y'
180: and mh.duplicate_id = ca.cust_account_id(+)

Line 431: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ),

427: and mph.merge_dict_id = md.merge_dict_id
428: and cs.cust_acct_site_id = mph.from_entity_id
429: and cs.cust_account_id = l_fcaid
430: and md.entity_name = 'HZ_CUST_ACCT_SITES_ALL'
431: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ),
432: CAST(MULTISET(
433: SELECT CRMINTEG_HZ_MRGDTIL_OBJ(
434: 'CONTACT',
435: 'N',

Line 458: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))

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
462: SELECT CRMINTEG_HZ_MERGE_OBJ(

Line 471: CRMINTEG_HZ_MRGDTIL_OBJ_TBL(),

467: null, -- to cust_acct_id
468: null, -- to party_id
469: null, -- to common_obj_id
470: 'N',
471: CRMINTEG_HZ_MRGDTIL_OBJ_TBL(),
472: CAST(MULTISET(
473: SELECT CRMINTEG_HZ_MRGDTIL_OBJ(
474: 'CONTACT',
475: 'N',

Line 498: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))

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);
502: l_party_type VARCHAR2(30);