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_IMP_MATCH_RULE_52 dependencies on HZ_IMP_CONTACTS_INT

Line 302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c

298: CLOSE c1;
299: IF (is_using_allow_cust_attr = 'Y') THEN
300: OPEN x_contact_cur FOR
301: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id, c.person_first_name || ' ' || c.person_last_name as person_name
302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c
303: where a.batch_id = p_batch_id
304: and b.action_flag = 'I'
305: and b.int_row_id = a.rowid
306: and a.sub_orig_system_reference >= p_from_osr

Line 315: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c

311: and b.batch_mode_flag = p_batch_mode_flag
312: and a.interface_status is null
313: union all
314: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id, c.party_name as person_name
315: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c
316: where a.batch_id = p_batch_id
317: and b.action_flag = 'I'
318: and b.int_row_id = a.rowid
319: and a.sub_orig_system_reference >= p_from_osr

Line 328: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b

324: ;
325: ELSE
326: OPEN x_contact_cur FOR
327: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id
328: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
329: where a.batch_id = p_batch_id
330: and b.action_flag = 'I'
331: and b.int_row_id = a.rowid
332: and a.sub_orig_system_reference >= p_from_osr

Line 608: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c

604: END LOOP;
605: IF (is_using_allow_cust_attr = 'Y') THEN
606: OPEN x_contact_cur FOR
607: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, a.rowid, c.person_first_name || ' ' || c.person_last_name as person_name
608: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c
609: where a.batch_id = p_batch_id
610: and a.sub_orig_system_reference >= p_from_osr
611: and a.sub_orig_system_reference <= p_to_osr
612: and a.sub_orig_system_reference = c.party_orig_system_reference

Line 619: from HZ_IMP_CONTACTS_INT a

615: and a.sub_orig_system = l_os;
616: ELSE
617: OPEN x_contact_cur FOR
618: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, a.rowid, null person_name
619: from HZ_IMP_CONTACTS_INT a
620: where a.batch_id = p_batch_id
621: and a.sub_orig_system_reference >= p_from_osr
622: and a.sub_orig_system_reference <= p_to_osr
623: and a.sub_orig_system = l_os;