APPS.JA_CN_FA_ACUI_EXPORT_PKG dependencies on FA_TRANSACTION_HISTORY_TRX_V

Line 261: fa_transaction_history_trx_v fthv

257: FROM fa_additions_v faav,
258: fa_books fb,
259: fa_book_controls_sec fbc,
260: fa_distribution_history fdh,
261: fa_transaction_history_trx_v fthv
262: WHERE fb.date_ineffective IS NULL
263: AND fb.transaction_header_id_out IS NULL
264: AND faav.asset_id = fb.asset_id
265: --AND faav.asset_id = 109098

Line 497: FROM fa_transaction_history_trx_v fthv

493: ln_dep_prorate := 0;
494: --- Check the retirement of the asset
495: SELECT COUNT(*)
496: INTO ln_full_retirement_count
497: FROM fa_transaction_history_trx_v fthv
498: WHERE fthv.asset_id = lv_asset_id
499: AND fthv.book_type_code = lv_corp_book
500: AND fthv.transaction_type_code = 'FULL RETIREMENT'
501: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 514: FROM fa_transaction_history_trx_v fthv

510:
511: --Check the reinstatement of the asset.
512: SELECT COUNT(*)
513: INTO ln_reinstate_count
514: FROM fa_transaction_history_trx_v fthv
515: WHERE fthv.asset_id = lv_asset_id
516: AND fthv.book_type_code = lv_corp_book
517: AND fthv.transaction_type_code = 'REINSTATEMENT'
518: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 532: FROM fa_transaction_history_trx_v fthv

528: ELSE
529: --Retireve the greatest effective date of retirement. ---TODO get the real accouting retirement date.
530: SELECT greatest(date_effective)
531: INTO ld_retirement_date
532: FROM fa_transaction_history_trx_v fthv
533: WHERE fthv.asset_id = lv_asset_id
534: AND fthv.book_type_code = lv_corp_book
535: AND fthv.transaction_type_code = 'FULL RETIREMENT'
536: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 548: FROM fa_transaction_history_trx_v fthv

544: ld_end_date);
545: --Retireve the greatest effective date of reinstatement.
546: SELECT greatest(date_effective)
547: INTO ld_reinstated_date
548: FROM fa_transaction_history_trx_v fthv
549: WHERE fthv.asset_id = lv_asset_id
550: AND fthv.book_type_code = lv_corp_book
551: AND fthv.transaction_type_code = 'REINSTATEMENT'
552: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 588: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv

584: --check if the asset is unit adjusted after the to_date.
585: BEGIN
586: SELECT MIN(thv.transaction_header_id)
587: INTO ln_transaction_header_id
588: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv
589: WHERE asset_id = lv_asset_id
590: AND transaction_type_code = 'UNIT ADJUSTMENT'
591: AND thv.date_effective BETWEEN dp.period_open_date AND
592: nvl(dp.period_close_date, sysdate)