APPS.FA_ASSET_SUMM_RPT_PKG dependencies on FA_ASSET_HISTORY

Line 118: ,fa_asset_history fah

114: SELECT NVL(fdd.cost,0)
115: INTO ln_amount
116: FROM fa_deprn_detail fdd
117: ,fa_distribution_history fdh
118: ,fa_asset_history fah
119: ,fa_transaction_headers fth
120: WHERE fdd.period_counter = (
121: SELECT MAX(fdd1.period_counter)
122: FROM fa_deprn_detail fdd1

Line 184: ,fa_asset_history fah

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

Line 241: ,fa_asset_history fah

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

Line 295: ,fa_asset_history fah1

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

Line 336: ,fa_asset_history fah1

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

Line 337: ,fa_asset_history fah2

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 (
340: SELECT 1
341: FROM fa_deprn_detail fdd

Line 410: ,fa_asset_history fah

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

Line 460: ,fa_asset_history fah

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

Line 783: ,fa_asset_history fah

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