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_LOAD_BATCH_COUNTS_PKG dependencies on HZ_PARTY_SITES

Line 346: from hz_imp_tmp_errors e, hz_imp_addresses_sg sg,hz_party_sites hps,

342: and hzint.interface_status(+) = 'D'
343: union all
344: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
345: 1, nvl2(NVL(loc.location_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 10, 11),24)) a
346: from hz_imp_tmp_errors e, hz_imp_addresses_sg sg,hz_party_sites hps,
347: hz_orig_sys_references hosr,hz_locations loc, HZ_IMP_ADDRESSES_INT hzint
348: where sg.batch_mode_flag = p_batch_mode_flag
349: and sg.batch_id = p_batch_id
350: and sg.party_orig_system = p_original_system

Line 353: and hosr.owner_table_name(+) = 'HZ_PARTY_SITES'

349: and sg.batch_id = p_batch_id
350: and sg.party_orig_system = p_original_system
351: and hosr.orig_system(+) =sg.party_orig_system
352: and hosr.orig_system_reference(+) =sg.site_orig_system_reference
353: and hosr.owner_table_name(+) = 'HZ_PARTY_SITES'
354: and hosr.status(+) = 'A'
355: and hosr.owner_table_id = hps.party_site_id(+)
356: and hps.location_id = loc.location_id(+)
357: and e.int_row_id (+) = sg.int_row_id