APPS.JA_CN_FA_RAI_EXPORT_PKG dependencies on FA_TRANSACTION_HISTORY_TRX_V

Line 257: fa_transaction_history_trx_v fthv

253: fa_books fb,
254: fa_distribution_history fdh,
255: fa_locations_kfv flk,
256: fa_book_controls_sec fbc,
257: fa_transaction_history_trx_v fthv
258: WHERE fb.date_ineffective IS NULL
259: AND fb.transaction_header_id_out IS NULL
260: --AND faav.asset_id = 109098
261: AND faav.asset_id = fb.asset_id

Line 409: FROM fa_transaction_history_trx_v fthv

405: lb_retirement_flag := FALSE; --reset the retirement flag.
406:
407: SELECT COUNT(*)
408: INTO ln_full_retirement_count
409: FROM fa_transaction_history_trx_v fthv
410: WHERE fthv.asset_id = lv_asset_id
411: AND fthv.book_type_code = lv_corp_book
412: AND fthv.transaction_type_code = 'FULL RETIREMENT'
413: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 426: FROM fa_transaction_history_trx_v fthv

422:
423: --Check the reinstatement of the asset.
424: SELECT COUNT(*)
425: INTO ln_reinstate_count
426: FROM fa_transaction_history_trx_v fthv
427: WHERE fthv.asset_id = lv_asset_id
428: AND fthv.book_type_code = lv_corp_book
429: AND fthv.transaction_type_code = 'REINSTATEMENT'
430: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 444: FROM fa_transaction_history_trx_v fthv

440: ELSE
441: --Retireve the greatest effective date of retirement. ---TODO get the real accouting retirement date.
442: SELECT greatest(date_effective)
443: INTO ld_retirement_date
444: FROM fa_transaction_history_trx_v fthv
445: WHERE fthv.asset_id = lv_asset_id
446: AND fthv.book_type_code = lv_corp_book
447: AND fthv.transaction_type_code = 'FULL RETIREMENT'
448: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 460: FROM fa_transaction_history_trx_v fthv

456: ld_end_date);
457: --Retireve the greatest effective date of reinstatement.
458: SELECT greatest(date_effective)
459: INTO ld_reinstated_date
460: FROM fa_transaction_history_trx_v fthv
461: WHERE fthv.asset_id = lv_asset_id
462: AND fthv.book_type_code = lv_corp_book
463: AND fthv.transaction_type_code = 'REINSTATEMENT'
464: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,