APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 36: FROM HZ_IMP_ADDRESSES_INT INT

32: FROM HZ_IMP_ADDRESSUSES_INT INT
33: WHERE INT.BATCH_ID = P_BATCH_ID AND
34: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
35: SELECT count(INT.BATCH_ID) into l_ADDRESSES_IN_BATCH
36: FROM HZ_IMP_ADDRESSES_INT INT
37: WHERE INT.BATCH_ID = P_BATCH_ID AND
38: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
39: SELECT count(INT.BATCH_ID) into l_FINNUMBERS_IN_BATCH
40: FROM HZ_IMP_FINNUMBERS_INT INT

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

Line 359: and e.interface_table_name (+) = 'HZ_IMP_ADDRESSES_INT'

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
358: and e.request_id (+) = p_request_id
359: and e.interface_table_name (+) = 'HZ_IMP_ADDRESSES_INT'
360: --and hps.party_site_id (+) = sg.party_site_id
361: and loc.request_id (+) = p_request_id
362: and sg.int_row_id = hzint.rowid (+)
363: and hzint.interface_status(+) = 'D'

Line 664: FROM HZ_IMP_ADDRESSES_INT INT, HZ_IMP_ADDRESSES_SG SG

660: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
661: AND INT.ACTION_FLAG = 'I' ;
662: -- for l_NEW_UNIQUE_ADDRESSES
663: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_ADDRESSES
664: FROM HZ_IMP_ADDRESSES_INT INT, HZ_IMP_ADDRESSES_SG SG
665: WHERE INT.BATCH_ID = P_BATCH_ID AND
666: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM AND
667: INT.BATCH_ID = SG.BATCH_ID AND
668: INT.PARTY_ORIG_SYSTEM = SG.PARTY_ORIG_SYSTEM AND

Line 809: FROM HZ_IMP_ADDRESSES_INT INT

805: WHERE INT.BATCH_ID = P_BATCH_ID AND
806: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
807: AND INT.INTERFACE_STATUS = 'R' ;
808: SELECT count(INT.BATCH_ID) into l_REMOVED_ADDRESSES
809: FROM HZ_IMP_ADDRESSES_INT INT
810: WHERE INT.BATCH_ID = P_BATCH_ID AND
811: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
812: AND INT.INTERFACE_STATUS = 'R' ;
813: SELECT count(INT.BATCH_ID) into l_REMOVED_FINNUMBERS