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_DQM_STAGE dependencies on HZ_IMP_PARTIES_INT

Line 256: from hz_imp_parties_int a, hz_imp_parties_sg b

252: END IF;
253: -- - Update IDs on PARTY, CONTACTS, CONTACT_POINTS
254: log( ' Update party as same match rule being used');
255: update hz_srch_parties c set party_id = ( select b.party_id
256: from hz_imp_parties_int a, hz_imp_parties_sg b
257: where a.rowid = b.int_row_id
258: and c.int_row_id = a.rowid
259: and a.batch_id = p_batch_id
260: and a.batch_id = c.batch_id

Line 931: p_table_name := 'HZ_IMP_PARTIES_INT';

927: ) IS
928: l_procedure_name VARCHAR2(30) := 'GET_TABLE_NAME';
929: BEGIN
930: IF ((p_entity_name = 'PARTY') OR (p_entity_name = 'HZ_STAGED_PARTIES')) THEN
931: p_table_name := 'HZ_IMP_PARTIES_INT';
932: ELSIF ((p_entity_name = 'PARTY_SITES') OR (p_entity_name = 'HZ_STAGED_PARTY_SITES')) THEN
933: p_table_name := 'HZ_IMP_ADDRESSES_INT';
934: ELSIF ((p_entity_name = 'CONTACTS') OR (p_entity_name = 'HZ_STAGED_CONTACTS')) THEN
935: p_table_name := 'HZ_IMP_CONTACTS_INT';

Line 1987: l(' from hz_imp_parties_int a, hz_imp_parties_sg b ');

1983: END IF;
1984: l_sel_str := '';
1985: -- select a.organization_name, a.duns_number_c, a.tax_reference,
1986: -- a.party_orig_system, a.party_orig_system_reference, b.party_id
1987: l(' from hz_imp_parties_int a, hz_imp_parties_sg b ');
1988: l(' where b.action_flag = ''I''');
1989: l(' and b.int_row_id = a.rowid ');
1990: l(' and a.batch_id = p_batch_id ');
1991: l(' and b.party_orig_system_reference >= p_from_osr ');

Line 2136: l(' from hz_imp_parties_int a ');

2132: l_sel_str := '';
2133: /* select a.organization_name, a.duns_number_c, a.tax_reference,
2134: a.party_orig_system, a.party_orig_system_reference
2135: */
2136: l(' from hz_imp_parties_int a ');
2137: l(' where a.batch_id = p_batch_id ');
2138: l(' and a.party_orig_system_reference >= p_from_osr ');
2139: l(' and a.party_orig_system_reference <= p_to_osr ');
2140: l(' and a.party_orig_system = l_os; ');

Line 2705: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c ');

2701: l(' a.site_orig_system, a.site_orig_system_reference, ');
2702: l(' a.contact_orig_system, a.contact_orig_system_reference, ');
2703: l(' a.contact_number, a.title, c.person_first_name || '' '' || c.person_last_name as person_name ');
2704: */
2705: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c ');
2706: l(' where a.batch_id = p_batch_id ');
2707: l(' and b.action_flag = ''I'' ');
2708: l(' and b.int_row_id = a.rowid ');
2709: l(' and a.sub_orig_system_reference >= p_from_osr ');

Line 2846: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c ');

2842: a.site_orig_system, a.site_orig_system_reference,
2843: a.contact_orig_system, a.contact_orig_system_reference,
2844: a.contact_number, a.title, c.person_first_name || ' ' || c.person_last_name as person_name
2845: */
2846: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c ');
2847: l(' where a.batch_id = p_batch_id ');
2848: l(' and a.sub_orig_system_reference >= p_from_osr ');
2849: l(' and a.sub_orig_system_reference <= p_to_osr ');
2850: l(' and a.sub_orig_system_reference = c.party_orig_system_reference ');

Line 3769: EXECUTE IMMEDIATE 'select '||attr_name||' from HZ_IMP_PARTIES_INT where rownum=1';

3765: IF entity = 'PARTY' or entity = 'HZ_STAGED_PARTIES' THEN
3766: IF attr_name IN ('PARTY_NAME') THEN
3767: RETURN 'Y';
3768: END IF;
3769: EXECUTE IMMEDIATE 'select '||attr_name||' from HZ_IMP_PARTIES_INT where rownum=1';
3770: ELSIF entity = 'PARTY_SITES' or entity = 'HZ_STAGED_PARTY_SITES' THEN
3771: IF attr_name IN ('ADDRESS') THEN
3772: RETURN 'Y';
3773: END IF;

Line 3783: EXECUTE IMMEDIATE 'select '||attr_name||' from hz_imp_parties_int where rownum=1';

3779: BEGIN
3780: EXECUTE IMMEDIATE 'select '||attr_name||' from HZ_IMP_CONTACTS_INT where rownum=1';
3781: EXCEPTION
3782: WHEN OTHERS THEN
3783: EXECUTE IMMEDIATE 'select '||attr_name||' from hz_imp_parties_int where rownum=1';
3784: END;
3785: ELSIF entity = 'CONTACT_POINTS' or entity = 'HZ_STAGED_CONTACT_POINTS' THEN
3786: IF attr_name IN ('RAW_PHONE_NUMBER') THEN
3787: RETURN 'Y';