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_MRC_V

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 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 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 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 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 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 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 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 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 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 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: