DBA Data[Home] [Help]

APPS.FA_XADJ_ITF_PKG dependencies on FA_ADDITIONS_B

Line 90: fa_additions_b fab

86: , fat.extended_depreciation_period period
87: , fat.posting_status status
88: , fat.extended_deprn_limit -- bug 6658280
89: from fa_adjustments_t fat,
90: fa_additions_b fab
91: where fat.asset_number = fab.asset_number
92: -- and fat.posting_status = 'POST'
93: and fat.batch_id = p_batch_id
94: and fab.asset_id >= l_start_range

Line 226: , fa_additions_b fab

222: select min(asset_id), max(asset_id)
223: into l_start_range
224: , l_end_range
225: from fa_adjustments_t fat
226: , fa_additions_b fab
227: where batch_id = p_batch_id
228: and fat.asset_number = fab.asset_number;
229:
230: when others then

Line 614: from fa_adjustments_t fat, fa_additions_b fab

610: select min(aid), max(aid), 0,
611: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
612: fab.asset_id aid, floor(rank()
613: over (order by fab.asset_id)/l_batch_size ) unit_id
614: from fa_adjustments_t fat, fa_additions_b fab
615: where batch_id = p_batch_id
616: and fat.asset_number = fab.asset_number)
617: group by unit_id;
618: