DBA Data[Home] [Help]

APPS.JA_CN_FA_AC_EXPORT_PKG dependencies on FA_BOOKS

Line 425: fa_books bk,

421: faav.asset_key_ccid
422: FROM fa_additions_v faav
423: --, fa_asset_v fasv
424: ,
425: fa_books bk,
426: fa_book_controls_sec fbc,
427: fa_category_books fcb,
428: fa_methods mth,
429: fa_distribution_history fdh,

Line 779: FROM fa_books

775: ln_recoverable_cost,
776: lv_depn_meth_code,
777: ln_production_capacity,
778: ld_in_service_date
779: FROM fa_books
780: WHERE transaction_header_id_out = ln_transaction_header_id;
781: END IF; --(ln_transaction_header_id IS NOT NULL)
782: EXCEPTION
783: WHEN OTHERS THEN

Line 910: FROM fa_books fb

906: --get the cost, salvage value and unit before the retirement.
907: IF (ln_retire_tran_header_id IS NOT NULL) THEN
908: SELECT fb.cost, fb.salvage_value
909: INTO ln_original_value, ln_salvage_value
910: FROM fa_books fb
911: WHERE fb.transaction_header_id_out = ln_retire_tran_header_id;
912:
913: SELECT nvl(fds.deprn_reserve, 0),
914: nvl(fds.impairment_reserve, 0)