eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FA_BOOKS

Line 186: FROM fa_books fb

182: BEGIN
183: BEGIN
184: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)),0) retirements
185: INTO ln_amount
186: FROM fa_books fb
187: ,fa_transaction_headers fth
188: ,fa_adjustments fadj
189: ,fa_asset_history fah
190: ,fa_distribution_history fdh

Line 257: FROM fa_books fb2

253: AND (fah1.asset_type = p_asset_type_in
254: OR (fah1.asset_type = 'CIP'
255: AND EXISTS (
256: SELECT period_counter_capitalized
257: FROM fa_books fb2
258: WHERE fb2.asset_id = fah1.asset_id
259: AND fb2.book_type_code = P_BOOK_NAME
260: AND fb2.period_counter_capitalized < gn_lex_begin_period_counter
261: )))

Line 370: FROM fa_books fb2

366: AND (fah1.asset_type = p_asset_type_in
367: OR (fah1.asset_type = 'CIP'
368: AND EXISTS (
369: SELECT fb2.period_counter_capitalized
370: FROM fa_books fb2
371: WHERE fb2.asset_id = fah1.asset_id
372: AND fb2.book_type_code = P_BOOK_NAME
373: AND fb2.period_counter_capitalized < gn_lex_begin_period_counter
374: )

Line 476: FROM fa_books fb

472: BEGIN
473: BEGIN
474: SELECT NVL(SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount)),0)
475: INTO ln_amount
476: FROM fa_books fb
477: ,fa_transaction_headers fth
478: ,fa_adjustments fadj
479: ,fa_asset_history fah
480: ,fa_distribution_history fdh

Line 567: ,fa_books fb

563: INTO ln_amount
564: FROM fa_deprn_summary fds
565: ,fa_deprn_detail fdd
566: ,fa_distribution_history fdh
567: ,fa_books fb
568: WHERE fds.book_type_code = fdd.book_type_code
569: AND fds.asset_id = fdd.asset_id
570: AND fds.period_counter = fdd.period_counter
571: AND fdd.distribution_id = fdh.distribution_id

Line 705: FROM fa_books fb

701: BEGIN
702: BEGIN
703: SELECT NVL(fdd.deprn_reserve,0)
704: INTO ln_amount
705: FROM fa_books fb
706: ,fa_deprn_summary fds
707: ,fa_deprn_detail fdd
708: ,fa_distribution_history fdh
709: WHERE fb.book_type_code = P_BOOK_NAME

Line 804: FROM fa_books fb

800: BEGIN
801: BEGIN
802: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)),0) retirements
803: INTO ln_amount
804: FROM fa_books fb
805: ,fa_transaction_headers fth
806: ,fa_adjustments fadj
807: ,fa_asset_history fah
808: ,fa_distribution_history fdh