APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FA_BOOKS

Line 238: FROM fa_books fb

234: BEGIN
235: BEGIN
236: SELECT SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)) retirements
237: INTO ln_amount
238: FROM fa_books fb
239: ,fa_transaction_headers fth
240: ,fa_adjustments fadj
241: ,fa_asset_history fah
242: ,fa_distribution_history fdh

Line 308: FROM fa_books fb2

304: AND (fah1.asset_type = p_asset_type_in
305: OR (fah1.asset_type = 'CIP'
306: AND EXISTS (
307: SELECT period_counter_capitalized
308: FROM fa_books fb2
309: WHERE fb2.asset_id = fah1.asset_id
310: AND fb2.book_type_code = P_BOOK_NAME
311: AND fb2.period_counter_capitalized < gn_lex_begin_period_counter
312: )))

Line 350: FROM fa_books fb2

346: AND (fah1.asset_type = p_asset_type_in
347: OR (fah1.asset_type = 'CIP'
348: AND EXISTS (
349: SELECT fb2.period_counter_capitalized
350: FROM fa_books fb2
351: WHERE fb2.asset_id = fah1.asset_id
352: AND fb2.book_type_code = P_BOOK_NAME
353: AND fb2.period_counter_capitalized < gn_lex_begin_period_counter
354: )

Line 457: FROM fa_books fb

453: BEGIN
454: BEGIN
455: SELECT SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount))
456: INTO ln_amount
457: FROM fa_books fb
458: ,fa_transaction_headers fth
459: ,fa_adjustments fadj
460: ,fa_asset_history fah
461: ,fa_distribution_history fdh

Line 547: ,fa_books fb

543: INTO ln_amount
544: FROM fa_deprn_summary fds
545: ,fa_deprn_detail fdd
546: ,fa_distribution_history fdh
547: ,fa_books fb
548: WHERE fds.book_type_code = fdd.book_type_code
549: AND fds.asset_id = fdd.asset_id
550: AND fds.period_counter = fdd.period_counter
551: AND fdd.distribution_id = fdh.distribution_id

Line 683: FROM fa_books fb

679: BEGIN
680: BEGIN
681: SELECT fdd.deprn_reserve
682: INTO ln_amount
683: FROM fa_books fb
684: ,fa_deprn_summary fds
685: ,fa_deprn_detail fdd
686: ,fa_distribution_history fdh
687: WHERE fb.book_type_code = P_BOOK_NAME

Line 780: FROM fa_books fb

776: BEGIN
777: BEGIN
778: SELECT SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)) retirements
779: INTO ln_amount
780: FROM fa_books fb
781: ,fa_transaction_headers fth
782: ,fa_adjustments fadj
783: ,fa_asset_history fah
784: ,fa_distribution_history fdh