APPS.JA_CN_PS_FA_AC_EXP_PKG dependencies on FA_TRANSACTION_HISTORY_TRX_V

Line 302: , fa_transaction_history_trx_v fthv

298: , fa_category_books fcb
299: , fa_methods mth
300: , fa_distribution_history fdh
301: , gl_ledgers gl
302: , fa_transaction_history_trx_v fthv
303: , fnd_currencies_vl fncv
304: -- Check ledger
305: WHERE bk.date_ineffective IS NULL
306: AND bk.transaction_header_id_out IS NULL

Line 558: fa_transaction_history_trx_v fthv

554: COUNT(*)
555: INTO
556: ln_full_retirement_count
557: FROM
558: fa_transaction_history_trx_v fthv
559: WHERE fthv.asset_id = lv_asset_id
560: AND fthv.book_type_code = lv_book_type_code
561: AND fthv.transaction_type_code = 'FULL RETIREMENT'
562: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 574: FROM fa_transaction_history_trx_v fthv

570: IF(ln_full_retirement_count <> 0)
571: THEN
572: --Check the reinstatement of the asset.
573: SELECT COUNT(*) INTO ln_reinstate_count
574: FROM fa_transaction_history_trx_v fthv
575: WHERE fthv.asset_id = lv_asset_id
576: AND fthv.book_type_code = lv_book_type_code
577: AND fthv.transaction_type_code = 'REINSTATEMENT'
578: AND

Line 601: fa_transaction_history_trx_v fthv

597: greatest(date_effective)
598: INTO
599: ld_retirement_date
600: FROM
601: fa_transaction_history_trx_v fthv
602: WHERE fthv.asset_id = lv_asset_id
603: AND fthv.book_type_code = lv_book_type_code
604: AND fthv.transaction_type_code = 'FULL RETIREMENT'
605: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 618: fa_transaction_history_trx_v fthv

614: greatest(date_effective)
615: INTO
616: ld_reinstated_date
617: FROM
618: fa_transaction_history_trx_v fthv
619: WHERE fthv.asset_id = lv_asset_id
620: AND fthv.book_type_code = lv_book_type_code
621: AND fthv.transaction_type_code = 'REINSTATEMENT'
622: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,

Line 673: , fa_transaction_history_trx_v thv

669: MIN(thv.transaction_header_id)
670: INTO
671: ln_transaction_header_id
672: FROM fa_deprn_periods dp
673: , fa_transaction_history_trx_v thv
674: , fa_transaction_headers fthr
675: WHERE thv.book_type_code = dp.book_type_code
676: AND thv.asset_id = lv_asset_id
677: AND dp.book_type_code = lv_book_type_code

Line 731: , fa_transaction_history_trx_v thv

727: INTO
728: ln_transaction_header_id
729: FROM
730: fa_deprn_periods dp
731: , fa_transaction_history_trx_v thv
732: WHERE asset_id = lv_asset_id
733: AND dp.book_type_code = lv_book_type_code
734: AND transaction_type_code IN('UNIT ADJUSTMENT', 'RECLASS')
735: AND thv.date_effective BETWEEN dp.period_open_date

Line 810: FROM fa_transaction_history_trx_v fthv

806:
807: --verify if the asset was retired during the period.
808: SELECT MIN(fthv.transaction_header_id)
809: INTO ln_retire_tran_header_id
810: FROM fa_transaction_history_trx_v fthv
811: , fa_retirements fr
812: WHERE fthv.book_type_code = lv_book_type_code
813: AND fthv.asset_id = lv_asset_id
814: AND fthv.transaction_type_code IN

Line 834: FROM fa_transaction_history_trx_v thv

830: AND (
831: TRANSACTION_HEADER_ID_OUT IS NULL
832: OR NOT EXISTS(
833: SELECT thv.transaction_header_id
834: FROM fa_transaction_history_trx_v thv
835: WHERE thv.transaction_header_id = fr.transaction_header_id_out
836: AND thv.book_type_code = lv_book_type_code
837: AND thv.asset_id = lv_asset_id
838: AND thv.transaction_type_code = 'REINSTATEMENT'

Line 950: fa_transaction_history_trx_v thv

946: --calculate the depreicated months before addition.
947: SELECT nvl(fdp.calendar_period_close_date, ld_in_service_date)
948: INTO ld_addition_date
949: FROM fa_deprn_periods fdp,
950: fa_transaction_history_trx_v thv
951: WHERE thv.asset_id = lv_asset_id
952: AND fdp.book_type_code = lv_book_type_code
953: AND thv.book_type_code = fdp.book_type_code
954: AND thv.transaction_type_code = 'ADDITION'