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_ADJUSTMENTS

Line 183: ,fa_adjustments fadj

179: SELECT SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount
180: , fadj.adjustment_amount), 0)) additions
181: INTO ln_amount
182: FROM fa_transaction_headers fth
183: ,fa_adjustments fadj
184: ,fa_asset_history fah
185: ,fa_distribution_history fdh
186: WHERE fth.asset_id = fah.asset_id
187: AND fth.asset_id = fdh.asset_id

Line 240: ,fa_adjustments fadj

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
243: WHERE fth.asset_id = fah.asset_id
244: AND fth.asset_id = fdh.asset_id

Line 294: ,fa_adjustments fadj

290: INTO ln_amount
291: FROM (
292: SELECT DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount) all_transferred
293: FROM fa_transaction_headers fth
294: ,fa_adjustments fadj
295: ,fa_asset_history fah1
296: ,fa_distribution_history fdh
297: WHERE EXISTS (
298: SELECT 1

Line 335: ,fa_adjustments fadj

331: AND fth.transaction_header_id < NVL(fah1.transaction_header_id_out, fth.transaction_header_id + 1)
332: UNION ALL
333: SELECT DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount) all_transferred
334: FROM fa_transaction_headers fth
335: ,fa_adjustments fadj
336: ,fa_asset_history fah1
337: ,fa_asset_history fah2
338: ,fa_distribution_history fdh
339: WHERE EXISTS (

Line 409: ,fa_adjustments fadj

405: BEGIN
406: SELECT SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount))
407: INTO ln_amount
408: FROM fa_transaction_headers fth
409: ,fa_adjustments fadj
410: ,fa_asset_history fah
411: ,fa_distribution_history fdh
412: WHERE fth.asset_id = fah.asset_id
413: AND fth.asset_id = fdh.asset_id

Line 459: ,fa_adjustments fadj

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
462: WHERE fth.asset_id = fah.asset_id
463: AND fth.asset_id = fdh.asset_id

Line 732: FROM fa_adjustments fadj

728: ,fadj.period_counter_created
729: ,SUM(DECODE(fth.transaction_subtype,'APPREC',0,
730: DECODE(fadj.debit_credit_flag,'CR',-1*fadj.adjustment_amount
731: ,fadj.adjustment_amount))) adjustment_amount
732: FROM fa_adjustments fadj
733: ,fa_transaction_headers fth
734: WHERE fadj.transaction_header_id = fth.transaction_header_id(+)
735: and fth.transaction_type_code IN ('ADJUSTMENT','ADDITION')
736: and fadj.adjustment_type(+) = 'EXPENSE'

Line 782: ,fa_adjustments fadj

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
785: WHERE fth.asset_id = fah.asset_id
786: AND fth.asset_id = fdh.asset_id