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_PARTIES_INT

Line 91: from hz_imp_parties_int a, hz_imp_parties_sg b

87: BEGIN
88: -- query for interface to TCA
89: open p_party_cur FOR
90: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, b.party_id, a.rowid, a.party_type
91: from hz_imp_parties_int a, hz_imp_parties_sg b
92: where b.action_flag = 'I'
93: and b.int_row_id = a.rowid
94: and a.batch_id = p_batch_id
95: and b.party_orig_system_reference >= p_from_osr

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 404: from hz_imp_parties_int a

400: BEGIN
401: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
402: open p_party_cur FOR
403: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, a.rowid, a.party_type , a.party_id
404: from hz_imp_parties_int a
405: where a.batch_id = p_batch_id
406: and a.party_orig_system_reference >= p_from_osr
407: and a.party_orig_system_reference <= p_to_osr
408: and a.party_orig_system = l_os;

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