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_TRACK_MEMBER_PVT dependencies on FA_MC_BOOKS

Line 436: from fa_mc_books bk,

432: nvl(ds.deprn_reserve,0) deprn_reserve,
433: nvl(ds.ytd_deprn,0) ytd_deprn,
434: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
435: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
436: from fa_mc_books bk,
437: fa_mc_deprn_summary ds,
438: fa_additions_b ad
439: where bk.group_asset_id = h_group_asset_id
440: and bk.book_type_code = h_book_type_code

Line 476: from fa_mc_books bk,

472: cursor ALL_MEMBERS_TOTAL_MRC is
473: select sum(bk.cost),
474: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
475: sum(bk.recoverable_cost)
476: from fa_mc_books bk,
477: fa_additions_b ad
478: where bk.group_asset_id = h_group_asset_id
479: and bk.date_ineffective is null
480: and bk.book_type_code = h_book_type_code

Line 505: from fa_mc_books bk,

501: cursor MEMBERS_EX_RETIRED_TOTAL_MRC is
502: select sum(bk.cost),
503: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
504: sum(bk.recoverable_cost)
505: from fa_mc_books bk,
506: fa_additions_b ad
507: where bk.group_asset_id = h_group_asset_id
508: and bk.date_ineffective is null
509: and bk.period_counter_fully_retired is null

Line 535: from fa_mc_books bk,

531: cursor MEMBERS_EX_RESERVED_TOTAL_MRC is
532: select sum(bk.cost),
533: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
534: sum(bk.recoverable_cost)
535: from fa_mc_books bk,
536: fa_additions_b ad
537: where bk.group_asset_id = h_group_asset_id
538: and bk.date_ineffective is null
539: and bk.period_counter_fully_reserved is null

Line 566: from fa_mc_books bk,

562: cursor MEMBER_EX_BOTH_TOTAL_MRC is
563: select sum(bk.cost),
564: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
565: sum(bk.recoverable_cost)
566: from fa_mc_books bk,
567: fa_additions_b ad
568: where bk.group_asset_id = h_group_asset_id
569: and bk.date_ineffective is null
570: and bk.period_counter_fully_retired is null

Line 639: fa_mc_books bk,

635: ds.ytd_deprn,
636: ds.bonus_deprn_reserve,
637: ds.bonus_ytd_deprn
638: from fa_track_members tr,
639: fa_mc_books bk,
640: fa_mc_deprn_summary ds,
641: fa_mc_deprn_periods dp,
642: fa_additions_b ad
643: where tr.group_asset_id = h_group_asset_id

Line 676: from fa_mc_books bk

672:
673: cursor GROUP_BASIS_MRC is
674: select decode(h_excl_sv,'N',bk.adjusted_cost,bk.adjusted_cost+bk.salvage_value) adjusted_cost,
675: bk.recoverable_cost recoverable_cost
676: from fa_mc_books bk
677: where bk.book_type_code=h_book_type_code
678: and bk.asset_id = h_group_asset_id
679: and bk.date_ineffective is null
680: and bk.set_of_books_id = h_set_of_books_id;

Line 3846: from fa_mc_books bk,

3842: temp.eofy_recoverable_cost temp_eofy_recoverable_cost,
3843: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3844: temp.eofy_salvage_value temp_eofy_salvage_value,
3845: temp.eop_salvage_value temp_eop_salvage_value
3846: from fa_mc_books bk,
3847: fa_mc_deprn_summary ds,
3848: fa_track_members temp
3849: where bk.book_type_code = h_book_type_code
3850: and bk.group_asset_id = h_group_asset_id

Line 4003: from fa_mc_books new_bk,

3999: new_bk.salvage_type,
4000: decode(new_bk.salvage_type,'PCT',new_bk.percent_salvage_value),
4001: new_bk.deprn_limit_type,
4002: decode(new_bk.deprn_limit_type,'PCT',new_bk.allowed_deprn_limit)
4003: from fa_mc_books new_bk,
4004: fa_mc_books old_bk
4005: where new_bk.book_type_code = p_group_rule_in.book_type_code
4006: and new_bk.asset_id = h_member_asset_id
4007: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id

Line 4004: fa_mc_books old_bk

4000: decode(new_bk.salvage_type,'PCT',new_bk.percent_salvage_value),
4001: new_bk.deprn_limit_type,
4002: decode(new_bk.deprn_limit_type,'PCT',new_bk.allowed_deprn_limit)
4003: from fa_mc_books new_bk,
4004: fa_mc_books old_bk
4005: where new_bk.book_type_code = p_group_rule_in.book_type_code
4006: and new_bk.asset_id = h_member_asset_id
4007: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id
4008: and new_bk.set_of_books_id = h_set_of_books_id

Line 4182: from fa_mc_books new_bk

4178: new_bk.salvage_type,
4179: new_bk.percent_salvage_value,
4180: new_bk.deprn_limit_type,
4181: new_bk.allowed_deprn_limit
4182: from fa_mc_books new_bk
4183: where new_bk.book_type_code = p_group_rule_in.book_type_code
4184: and new_bk.asset_id = h_member_asset_id
4185: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id
4186: and new_bk.set_of_books_id = h_set_of_books_id;

Line 5318: update fa_mc_books

5314: fa_debug_pkg.add(l_calling_fn, 'h_eofy_adj_cost:h_eop_adj_cost:h_new_eofy_reserve ',
5315: h_eofy_adj_cost||':'||h_eop_adj_cost||':'||h_new_eofy_reserve, p_log_level_rec);
5316: end if;
5317:
5318: update fa_mc_books
5319: set adjusted_cost = fa_rule_out.new_adjusted_cost,
5320: eofy_adj_cost = h_eofy_adj_cost,
5321: eofy_reserve = h_new_eofy_reserve,
5322: eop_adj_cost = h_eop_adj_cost,

Line 5917: from fa_mc_books bk,

5913: order by ad.asset_number;
5914:
5915: cursor ALL_MEMBERS_MRC(h_date date) is
5916: select bk.asset_id
5917: from fa_mc_books bk,
5918: fa_additions_b ad
5919: where bk.book_type_code = h_book_type_code
5920: and bk.group_asset_id = h_group_asset_id
5921: and bk.set_of_books_id = h_set_of_books_id

Line 5996: from fa_mc_books bk,

5992: decode(dp1.fiscal_year,h_fiscal_year,ds.ytd_deprn,0),
5993: ds.bonus_deprn_reserve,
5994: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
5995: dp1.fiscal_year
5996: from fa_mc_books bk,
5997: fa_mc_deprn_periods dp,
5998: fa_mc_deprn_periods dp1,
5999: fa_mc_deprn_summary ds,
6000: fa_additions_b ad

Line 6088: from fa_mc_books bk,

6084: ds.ytd_deprn,
6085: ds.bonus_deprn_reserve,
6086: ds.bonus_ytd_deprn,
6087: dp.fiscal_year
6088: from fa_mc_books bk,
6089: fa_mc_deprn_periods dp,
6090: fa_mc_deprn_summary ds,
6091: fa_additions_b ad
6092: where dp.book_type_code = h_book_type_code

Line 6131: from fa_mc_books bk,

6127:
6128: cursor MEMBER_START_PERIOD_MRC is
6129: select bk.recoverable_cost,
6130: bk.salvage_value
6131: from fa_mc_books bk,
6132: fa_mc_deprn_periods dp
6133: where bk.book_type_code = h_book_type_code
6134: and bk.group_asset_id = h_member_asset_id
6135: and bk.set_of_books_id = h_set_of_books_id

Line 6625: from fa_mc_books

6621:
6622: if nvl(p_calling_fn,'OTHER') = 'TRACK_ASSETS' then -- Get group level info
6623: select deprn_method_code,life_in_months
6624: into h_method_code,h_life_in_months
6625: from fa_mc_books
6626: where book_type_code = h_book_type_code
6627: and asset_id = h_group_asset_id
6628: and date_ineffective is null
6629: and set_of_books_id = h_set_of_books_id;

Line 11139: INSERT INTO FA_MC_BOOKS_SUMMARY

11135: open CHK_BS_TABLE_MRC;
11136: fetch CHK_BS_TABLE_MRC into h_chk_bs_flag;
11137: if CHK_BS_TABLE_MRC%NOTFOUND then
11138: -- This means to insert new row into FA_BOOKS_SUMMARY
11139: INSERT INTO FA_MC_BOOKS_SUMMARY
11140: (SET_OF_BOOKS_ID,
11141: ASSET_ID,
11142: GROUP_ASSET_ID,
11143: BOOK_TYPE_CODE,