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_CALC_DEPRN_BASIS2_PKG dependencies on FA_BOOKS

Line 159: FROM fa_books

155: end if;
156:
157: SELECT rate_in_use
158: INTO l_rate_in_use
159: FROM fa_books
160: WHERE asset_id = px_rule_in.asset_id
161: AND book_type_code = px_rule_in.book_type_code
162: AND date_ineffective is null;
163:

Line 166: fa_debug_pkg.add('faxcdb2b', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec => p_log_level_rec);

162: AND date_ineffective is null;
163:
164: if p_log_level_rec.statement_level then
165: fa_debug_pkg.add('faxcdb2b', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate, p_log_level_rec => p_log_level_rec);
166: fa_debug_pkg.add('faxcdb2b', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec => p_log_level_rec);
167: end if;
168:
169: if fa_cache_pkg.fazcfor_record.revised_rate = l_rate_in_use then
170: Null; -- Dont change adjusted cost.

Line 298: from FA_BOOKS bk, FA_METHODS dm

294: nvl(bk.adjusted_recoverable_cost,0),
295: nvl(bk.cost,0),
296: nvl(bk.deprn_limit_type,'X'), -- Bug 12833731
297: nvl(bk.allowed_deprn_limit_amount,0) -- Bug 12833731
298: from FA_BOOKS bk, FA_METHODS dm
299: where bk.deprn_method_code = dm.method_code
300: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
301: and bk.asset_id = px_rule_in.asset_id
302: and bk.book_type_code = px_rule_in.book_type_code

Line 339: from FA_BOOKS bk, FA_METHODS dm

335: nvl(bk.adjusted_recoverable_cost,0),
336: nvl(bk.cost,0),
337: nvl(bk.deprn_limit_type,'X'),
338: nvl(bk.allowed_deprn_limit_amount,0)
339: from FA_BOOKS bk, FA_METHODS dm
340: where bk.deprn_method_code = dm.method_code
341: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
342: and bk.asset_id = px_rule_in.asset_id
343: and bk.book_type_code = px_rule_in.book_type_code

Line 383: fa_books bk

379: is
380: select nvl(h.amortization_start_date,h.transaction_date_entered),
381: nvl(bk.cost,0)
382: from fa_transaction_headers h,
383: fa_books bk
384: where h.transaction_header_id =
385: (select max(transaction_header_id_out)
386: from fa_books b,
387: fa_methods m

Line 386: from fa_books b,

382: from fa_transaction_headers h,
383: fa_books bk
384: where h.transaction_header_id =
385: (select max(transaction_header_id_out)
386: from fa_books b,
387: fa_methods m
388: where b.book_type_code = px_rule_in.book_type_code
389: and b.asset_id = px_rule_in.asset_id
390: and b.deprn_method_code = m.method_code

Line 449: from FA_BOOKS BK

445: -- Check exclude_fully_rsv_flag
446: CURSOR C_EXC_FULLY_RSV_FLAG
447: is
448: select exclude_fully_rsv_flag
449: from FA_BOOKS BK
450: where BK.ASSET_ID = px_rule_in.asset_id
451: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
452: and BK.TRANSACTION_HEADER_ID_OUT is null;
453:

Line 503: from FA_BOOKS BK,

499: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
500: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
501: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
502: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
503: from FA_BOOKS BK,
504: FA_DEPRN_SUMMARY DS
505: where BK.ASSET_ID = DS.ASSET_ID
506: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
507: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER

Line 540: from FA_BOOKS BK

536: is
537: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
538: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
539: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
540: from FA_BOOKS BK
541: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
542: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
543: and BK.PERIOD_COUNTER_FULLY_RESERVED = p_period_counter
544: and BK.DATE_INEFFECTIVE is null;

Line 563: from FA_BOOKS BK

559: is
560: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
561: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
562: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
563: from FA_BOOKS BK
564: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
565: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
566: and BK.PERIOD_COUNTER_FULLY_RESERVED <= p_period_counter
567: and BK.DATE_INEFFECTIVE is null;

Line 585: from FA_BOOKS BK1,

581: -- Get member's retired adjusted_cost
582: cursor C_GET_RET_ADJ_COST
583: is
584: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
585: from FA_BOOKS BK1,
586: FA_BOOKS BK2
587: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
588: and BK1.GROUP_ASSET_ID is not null
589: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id

Line 586: FA_BOOKS BK2

582: cursor C_GET_RET_ADJ_COST
583: is
584: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
585: from FA_BOOKS BK1,
586: FA_BOOKS BK2
587: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
588: and BK1.GROUP_ASSET_ID is not null
589: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id
590: and BK2.GROUP_ASSET_ID is not null;

Line 615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS

611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
619:

Line 616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS

612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
619:
620: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag

Line 617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS

613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
619:
620: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
621: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag

Line 618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS

614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
619:
620: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
621: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag
622: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS

Line 1388: from FA_BOOKS bk

1384: and th1.member_transaction_header_id (+) = th2.transaction_header_id
1385: and (th1.transaction_type_code <>'GROUP ADJUSTMENT'
1386: and th1.trx_reference_id is null)
1387: and exists (select th2.asset_id
1388: from FA_BOOKS bk
1389: where th2.asset_id = bk.asset_id
1390: and bk.book_type_code = px_rule_in.book_type_code
1391: and bk.group_asset_id= px_rule_in.asset_id
1392: and bk.date_ineffective is null);

Line 1840: from FA_BOOKS BK

1836: and TH.TRANSACTION_DATE_ENTERED between
1837: FY.START_DATE and DP.CALENDAR_PERIOD_CLOSE_DATE
1838: and RET.STATUS in ('PROCESSED','PENDING')
1839: and exists (select RET.ASSET_ID
1840: from FA_BOOKS BK
1841: where RET.ASSET_ID = BK.ASSET_ID
1842: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
1843: and BK.GROUP_ASSET_ID = px_rule_in.asset_id
1844: and BK.DATE_INEFFECTIVE is null)

Line 2214: from FA_BOOKS

2210: cursor C_CHECK_FLAGS (p_asset_id number)
2211: is
2212: select EXCLUDE_PROCEEDS_FROM_BASIS,
2213: MEMBER_ROLLUP_FLAG
2214: from FA_BOOKS
2215: where ASSET_ID = p_asset_id
2216: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2217: and date_ineffective is null;
2218:

Line 2234: from FA_BOOKS

2230: -- Cursor to calculate sum of member assets' eofy_reserve
2231: cursor C_SUMUP_EOFY_RESERVE
2232: is
2233: select sum(nvl(EOFY_RESERVE,0))
2234: from FA_BOOKS
2235: where GROUP_ASSET_ID = px_rule_in.asset_id
2236: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2237: and DATE_INEFFECTIVE is null;
2238:

Line 2252: from fa_books bk, fa_transaction_headers th

2248:
2249: /*bug#16426081 starts*/
2250: cursor c_adj_cost_diff is
2251: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date,th.transaction_header_id
2252: from fa_books bk, fa_transaction_headers th
2253: where bk.asset_id = th.asset_id
2254: and bk.book_type_code = px_rule_in.book_type_code
2255: and bk.asset_id = px_rule_in.asset_id
2256: and th.transaction_header_id = bk.transaction_header_id_in