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_MC_BOOKS

Line 318: from FA_MC_BOOKS bk, FA_METHODS dm

314: nvl(bk.adjusted_recoverable_cost,0),
315: nvl(bk.cost,0),
316: nvl(bk.deprn_limit_type,'X'), -- Bug 12833731
317: nvl(bk.allowed_deprn_limit_amount,0) -- Bug 12833731
318: from FA_MC_BOOKS bk, FA_METHODS dm
319: where bk.deprn_method_code = dm.method_code
320: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
321: and bk.asset_id = px_rule_in.asset_id
322: and bk.book_type_code = px_rule_in.book_type_code

Line 358: from FA_MC_BOOKS bk, FA_METHODS dm

354: nvl(bk.adjusted_recoverable_cost,0),
355: nvl(bk.cost,0),
356: nvl(bk.deprn_limit_type,'X'),
357: nvl(bk.allowed_deprn_limit_amount,0)
358: from FA_MC_BOOKS bk, FA_METHODS dm
359: where bk.deprn_method_code = dm.method_code
360: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
361: and bk.asset_id = px_rule_in.asset_id
362: and bk.book_type_code = px_rule_in.book_type_code

Line 401: fa_mc_books bk

397: is
398: select nvl(h.amortization_start_date,h.transaction_date_entered),
399: nvl(bk.cost,0)
400: from fa_transaction_headers h,
401: fa_mc_books bk
402: where h.transaction_header_id =
403: (select max(transaction_header_id_out)
404: from fa_mc_books b,
405: fa_methods m

Line 404: from fa_mc_books b,

400: from fa_transaction_headers h,
401: fa_mc_books bk
402: where h.transaction_header_id =
403: (select max(transaction_header_id_out)
404: from fa_mc_books b,
405: fa_methods m
406: where b.book_type_code = px_rule_in.book_type_code
407: and b.asset_id = px_rule_in.asset_id
408: and b.deprn_method_code = m.method_code

Line 457: from FA_MC_BOOKS BK

453:
454: CURSOR C_EXC_FULLY_RSV_FLAG_M
455: is
456: select exclude_fully_rsv_flag
457: from FA_MC_BOOKS BK
458: where BK.ASSET_ID = px_rule_in.asset_id
459: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
460: and BK.TRANSACTION_HEADER_ID_OUT is null
461: and BK.set_of_books_id = px_rule_in.set_of_books_id ;

Line 521: from FA_MC_BOOKS BK,

517: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
518: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
519: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
520: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
521: from FA_MC_BOOKS BK,
522: FA_MC_DEPRN_SUMMARY DS
523: where BK.ASSET_ID = DS.ASSET_ID
524: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
525: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER

Line 551: from FA_MC_BOOKS BK

547: is
548: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
549: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
550: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
551: from FA_MC_BOOKS BK
552: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
553: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
554: and BK.PERIOD_COUNTER_FULLY_RESERVED = p_period_counter
555: and BK.DATE_INEFFECTIVE is null

Line 574: from FA_MC_BOOKS BK

570: is
571: select nvl(sum(BK.adjusted_cost),0) fully_rsv_adjusted_cost,
572: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
573: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost
574: from FA_MC_BOOKS BK
575: where BK.GROUP_ASSET_ID = px_rule_in.asset_id
576: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
577: and BK.PERIOD_COUNTER_FULLY_RESERVED <= p_period_counter
578: and BK.DATE_INEFFECTIVE is null

Line 596: from FA_MC_BOOKS BK1,

592: -- MRC
593: cursor C_GET_RET_ADJ_COST_M
594: is
595: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
596: from FA_MC_BOOKS BK1,
597: FA_MC_BOOKS BK2
598: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
599: and BK1.GROUP_ASSET_ID is not null
600: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id

Line 597: FA_MC_BOOKS BK2

593: cursor C_GET_RET_ADJ_COST_M
594: is
595: select nvl(BK1.ADJUSTED_COST,0) - nvl(BK2.ADJUSTED_COST,0)
596: from FA_MC_BOOKS BK1,
597: FA_MC_BOOKS BK2
598: where BK1.TRANSACTION_HEADER_ID_OUT = px_rule_in.member_transaction_header_id
599: and BK1.GROUP_ASSET_ID is not null
600: and BK2.TRANSACTION_HEADER_ID_IN = px_rule_in.member_transaction_header_id
601: and BK2.GROUP_ASSET_ID is not null

Line 1412: from FA_MC_BOOKS bk

1408: and th1.member_transaction_header_id (+) = th2.transaction_header_id
1409: and (th1.transaction_type_code <>'GROUP ADJUSTMENT'
1410: and th1.trx_reference_id is null)
1411: and exists (select th2.asset_id
1412: from FA_MC_BOOKS bk
1413: where th2.asset_id = bk.asset_id
1414: and bk.book_type_code = px_rule_in.book_type_code
1415: and bk.group_asset_id= px_rule_in.asset_id
1416: and bk.date_ineffective is null

Line 1871: from FA_MC_BOOKS BK

1867: and TH.TRANSACTION_DATE_ENTERED between
1868: FY.START_DATE and DP.CALENDAR_PERIOD_CLOSE_DATE
1869: and RET.STATUS in ('PROCESSED','PENDING')
1870: and exists (select RET.ASSET_ID
1871: from FA_MC_BOOKS BK
1872: where RET.ASSET_ID = BK.ASSET_ID
1873: and BK.BOOK_TYPE_CODE = px_rule_in.book_type_code
1874: and BK.GROUP_ASSET_ID = px_rule_in.asset_id
1875: and BK.DATE_INEFFECTIVE is null

Line 2224: from FA_MC_BOOKS

2220: cursor C_CHECK_FLAGS_M (p_asset_id number)
2221: is
2222: select EXCLUDE_PROCEEDS_FROM_BASIS,
2223: MEMBER_ROLLUP_FLAG
2224: from FA_MC_BOOKS
2225: where ASSET_ID = p_asset_id
2226: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2227: and date_ineffective is null
2228: and SET_OF_BOOKS_ID = px_rule_in.set_of_books_id ;

Line 2243: from FA_MC_BOOKS

2239: -- MRC
2240: cursor C_SUMUP_EOFY_RESERVE_M
2241: is
2242: select sum(nvl(EOFY_RESERVE,0))
2243: from FA_MC_BOOKS
2244: where GROUP_ASSET_ID = px_rule_in.asset_id
2245: and BOOK_TYPE_CODE = px_rule_in.book_type_code
2246: and DATE_INEFFECTIVE is null
2247: and SET_OF_BOOKS_ID = px_rule_in.set_of_books_id;

Line 2262: from fa_mc_books bk, fa_transaction_headers th

2258: order by th.transaction_header_id desc;
2259:
2260: cursor c_adj_cost_diff_m is
2261: select (bk.adjusted_cost-bk.recoverable_cost) adj_cost_diff, th.amortization_start_date,th.transaction_header_id
2262: from fa_mc_books bk, fa_transaction_headers th
2263: where bk.asset_id = th.asset_id
2264: and bk.book_type_code = px_rule_in.book_type_code
2265: and bk.asset_id = px_rule_in.asset_id
2266: and th.transaction_header_id = bk.transaction_header_id_in