335: ad.asset_type ,
336: ad.current_units ,
337: mcbc.set_of_books_id
338: from fa_transaction_headers th,
339: fa_mc_deprn_periods dp,
340: fa_mc_books bk,
341: fa_additions_b ad,
342: fa_category_books cb,
343: fa_book_controls bc,
874: fa_book_controls bc,
875: fa_category_books cb,
876: fa_mc_book_controls mcbc,
877: fa_mc_deprn_summary ds,
878: fa_mc_deprn_periods dp
879: where th.rowid between p_start_rowid and p_end_rowid
880: and bc.book_type_code = th.book_type_code
881: and nvl(bc.date_ineffective, sysdate) <= sysdate
882: and bc.book_type_code = cb.book_type_code