454: , fadd.asset_category_id
455: from fa_books fb
456: , fa_book_controls fbc
457: , fa_deprn_summary fds
458: , fa_additions fadd
459: where fb.book_type_code = fbc.book_type_code
460: and fb.book_type_code = fp_book_type_code
461: -- and fbc.last_period_counter = fp_period_counter
462: and fadd.asset_id = fp_asset_id
758: , fadd.asset_category_id
759: from fa_books fb
760: , fa_book_controls fbc
761: , fa_deprn_summary fds
762: , fa_additions fadd
763: where fb.book_type_code = fbc.book_type_code
764: and fb.book_type_code = fp_book_type_code
765: and fadd.asset_id = fp_asset_id
766: and fb.asset_id = fp_asset_id