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_CONTACTS_SG

Line 264: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b

260: and a.batch_id = c.batch_id
261: and b.action_flag = 'I' );
262: log( ' Update contacts as same match rule being used');
263: update HZ_SRCH_CONTACTS c set party_id = ( select b.sub_id
264: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
265: where a.rowid = b.int_row_id
266: and c.int_row_id = a.rowid
267: and a.batch_id = p_batch_id
268: and a.batch_id = c.batch_id

Line 271: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b

267: and a.batch_id = p_batch_id
268: and a.batch_id = c.batch_id
269: and b.action_flag = 'I' ),
270: org_contact_id = (select b.contact_id
271: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
272: where a.rowid = b.int_row_id
273: and a.batch_id = p_batch_id
274: and a.batch_id = c.batch_id
275: and b.action_flag = 'I' );

Line 526: from HZ_IMP_CONTACTS_SG a, HZ_IMP_CONTACTS_INT b

522: and a.batch_id = p_batch_id);
523: ELSIF (p_et_name = 'CONTACTS') THEN
524: delete from HZ_SRCH_CONTACTS c where c.contact_os ||c.contact_osr || c.batch_id in(
525: select b.contact_orig_system || b.contact_orig_system_reference || b.batch_id
526: from HZ_IMP_CONTACTS_SG a, HZ_IMP_CONTACTS_INT b
527: where a.int_row_id = b.rowid
528: and a.action_flag = 'U'
529: and b.contact_orig_system = c.contact_os
530: and b.contact_orig_system_reference = c.contact_osr

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 2732: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c ');

2728: l(' a.site_orig_system, a.site_orig_system_reference, ');
2729: l(' a.contact_orig_system, a.contact_orig_system_reference, ');
2730: l(' a.contact_number, a.title, c.party_name as person_name ');
2731: */
2732: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c ');
2733: l(' where a.batch_id = p_batch_id ');
2734: l(' and b.action_flag = ''I'' ');
2735: l(' and b.int_row_id = a.rowid ');
2736: l(' and a.sub_orig_system_reference >= p_from_osr ');

Line 2760: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b ');

2756: l(' a.site_orig_system, a.site_orig_system_reference, ');
2757: l(' a.contact_orig_system, a.contact_orig_system_reference, ');
2758: l(' a.contact_number, a.title, null person_name ');
2759: */
2760: l(' from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b ');
2761: l(' where a.batch_id = p_batch_id ');
2762: l(' and b.action_flag = ''I'' ');
2763: l(' and b.int_row_id = a.rowid ');
2764: /* l(' and b.contact_orig_system = a.contact_orig_system ');