DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_LOCATIONS

Line 347: hz_orig_sys_references hosr,hz_locations loc, HZ_IMP_ADDRESSES_INT hzint

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
351: and hosr.orig_system(+) =sg.party_orig_system