[Home] [Help]
427: fa_category_books fcb,
428: fa_methods mth,
429: fa_distribution_history fdh,
430: gl_ledgers gl,
431: fa_transaction_history_trx_v fthv,
432: fnd_currencies_vl fncv
433: -- Check ledger
434: WHERE bk.date_ineffective IS NULL
435: AND bk.transaction_header_id_out IS NULL
641: ln_legacy_dep_month := 0;
642:
643: SELECT COUNT(*)
644: INTO ln_full_retirement_count
645: FROM fa_transaction_history_trx_v fthv
646: WHERE fthv.asset_id = lv_asset_id
647: AND fthv.book_type_code = lv_book_type_code
648: AND fthv.transaction_type_code = 'FULL RETIREMENT'
649: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
657: IF (ln_full_retirement_count <> 0) THEN
658: --Check the reinstatement of the asset.
659: SELECT COUNT(*)
660: INTO ln_reinstate_count
661: FROM fa_transaction_history_trx_v fthv
662: WHERE fthv.asset_id = lv_asset_id
663: AND fthv.book_type_code = lv_book_type_code
664: AND fthv.transaction_type_code = 'REINSTATEMENT'
665: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
676: ELSE
677: --Retireve the greatest effective date of retirement. ---TODO get the real accouting retirement date.
678: SELECT greatest(date_effective)
679: INTO ld_retirement_date
680: FROM fa_transaction_history_trx_v fthv
681: WHERE fthv.asset_id = lv_asset_id
682: AND fthv.book_type_code = lv_book_type_code
683: AND fthv.transaction_type_code = 'FULL RETIREMENT'
684: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
692: ld_end_date);
693: --Retireve the greatest effective date of reinstatement.
694: SELECT greatest(date_effective)
695: INTO ld_reinstated_date
696: FROM fa_transaction_history_trx_v fthv
697: WHERE fthv.asset_id = lv_asset_id
698: AND fthv.book_type_code = lv_book_type_code
699: AND fthv.transaction_type_code = 'REINSTATEMENT'
700: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
739: BEGIN
740: SELECT MIN(thv.transaction_header_id)
741: INTO ln_transaction_header_id
742: FROM fa_deprn_periods dp,
743: fa_transaction_history_trx_v thv,
744: fa_transaction_headers fthr
745: WHERE thv.book_type_code = dp.book_type_code
746: AND thv.asset_id = lv_asset_id
747: AND dp.book_type_code = lv_book_type_code
788: --tax and coporate books share the same infomration, so we don't need identify the book type.
789: BEGIN
790: SELECT MIN(thv.transaction_header_id)
791: INTO ln_transaction_header_id
792: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv
793: WHERE asset_id = lv_asset_id
794: AND dp.book_type_code = lv_book_type_code
795: AND transaction_type_code IN ('UNIT ADJUSTMENT', 'RECLASS')
796: AND thv.date_effective BETWEEN dp.period_open_date AND
863:
864: --verify if the asset was retired during the period.
865: SELECT MIN(fthv.transaction_header_id)
866: INTO ln_retire_tran_header_id
867: FROM fa_transaction_history_trx_v fthv, fa_retirements fr
868: WHERE fthv.book_type_code = lv_book_type_code
869: AND fthv.asset_id = lv_asset_id
870: AND fthv.transaction_type_code IN
871: ('FULL RETIREMENT', 'PARTIAL RETIREMENT')
884: AND fr.status <> 'PENDING'
885: AND fr.asset_id = fthv.asset_id
886: AND (TRANSACTION_HEADER_ID_OUT IS NULL OR NOT EXISTS
887: (SELECT thv.transaction_header_id
888: FROM fa_transaction_history_trx_v thv
889: WHERE thv.transaction_header_id =
890: fr.transaction_header_id_out
891: AND thv.book_type_code = lv_book_type_code
892: AND thv.asset_id = lv_asset_id
1006: AND deprn_amount <> 0;
1007: --calculate the depreicated months before addition.
1008: SELECT nvl(fdp.calendar_period_close_date, ld_in_service_date)
1009: INTO ld_addition_date
1010: FROM fa_deprn_periods fdp, fa_transaction_history_trx_v thv
1011: WHERE thv.asset_id = lv_asset_id
1012: AND fdp.book_type_code = lv_book_type_code
1013: AND thv.book_type_code = fdp.book_type_code
1014: AND thv.transaction_type_code = 'ADDITION'