DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_TRANSACTION_HEADERS

Line 956: FROM FA_TRANSACTION_HEADERS TH

952: -- TRANSFER IN, TRANSFER IN/VOID, and any retirement which has been reinstated
953: --
954: CURSOR c_chk_trx_before_dpis is
955: SELECT TH.TRANSACTION_HEADER_ID
956: FROM FA_TRANSACTION_HEADERS TH
957: WHERE TH.ASSET_ID = p_asset_id
958: AND TH.BOOK_TYPE_CODE = p_book_type_code
959: AND TH.TRANSACTION_TYPE_CODE IN ('ADJUSTMENT', 'GROUP ADJUSTMENT', 'REVALUATION', 'TAX')
960: AND NVL(TH.AMORTIZATION_START_DATE, TH.TRANSACTION_DATE_ENTERED)

Line 964: FROM FA_TRANSACTION_HEADERS TH,

960: AND NVL(TH.AMORTIZATION_START_DATE, TH.TRANSACTION_DATE_ENTERED)
961: < p_date_placed_in_service
962: UNION
963: SELECT TH.TRANSACTION_HEADER_ID
964: FROM FA_TRANSACTION_HEADERS TH,
965: FA_RETIREMENTS RET
966: WHERE TH.ASSET_ID = p_asset_id
967: AND TH.BOOK_TYPE_CODE = p_book_type_code
968: AND TH.TRANSACTION_TYPE_CODE IN

Line 1593: from fa_transaction_headers

1589: select MAX(transaction_date_entered),
1590: MAX(date_effective)
1591: into l_prior_transaction_date,
1592: l_prior_date_effective
1593: from fa_transaction_headers
1594: where asset_id = p_asset_id
1595: and book_type_code = p_book_type_code;
1596:
1597: if (x_amortization_start_date < l_prior_transaction_date) then

Line 1654: from fa_transaction_headers

1650: -- changing logic to compare max(trx_date) to the amort date here too.
1651:
1652: select MAX(transaction_date_entered) -- date_effective
1653: into l_prior_transaction_date -- l_prior_date_effective
1654: from fa_transaction_headers
1655: where asset_id = p_asset_id
1656: and book_type_code = p_book_type_code
1657: and transaction_type_code in
1658: ('REVALUATION');

Line 2300: from fa_transaction_headers th,

2296: and bk.asset_id = p_asset_id
2297: and (bk.rate_Adjustment_factor <> 1 OR
2298: (bk.rate_adjustment_factor = 1 and
2299: exists (select 'YES' -- and amortized before.
2300: from fa_transaction_headers th,
2301: fa_methods mt
2302: where th.book_type_code = bk.book_type_code
2303: and th.asset_id = bk.asset_id
2304: and th.transaction_type_code = 'ADJUSTMENT'

Line 2323: from fa_transaction_headers th

2319: into l_count
2320: from dual
2321: where exists (
2322: select 1
2323: from fa_transaction_headers th
2324: where th.book_type_code = p_book
2325: and th.asset_id = p_asset_id
2326: and (th.transaction_subtype = 'AMORTIZED' OR th.transaction_key = 'UA')
2327: and th.transaction_header_id > (select max(th2.transaction_header_id)

Line 2328: from fa_transaction_headers th2

2324: where th.book_type_code = p_book
2325: and th.asset_id = p_asset_id
2326: and (th.transaction_subtype = 'AMORTIZED' OR th.transaction_key = 'UA')
2327: and th.transaction_header_id > (select max(th2.transaction_header_id)
2328: from fa_transaction_headers th2
2329: where th2.book_type_code = p_book
2330: and th2.asset_id = p_asset_id
2331: and th2.transaction_key = 'ES'));
2332: else

Line 2337: select 1 from fa_transaction_headers

2333: select count(1)
2334: into l_count
2335: from dual
2336: where exists (
2337: select 1 from fa_transaction_headers
2338: where book_type_code = p_book
2339: and asset_id = p_asset_id
2340: and (transaction_subtype = 'AMORTIZED' OR transaction_key = 'UA'));
2341:

Line 2374: FROM fa_transaction_headers

2370: BEGIN
2371:
2372: SELECT count(*)
2373: INTO l_count
2374: FROM fa_transaction_headers
2375: WHERE book_type_code = p_book
2376: AND asset_id = p_asset_id
2377: AND transaction_key like 'U%';
2378:

Line 2438: FROM fa_transaction_headers th

2434: end if;
2435:
2436: SELECT count(*)
2437: INTO l_count
2438: FROM fa_transaction_headers th
2439: WHERE th.asset_id = p_asset_id
2440: AND th.book_type_code = p_book
2441: AND th.transaction_type_code = 'ADDITION'
2442: AND th.date_effective > l_period_rec.period_open_date;

Line 2693: from fa_transaction_headers thd

2689: +---------------------------------------------------------------+*/
2690: begin
2691: select distinct transaction_header_id
2692: into v_xfr_out_thid
2693: from fa_transaction_headers thd
2694: where thd.asset_id = p_Asset_Id
2695: and thd.TRANSACTION_TYPE_CODE = 'TRANSFER OUT'
2696: and thd.book_type_code = p_book
2697: and thd.transaction_header_id > p_Transaction_Header_Id_In

Line 3234: from fa_transaction_headers th,

3230: select sum(inbk.cost - nvl(outbk.cost, 0))
3231: , sum(inbk.salvage_value - nvl(outbk.salvage_value, 0))
3232: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3233: nvl(outbk.allowed_deprn_limit_amount, 0))
3234: from fa_transaction_headers th,
3235: fa_books inbk,
3236: fa_books outbk
3237: where inbk.asset_id = p_asset_id
3238: and inbk.book_type_code = p_book_type_code

Line 3262: fa_transaction_headers reith

3258: nvl(th.amortization_start_date,
3259: th.transaction_date_entered))) <= p_transaction_date
3260: and not exists(select 'Exclude Retirement which reinstatement exists'
3261: from fa_retirements ret,
3262: fa_transaction_headers reith
3263: where ret.transaction_header_id_in = th.transaction_header_id
3264: and ret.transaction_header_id_out = reith.transaction_header_id
3265: and nvl(reith.amortization_start_date,
3266: reith.transaction_date_entered) <= p_transaction_date);

Line 3273: from fa_transaction_headers th,

3269: select sum(inbk.cost - nvl(outbk.cost, 0))
3270: , sum(inbk.salvage_value - nvl(outbk.salvage_value, 0))
3271: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3272: nvl(outbk.allowed_deprn_limit_amount, 0))
3273: from fa_transaction_headers th,
3274: fa_books_mrc_v inbk,
3275: fa_books_mrc_v outbk
3276: where inbk.asset_id = p_asset_id
3277: and inbk.book_type_code = p_book_type_code

Line 3301: fa_transaction_headers reith

3297: nvl(th.amortization_start_date,
3298: th.transaction_date_entered))) <= p_transaction_date
3299: and not exists(select 'Exclude Retirement which reinstatement exists'
3300: from fa_retirements ret,
3301: fa_transaction_headers reith
3302: where ret.transaction_header_id_in = th.transaction_header_id
3303: and ret.transaction_header_id_out = reith.transaction_header_id
3304: and nvl(reith.amortization_start_date,
3305: reith.transaction_date_entered) <= p_transaction_date);

Line 3821: from FA_Transaction_Headers

3817:
3818: CURSOR c_reval_exists (l_asset_id NUMBER,
3819: l_book_type_code VARCHAR2) is
3820: select 'x'
3821: from FA_Transaction_Headers
3822: where Asset_ID = l_asset_id
3823: and Book_type_Code = l_book_type_code
3824: and Transaction_Type_Code = 'REVALUATION';
3825: