eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_ASSET_VAL_PVT dependencies on FA_TRANSACTION_HEADERS

Line 1168: FROM FA_TRANSACTION_HEADERS TH

1164: -- TRANSFER IN, TRANSFER IN/VOID, and any retirement which has been reinstated
1165: --
1166: CURSOR c_chk_trx_before_dpis is
1167: SELECT TH.TRANSACTION_HEADER_ID
1168: FROM FA_TRANSACTION_HEADERS TH
1169: WHERE TH.ASSET_ID = p_asset_id
1170: AND TH.BOOK_TYPE_CODE = p_book_type_code
1171: AND TH.TRANSACTION_TYPE_CODE IN ('ADJUSTMENT', 'GROUP ADJUSTMENT', 'REVALUATION', 'TAX')
1172: AND NVL(TH.AMORTIZATION_START_DATE, TH.TRANSACTION_DATE_ENTERED)

Line 1176: FROM FA_TRANSACTION_HEADERS TH,

1172: AND NVL(TH.AMORTIZATION_START_DATE, TH.TRANSACTION_DATE_ENTERED)
1173: < p_date_placed_in_service
1174: UNION
1175: SELECT TH.TRANSACTION_HEADER_ID
1176: FROM FA_TRANSACTION_HEADERS TH,
1177: FA_RETIREMENTS RET
1178: WHERE TH.ASSET_ID = p_asset_id
1179: AND TH.BOOK_TYPE_CODE = p_book_type_code
1180: AND TH.TRANSACTION_TYPE_CODE IN

Line 1778: from fa_transaction_headers

1774: select MAX(transaction_date_entered),
1775: MAX(date_effective)
1776: into l_prior_transaction_date,
1777: l_prior_date_effective
1778: from fa_transaction_headers
1779: where asset_id = p_asset_id
1780: and book_type_code = p_book_type_code;
1781:
1782: if (x_amortization_start_date < l_prior_transaction_date) then

Line 1839: from fa_transaction_headers

1835: -- changing logic to compare max(trx_date) to the amort date here too.
1836:
1837: select MAX(transaction_date_entered) -- date_effective
1838: into l_prior_transaction_date -- l_prior_date_effective
1839: from fa_transaction_headers
1840: where asset_id = p_asset_id
1841: and book_type_code = p_book_type_code
1842: and transaction_type_code in
1843: ('REVALUATION');

Line 2481: from fa_transaction_headers th,

2477: and (bk.rate_Adjustment_factor <> 1 OR
2478: (bk.rate_adjustment_factor = 1 and
2479: exists
2480: (select 'YES' -- and amortized before.
2481: from fa_transaction_headers th,
2482: fa_methods mt
2483: where th.book_type_code = bk.book_type_code
2484: and th.asset_id = bk.asset_id
2485: and (th.transaction_subtype = 'AMORTIZED'

Line 2491: from fa_transaction_headers th2

2487: and th.transaction_header_id = bk.transaction_header_id_in
2488: and mt.method_code = bk.deprn_method_code
2489: and mt.rate_source_rule IN ('TABLE','FLAT','PRODUCTION')
2490: and th.transaction_header_id > (select max(th2.transaction_header_id)
2491: from fa_transaction_headers th2
2492: where th2.book_type_code = p_book
2493: and th2.asset_id = p_asset_id
2494: and th2.transaction_key = 'ES'))));
2495: else

Line 2505: from fa_transaction_headers th,

2501: and (bk.rate_Adjustment_factor <> 1 OR
2502: (bk.rate_adjustment_factor = 1 and
2503: exists
2504: (select 'YES'
2505: from fa_transaction_headers th,
2506: fa_methods mt
2507: where th.book_type_code = bk.book_type_code
2508: and th.asset_id = bk.asset_id
2509: and (th.transaction_subtype = 'AMORTIZED'

Line 2521: select 1 from fa_transaction_headers

2517: select count(1)
2518: into l_rolled_back_imp
2519: from dual
2520: where exists (
2521: select 1 from fa_transaction_headers
2522: where book_type_code = p_book
2523: and asset_id = p_asset_id
2524: and transaction_subtype = 'AMORTIZED' and transaction_key = 'RM');
2525: l_rolled_back_imp := l_rolled_back_imp * 2;

Line 2540: from fa_transaction_headers

2536: /** commenting out for perf issue 6348506
2537: --bug fix 2772517
2538: select count(*)
2539: into l_count
2540: from fa_transaction_headers
2541: where book_type_code = p_book
2542: and asset_id = p_asset_id
2543: -- and transaction_type_code = 'ADJUSTMENT' bug 5326226
2544: and (transaction_subtype = 'AMORTIZED' OR transaction_key = 'UA');

Line 2560: from fa_transaction_headers th,

2556: and bk.asset_id = p_asset_id
2557: and (bk.rate_Adjustment_factor <> 1 OR
2558: (bk.rate_adjustment_factor = 1 and
2559: exists (select 'YES' -- and amortized before.
2560: from fa_transaction_headers th,
2561: fa_methods mt
2562: where th.book_type_code = bk.book_type_code
2563: and th.asset_id = bk.asset_id
2564: and th.transaction_type_code = 'ADJUSTMENT'

Line 2591: FROM fa_transaction_headers

2587: BEGIN
2588:
2589: SELECT count(*)
2590: INTO l_count
2591: FROM fa_transaction_headers
2592: WHERE book_type_code = p_book
2593: AND asset_id = p_asset_id
2594: AND transaction_key like 'U%';
2595:

Line 2654: FROM fa_transaction_headers th

2650: end if;
2651:
2652: SELECT count(*)
2653: INTO l_count
2654: FROM fa_transaction_headers th
2655: WHERE th.asset_id = p_asset_id
2656: AND th.book_type_code = p_book
2657: AND th.transaction_type_code = 'ADDITION'
2658: AND th.date_effective > l_period_rec.period_open_date;

Line 2899: from fa_transaction_headers thd

2895: +---------------------------------------------------------------+*/
2896: begin
2897: select distinct transaction_header_id
2898: into v_xfr_out_thid
2899: from fa_transaction_headers thd
2900: where thd.asset_id = p_Asset_Id
2901: and thd.TRANSACTION_TYPE_CODE = 'TRANSFER OUT'
2902: and thd.book_type_code = p_book
2903: and thd.transaction_header_id > p_Transaction_Header_Id_In

Line 3443: FROM fa_transaction_headers th

3439: ,inbk.salvage_value inbk_salvage_value
3440: ,outbk.salvage_value outbk_salvage_value
3441: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3442: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3443: FROM fa_transaction_headers th
3444: ,fa_books inbk
3445: ,fa_books outbk
3446: WHERE inbk.asset_id = p_asset_id
3447: AND inbk.book_type_code = p_book_type_code

Line 3466: ,fa_transaction_headers reith

3462: <= p_transaction_date
3463: AND NOT EXISTS
3464: (SELECT 'Exclude Retirement which reinstatement exists'
3465: FROM fa_retirements ret
3466: ,fa_transaction_headers reith
3467: WHERE ret.transaction_header_id_in = th.transaction_header_id
3468: AND ret.transaction_header_id_out = reith.transaction_header_id
3469: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)
3470: <= p_transaction_date)

Line 3478: FROM fa_transaction_headers th

3474: ,inbk.salvage_value inbk_salvage_value
3475: ,outbk.salvage_value outbk_salvage_value
3476: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3477: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3478: FROM fa_transaction_headers th
3479: ,fa_books inbk
3480: ,fa_books outbk
3481: WHERE inbk.asset_id = p_asset_id
3482: AND inbk.book_type_code = p_book_type_code

Line 3499: ,fa_transaction_headers reith

3495: AND inbk.date_placed_in_service <= p_transaction_date
3496: AND NOT EXISTS
3497: (SELECT 'Exclude Retirement which reinstatement exists'
3498: FROM fa_retirements ret
3499: ,fa_transaction_headers reith
3500: WHERE ret.transaction_header_id_in = th.transaction_header_id
3501: AND ret.transaction_header_id_out = reith.transaction_header_id
3502: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)
3503: <= p_transaction_date)) ;

Line 3516: FROM fa_transaction_headers th

3512: ,inbk.salvage_value inbk_salvage_value
3513: ,outbk.salvage_value outbk_salvage_value
3514: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3515: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3516: FROM fa_transaction_headers th
3517: ,fa_mc_books inbk
3518: ,fa_mc_books outbk
3519: WHERE inbk.asset_id = p_asset_id
3520: AND inbk.book_type_code = p_book_type_code

Line 3539: ,fa_transaction_headers reith

3535: <= p_transaction_date
3536: AND NOT EXISTS
3537: (SELECT 'Exclude Retirement which reinstatement exists'
3538: FROM fa_retirements ret
3539: ,fa_transaction_headers reith
3540: WHERE ret.transaction_header_id_in = th.transaction_header_id
3541: AND ret.transaction_header_id_out = reith.transaction_header_id
3542: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)
3543: <= p_transaction_date)

Line 3551: FROM fa_transaction_headers th

3547: ,inbk.salvage_value inbk_salvage_value
3548: ,outbk.salvage_value outbk_salvage_value
3549: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3550: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3551: FROM fa_transaction_headers th
3552: ,fa_mc_books inbk
3553: ,fa_mc_books outbk
3554: WHERE inbk.asset_id = p_asset_id
3555: AND inbk.book_type_code = p_book_type_code

Line 3572: ,fa_transaction_headers reith

3568: AND inbk.date_placed_in_service <= p_transaction_date
3569: AND NOT EXISTS
3570: (SELECT 'Exclude Retirement which reinstatement exists'
3571: FROM fa_retirements ret
3572: ,fa_transaction_headers reith
3573: WHERE ret.transaction_header_id_in = th.transaction_header_id
3574: AND ret.transaction_header_id_out = reith.transaction_header_id
3575: AND NVL(reith.amortization_start_date, reith.transaction_date_entered)
3576: <= p_transaction_date)) ;

Line 4232: from FA_Transaction_Headers

4228:
4229: CURSOR c_reval_exists (l_asset_id NUMBER,
4230: l_book_type_code VARCHAR2) is
4231: select 'x'
4232: from FA_Transaction_Headers
4233: where Asset_ID = l_asset_id
4234: and Book_type_Code = l_book_type_code
4235: and Transaction_Type_Code = 'REVALUATION';
4236:

Line 5789: from fa_transaction_headers th -- member

5785:
5786: /* Cursor to get retirement adjustment happened during retirement */
5787: cursor c_ret_adj_amount is
5788: select nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount)),0) ret_adj_amount
5789: from fa_transaction_headers th -- member
5790: , fa_transaction_headers gth -- group
5791: , fa_adjustments aj
5792: where th.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5793: and th.source_transaction_header_id = gth.transaction_header_id

Line 5790: , fa_transaction_headers gth -- group

5786: /* Cursor to get retirement adjustment happened during retirement */
5787: cursor c_ret_adj_amount is
5788: select nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount)),0) ret_adj_amount
5789: from fa_transaction_headers th -- member
5790: , fa_transaction_headers gth -- group
5791: , fa_adjustments aj
5792: where th.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5793: and th.source_transaction_header_id = gth.transaction_header_id
5794: and gth.book_type_code = p_asset_retire_rec.detail_info.book_type_code

Line 6352: FA_TRANSACTION_HEADERS FATH,

6348:
6349: SELECT count(*)
6350: INTO l_imp_exists
6351: FROM
6352: FA_TRANSACTION_HEADERS FATH,
6353: FA_DEPRN_PERIODS FADP,
6354: FA_FISCAL_YEAR FAFY
6355: WHERE FATH.BOOK_TYPE_CODE = p_asset_hdr_rec.BOOK_TYPE_CODE
6356: AND FAFY.FISCAL_YEAR_NAME = l_fiscal_year

Line 6815: from fa_transaction_headers th,

6811: and (bk.rate_Adjustment_factor <> 1 OR
6812: (bk.rate_adjustment_factor = 1 and
6813: exists
6814: (select 'YES'
6815: from fa_transaction_headers th,
6816: fa_methods mt
6817: where th.book_type_code = bk.book_type_code
6818: and th.asset_id = bk.asset_id
6819: and (th.transaction_subtype = 'AMORTIZED'