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

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

297: CLOSE c1;
298: IF (is_using_allow_cust_attr = 'Y') THEN
299: OPEN x_contact_cur FOR
300: 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
301: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c
302: where a.batch_id = p_batch_id
303: and b.action_flag = 'I'
304: and b.int_row_id = a.rowid
305: and a.sub_orig_system_reference >= p_from_osr

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

310: and b.batch_mode_flag = p_batch_mode_flag
311: and a.interface_status is null
312: union all
313: 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
314: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c
315: where a.batch_id = p_batch_id
316: and b.action_flag = 'I'
317: and b.int_row_id = a.rowid
318: and a.sub_orig_system_reference >= p_from_osr

Line 327: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b

323: ;
324: ELSE
325: OPEN x_contact_cur FOR
326: 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
327: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
328: where a.batch_id = p_batch_id
329: and b.action_flag = 'I'
330: and b.int_row_id = a.rowid
331: and a.sub_orig_system_reference >= p_from_osr

Line 607: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c

603: END LOOP;
604: IF (is_using_allow_cust_attr = 'Y') THEN
605: OPEN x_contact_cur FOR
606: 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
607: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c
608: where a.batch_id = p_batch_id
609: and a.sub_orig_system_reference >= p_from_osr
610: and a.sub_orig_system_reference <= p_to_osr
611: and a.sub_orig_system_reference = c.party_orig_system_reference

Line 618: from HZ_IMP_CONTACTS_INT a

614: and a.sub_orig_system = l_os;
615: ELSE
616: OPEN x_contact_cur FOR
617: 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
618: from HZ_IMP_CONTACTS_INT a
619: where a.batch_id = p_batch_id
620: and a.sub_orig_system_reference >= p_from_osr
621: and a.sub_orig_system_reference <= p_to_osr
622: and a.sub_orig_system = l_os;