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 124: ,fa_adjustments fadj

120: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount
121: , fadj.adjustment_amount), 0)),0) additions
122: INTO ln_amount
123: FROM fa_transaction_headers fth
124: ,fa_adjustments fadj
125: ,fa_asset_history fah
126: ,fa_distribution_history fdh
127: WHERE fth.asset_id = fah.asset_id
128: AND fth.asset_id = fdh.asset_id

Line 188: ,fa_adjustments fadj

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

Line 243: ,fa_adjustments fadj

239: INTO ln_amount
240: FROM (
241: SELECT NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount),0) all_transferred
242: FROM fa_transaction_headers fth
243: ,fa_adjustments fadj
244: ,fa_asset_history fah1
245: ,fa_distribution_history fdh
246: WHERE EXISTS (
247: SELECT 1

Line 285: ,fa_adjustments fadj

281: UNION ALL -- Added this query as part of the fix to the SR 7284007.992
282: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount
283: , fadj.adjustment_amount),0)),0) all_transferred
284: FROM fa_transaction_headers fth
285: ,fa_adjustments fadj
286: ,fa_asset_history fah
287: ,fa_distribution_history fdh
288: WHERE fth.asset_id = fah.asset_id
289: AND fth.asset_id = fdh.asset_id

Line 320: ,fa_adjustments fadj

316: UNION ALL
317: SELECT (-1)*(NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount -- Added this query as part of the fix to the SR 7284007.992
318: , fadj.adjustment_amount), 0)),0)) all_transferred
319: FROM fa_transaction_headers fth
320: ,fa_adjustments fadj
321: ,fa_asset_history fah
322: ,fa_distribution_history fdh
323: WHERE fth.asset_id = fah.asset_id
324: AND fth.asset_id = fdh.asset_id

Line 355: ,fa_adjustments fadj

351: ))
352: UNION ALL
353: SELECT NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount),0) all_transferred
354: FROM fa_transaction_headers fth
355: ,fa_adjustments fadj
356: ,fa_asset_history fah1
357: ,fa_asset_history fah2
358: ,fa_distribution_history fdh
359: WHERE EXISTS (

Line 427: ,fa_adjustments fadj

423: BEGIN
424: SELECT NVL(SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount)),0)
425: INTO ln_amount
426: FROM fa_transaction_headers fth
427: ,fa_adjustments fadj
428: ,fa_asset_history fah
429: ,fa_distribution_history fdh
430: WHERE fth.asset_id = fah.asset_id
431: AND fth.asset_id = fdh.asset_id

Line 478: ,fa_adjustments fadj

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

Line 755: FROM fa_adjustments fadj

751: ,fadj.period_counter_created
752: ,SUM(DECODE(fth.transaction_subtype,'APPREC',0,
753: DECODE(fadj.debit_credit_flag,'CR',-1*fadj.adjustment_amount
754: ,fadj.adjustment_amount))) adjustment_amount
755: FROM fa_adjustments fadj
756: ,fa_transaction_headers fth
757: WHERE fadj.transaction_header_id = fth.transaction_header_id(+)
758: and fth.transaction_type_code IN ('ADJUSTMENT','ADDITION')
759: and fadj.adjustment_type(+) = 'EXPENSE'

Line 806: ,fa_adjustments fadj

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