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 135: FROM fa_books

131: end if;
132:
133: SELECT rate_in_use
134: INTO l_rate_in_use
135: FROM fa_books
136: WHERE asset_id = px_rule_in.asset_id
137: AND book_type_code = px_rule_in.book_type_code
138: AND date_ineffective is null;
139:

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

139:
140: if p_log_level_rec.statement_level then
141: fa_debug_pkg.add('faxcdb2b', '+++ Revised Rate : ', fa_cache_pkg.fazcfor_record.revised_rate,
142: p_log_level_rec);
143: fa_debug_pkg.add('faxcdb2b', '+++ FA_Books.Rate : ', l_rate_in_use, p_log_level_rec);
144: end if;
145:
146: if fa_cache_pkg.fazcfor_record.revised_rate = l_rate_in_use then
147: Null; -- Dont change adjusted cost.

Line 252: from FA_BOOKS bk, FA_METHODS dm

248: -- to fix bug 2303276
249: -----------------------------------------
250: nvl(bk.adjusted_recoverable_cost,0),
251: nvl(bk.cost,0)
252: from FA_BOOKS bk, FA_METHODS dm
253: where bk.deprn_method_code = dm.method_code
254: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
255: and bk.asset_id = px_rule_in.asset_id
256: and bk.book_type_code = px_rule_in.book_type_code

Line 269: from FA_BOOKS_MRC_V bk, FA_METHODS dm

265: dm.deprn_basis_rule,
266: dm.rate_source_rule,
267: nvl(bk.adjusted_recoverable_cost,0),
268: nvl(bk.cost,0)
269: from FA_BOOKS_MRC_V bk, FA_METHODS dm
270: where bk.deprn_method_code = dm.method_code
271: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
272: and bk.asset_id = px_rule_in.asset_id
273: and bk.book_type_code = px_rule_in.book_type_code

Line 292: fa_books bk

288: is
289: select nvl(h.amortization_start_date,h.transaction_date_entered),
290: nvl(bk.cost,0)
291: from fa_transaction_headers h,
292: fa_books bk
293: where h.transaction_header_id =
294: (select max(transaction_header_id_out)
295: from fa_books b,
296: fa_methods m

Line 295: from fa_books b,

291: from fa_transaction_headers h,
292: fa_books bk
293: where h.transaction_header_id =
294: (select max(transaction_header_id_out)
295: from fa_books b,
296: fa_methods m
297: where b.book_type_code = px_rule_in.book_type_code
298: and b.asset_id = px_rule_in.asset_id
299: and b.deprn_method_code = m.method_code

Line 310: fa_books bk

306: is
307: select nvl(h.amortization_start_date,h.transaction_date_entered),
308: nvl(bk.cost,0)
309: from fa_transaction_headers h,
310: fa_books bk
311: where h.transaction_header_id =
312: (select max(transaction_header_id_out)
313: from fa_books_mrc_v b,
314: fa_methods m

Line 313: from fa_books_mrc_v b,

309: from fa_transaction_headers h,
310: fa_books bk
311: where h.transaction_header_id =
312: (select max(transaction_header_id_out)
313: from fa_books_mrc_v b,
314: fa_methods m
315: where b.book_type_code = px_rule_in.book_type_code
316: and b.asset_id = px_rule_in.asset_id
317: and b.deprn_method_code = m.method_code

Line 356: from FA_BOOKS BK

352: -- Check exclude_fully_rsv_flag
353: CURSOR C_EXC_FULLY_RSV_FLAG
354: is
355: select exclude_fully_rsv_flag
356: from FA_BOOKS BK
357: where BK.ASSET_ID = px_rule_in.asset_id
358: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
359: and BK.TRANSACTION_HEADER_ID_OUT is null;
360:

Line 364: from FA_BOOKS_MRC_V BK

360:
361: CURSOR C_EXC_FULLY_RSV_FLAG_M
362: is
363: select exclude_fully_rsv_flag
364: from FA_BOOKS_MRC_V BK
365: where BK.ASSET_ID = px_rule_in.asset_id
366: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
367: and BK.TRANSACTION_HEADER_ID_OUT is null;
368:

Line 409: from FA_BOOKS BK,

405: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
406: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
407: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
408: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
409: from FA_BOOKS BK,
410: FA_DEPRN_SUMMARY DS
411: where BK.ASSET_ID = DS.ASSET_ID
412: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
413: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER

Line 427: from FA_BOOKS_MRC_V BK,

423: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
424: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
425: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
426: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
427: from FA_BOOKS_MRC_V BK,
428: FA_DEPRN_SUMMARY_MRC_V DS
429: where BK.ASSET_ID = DS.ASSET_ID
430: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
431: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER

Line 444: from FA_BOOKS BK

440: is
441: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
442: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
443: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
444: from FA_BOOKS BK
445: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
446: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
447: and BK.PERIOD_COUNTER_FULLY_RESERVED = p_period_counter
448: and BK.DATE_INEFFECTIVE is null;

Line 455: from FA_BOOKS_MRC_V BK

451: is
452: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
453: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
454: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
455: from FA_BOOKS_MRC_V BK
456: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
457: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
458: and BK.PERIOD_COUNTER_FULLY_RESERVED = p_period_counter
459: and BK.DATE_INEFFECTIVE is null;

Line 466: from FA_BOOKS BK

462: is
463: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
464: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
465: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
466: from FA_BOOKS BK
467: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
468: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
469: and BK.PERIOD_COUNTER_FULLY_RESERVED <= p_period_counter
470: and BK.DATE_INEFFECTIVE is null;

Line 477: from FA_BOOKS_MRC_V BK

473: is
474: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
475: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
476: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
477: from FA_BOOKS_MRC_V BK
478: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
479: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
480: and BK.PERIOD_COUNTER_FULLY_RESERVED <= p_period_counter
481: and BK.DATE_INEFFECTIVE is null;

Line 487: from FA_BOOKS BK1,

483: -- Get member's retired adjusted_cost
484: cursor C_GET_RET_ADJ_COST
485: is
486: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
487: from FA_BOOKS BK1,
488: FA_BOOKS BK2
489: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
490: and BK1.GROUP_ASSET_ID is not null
491: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id

Line 488: FA_BOOKS BK2

484: cursor C_GET_RET_ADJ_COST
485: is
486: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
487: from FA_BOOKS BK1,
488: FA_BOOKS BK2
489: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
490: and BK1.GROUP_ASSET_ID is not null
491: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id
492: and BK2.GROUP_ASSET_ID is not null;

Line 498: from FA_BOOKS_MRC_V BK1,

494: -- MRC
495: cursor C_GET_RET_ADJ_COST_M
496: is
497: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
498: from FA_BOOKS_MRC_V BK1,
499: FA_BOOKS_MRC_V BK2
500: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
501: and BK1.GROUP_ASSET_ID is not null
502: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id

Line 499: FA_BOOKS_MRC_V BK2

495: cursor C_GET_RET_ADJ_COST_M
496: is
497: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
498: from FA_BOOKS_MRC_V BK1,
499: FA_BOOKS_MRC_V BK2
500: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
501: and BK1.GROUP_ASSET_ID is not null
502: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id
503: and BK2.GROUP_ASSET_ID is not null;

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

511: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
517: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
518: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
519:

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

512: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
517: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
518: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
519:
520: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag

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

513: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
517: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
518: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
519:
520: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
521: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag

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

514:
515: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
516: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
517: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS
518: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
519:
520: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
521: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag
522: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS

Line 1210: from FA_BOOKS bk

1206: and th1.member_transaction_header_id (+) = th2.transaction_header_id
1207: and (th1.transaction_type_code <>'GROUP ADJUSTMENT'
1208: and th1.trx_reference_id is null)
1209: and exists (select th2.asset_id
1210: from FA_BOOKS bk
1211: where th2.asset_id = bk.asset_id
1212: and bk.book_type_code = px_rule_in.book_type_code
1213: and bk.group_asset_id= px_rule_in.asset_id
1214: and bk.date_ineffective is null);

Line 1233: from FA_BOOKS_MRC_V bk

1229: and th1.member_transaction_header_id (+) = th2.transaction_header_id
1230: and (th1.transaction_type_code <>'GROUP ADJUSTMENT'
1231: and th1.trx_reference_id is null)
1232: and exists (select th2.asset_id
1233: from FA_BOOKS_MRC_V bk
1234: where th2.asset_id = bk.asset_id
1235: and bk.book_type_code = px_rule_in.book_type_code
1236: and bk.group_asset_id= px_rule_in.asset_id
1237: and bk.date_ineffective is null);

Line 1663: from FA_BOOKS BK

1659: and TH.TRANSACTION_DATE_ENTERED between
1660: FY.START_DATE and DP.CALENDAR_PERIOD_CLOSE_DATE
1661: and RET.STATUS in ('PROCESSED','PENDING')
1662: and exists (select RET.ASSET_ID
1663: from FA_BOOKS BK
1664: where RET.ASSET_ID = BK.ASSET_ID
1665: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
1666: and BK.GROUP_ASSET_ID = px_rule_in.asset_id
1667: and BK.DATE_INEFFECTIVE is null)

Line 1689: from FA_BOOKS_MRC_V BK

1685: and TH.TRANSACTION_DATE_ENTERED between
1686: FY.START_DATE and DP.CALENDAR_PERIOD_CLOSE_DATE
1687: and RET.STATUS in ('PROCESSED','PENDING')
1688: and exists (select RET.ASSET_ID
1689: from FA_BOOKS_MRC_V BK
1690: where RET.ASSET_ID = BK.ASSET_ID
1691: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
1692: and BK.GROUP_ASSET_ID = px_rule_in.asset_id
1693: and BK.DATE_INEFFECTIVE is null)

Line 2039: from FA_BOOKS

2035: cursor C_CHECK_FLAGS (p_asset_id number)
2036: is
2037: select EXCLUDE_PROCEEDS_FROM_BASIS,
2038: MEMBER_ROLLUP_FLAG
2039: from FA_BOOKS
2040: where ASSET_ID = p_asset_id
2041: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2042: and date_ineffective is null;
2043:

Line 2049: from FA_BOOKS_MRC_V

2045: cursor C_CHECK_FLAGS_M (p_asset_id number)
2046: is
2047: select EXCLUDE_PROCEEDS_FROM_BASIS,
2048: MEMBER_ROLLUP_FLAG
2049: from FA_BOOKS_MRC_V
2050: where ASSET_ID = p_asset_id
2051: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2052: and date_ineffective is null;
2053:

Line 2058: from FA_BOOKS

2054: -- Cursor to calculate sum of member assets' eofy_reserve
2055: cursor C_SUMUP_EOFY_RESERVE
2056: is
2057: select sum(nvl(EOFY_RESERVE,0))
2058: from FA_BOOKS
2059: where GROUP_ASSET_ID = px_rule_in.asset_id
2060: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2061: and DATE_INEFFECTIVE is null;
2062:

Line 2067: from FA_BOOKS_MRC_V

2063: -- MRC
2064: cursor C_SUMUP_EOFY_RESERVE_M
2065: is
2066: select sum(nvl(EOFY_RESERVE,0))
2067: from FA_BOOKS_MRC_V
2068: where GROUP_ASSET_ID = px_rule_in.asset_id
2069: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2070: and DATE_INEFFECTIVE is null;
2071: