DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_CONTACT_POINTS

Line 332: from hz_imp_tmp_errors e, hz_imp_contactpts_sg sg,hz_contact_points hcp, HZ_IMP_CONTACTPTS_INT hzint

328: and hzint.interface_status(+) = 'D'
329: union all
330: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
331: 1, nvl2(NVL(hcp.contact_point_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 8, 9),24)) a
332: from hz_imp_tmp_errors e, hz_imp_contactpts_sg sg,hz_contact_points hcp, HZ_IMP_CONTACTPTS_INT hzint
333: where sg.batch_mode_flag = p_batch_mode_flag
334: and sg.batch_id = p_batch_id
335: and sg.party_orig_system = p_original_system
336: and e.int_row_id (+) = sg.int_row_id