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_ASSET_HISTORY

Line 58: ,fa_asset_history fah

54: SELECT NVL(fdd.cost,0)
55: INTO ln_amount
56: FROM fa_deprn_detail fdd
57: ,fa_distribution_history fdh
58: ,fa_asset_history fah
59: ,fa_transaction_headers fth
60: WHERE fdd.period_counter = (
61: SELECT MAX(fdd1.period_counter)
62: FROM fa_deprn_detail fdd1

Line 125: ,fa_asset_history fah

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
129: AND fdh.distribution_id = fadj.distribution_id

Line 152: FROM fa_asset_history fah1

148: AND fdh.code_combination_id = p_ccid_in
149: AND fdh.location_id = p_location_id_in
150: AND (fah.asset_type <> 'CAPITALIZED' OR ((fah.asset_type='CAPITALIZED') AND (NOT EXISTS (-- Added these lines as part of the fix to the SR 7284007.992
151: SELECT 'Y'
152: FROM fa_asset_history fah1
153: WHERE fah1.asset_type='CIP'
154: and fah1.transaction_header_id_out = fah.transaction_header_id_in
155: and fah1.asset_id = fah.asset_id
156: ))));

Line 189: ,fa_asset_history fah

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
193: AND fah.asset_type = p_asset_type_in

Line 244: ,fa_asset_history fah1

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
248: FROM fa_deprn_detail fdd

Line 286: ,fa_asset_history fah

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
290: AND fdh.distribution_id = fadj.distribution_id

Line 311: FROM fa_asset_history fah1

307: AND fdh.code_combination_id = p_ccid_in
308: AND fdh.location_id = p_location_id_in
309: AND ((fah.asset_type='CAPITALIZED') AND (EXISTS (-- Added these lines as part of the fix to the SR 7284007.992
310: SELECT 'Y'
311: FROM fa_asset_history fah1
312: WHERE fah1.asset_type='CIP'
313: and fah1.transaction_header_id_out = fah.transaction_header_id_in
314: and fah1.asset_id = fah.asset_id
315: )))

Line 321: ,fa_asset_history fah

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
325: AND fdh.distribution_id = fadj.distribution_id

Line 343: FROM fa_asset_history fah1

339: AND fdh.code_combination_id = p_ccid_in
340: AND fdh.location_id = p_location_id_in
341: AND (EXISTS (
342: SELECT 'Y'
343: FROM fa_asset_history fah1
344: ,fa_transaction_headers fth1
345: WHERE fah1.asset_type='CAPITALIZED'
346: AND fah1.transaction_header_id_in = fah.transaction_header_id_out
347: AND fah1.asset_id = fah.asset_id

Line 356: ,fa_asset_history fah1

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 (
360: SELECT 1

Line 357: ,fa_asset_history fah2

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 (
360: SELECT 1
361: FROM fa_deprn_detail fdd

Line 428: ,fa_asset_history fah

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
432: AND fdh.distribution_id = fadj.distribution_id

Line 479: ,fa_asset_history fah

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
483: AND fdh.distribution_id = fadj.distribution_id

Line 807: ,fa_asset_history fah

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
811: AND fah.asset_type = p_asset_type_in