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_BOOKS_MRC_V

Line 1703: update fa_books_mrc_v -- ENERGY

1699: (mem.asset_id is not null) and -- ENERGY
1700: (nvl(l_track_member_out.allocated_deprn_amount, 0) <> 0) and -- ENERGY
1701: (nvl(P_mode,'DEPRECIATION') = 'UNPLANNED') then -- ENERGY
1702:
1703: update fa_books_mrc_v -- ENERGY
1704: set adjusted_cost = adjusted_cost - nvl(l_track_member_out.allocated_deprn_amount, 0) -- ENERGY
1705: where transaction_header_id_out is null -- ENERGY
1706: and asset_id = mem.asset_id -- ENERGY
1707: and book_type_code = h_book_type_code; -- ENERGY

Line 4197: from fa_books_mrc_v

4193: and date_ineffective is null;
4194:
4195: cursor GET_EXCLUDE_FULLY_RSV_FLAG_MRC is
4196: select exclude_fully_rsv_flag
4197: from fa_books_mrc_v
4198: where book_type_code = h_book_type_code
4199: and asset_id = h_group_asset_id
4200: and date_ineffective is null;
4201:

Line 6012: from fa_books_mrc_v bk1

6008: bk.transaction_header_id_out = h_last_trans_id or
6009: (bk.date_ineffective is null and
6010: bk.transaction_header_id_in <> nvl(p_transaction_header_id,-1) and
6011: not exists (select 'y'
6012: from fa_books_mrc_v bk1
6013: where bk1.book_type_code = bk.book_type_code
6014: and bk1.asset_id = bk.asset_id
6015: and bk1.transaction_header_id_out = nvl(p_transaction_header_id,-1))))
6016: and bk.depreciate_flag = 'YES'

Line 7027: from FA_BOOKS_MRC_V BK_IN,

7023: BK_OUT.DEPRN_LIMIT_TYPE old_limit_type,
7024: BK_IN.ALLOWED_DEPRN_LIMIT new_deprn_limit,
7025: BK_IN.ALLOWED_DEPRN_LIMIT_AMOUNT old_deprn_limit,
7026: BK_IN.DEPRECIATE_FLAG depreciate_flag
7027: from FA_BOOKS_MRC_V BK_IN,
7028: FA_BOOKS_MRC_V BK_OUT
7029: where BK_IN.book_type_code = h_book_type_code
7030: and BK_IN.asset_id = h_member_asset_id
7031: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 7028: FA_BOOKS_MRC_V BK_OUT

7024: BK_IN.ALLOWED_DEPRN_LIMIT new_deprn_limit,
7025: BK_IN.ALLOWED_DEPRN_LIMIT_AMOUNT old_deprn_limit,
7026: BK_IN.DEPRECIATE_FLAG depreciate_flag
7027: from FA_BOOKS_MRC_V BK_IN,
7028: FA_BOOKS_MRC_V BK_OUT
7029: where BK_IN.book_type_code = h_book_type_code
7030: and BK_IN.asset_id = h_member_asset_id
7031: and BK_IN.transaction_header_id_in = p_transaction_header_id
7032: and BK_OUT.book_type_code(+) = BK_IN.book_type_code

Line 7063: from fa_books_mrc_v bk,

7059: order by ad.asset_number asc;
7060:
7061: cursor ALL_MEMBERS_AT_AMORT_MRC(p_fiscal_year number,p_period_num number) is
7062: select distinct bk.asset_id member_asset_id, ad.asset_number
7063: from fa_books_mrc_v bk,
7064: fa_additions_b ad
7065: where bk.book_type_code = h_book_type_code
7066: and bk.group_asset_id = h_group_asset_id
7067: and bk.depreciate_flag = 'YES'

Line 7094: from fa_books_mrc_v BK_IN

7090: and BK_IN.transaction_header_id_in = p_thid;
7091:
7092: cursor RECLASS_TRANS_CHECK_MRC(p_member_asset_id number,p_thid number) is
7093: select BK_IN.group_asset_id
7094: from fa_books_mrc_v BK_IN
7095: where BK_IN.book_type_code = h_book_type_code
7096: and BK_IN.asset_id = p_member_asset_id
7097: and BK_IN.transaction_header_id_in = p_thid;
7098:

Line 7793: from fa_books_mrc_v bk

7789:
7790: cursor ALL_MEMBERS_MRC is
7791: select bk.asset_id,
7792: bk.group_asset_id
7793: from fa_books_mrc_v bk
7794: where bk.book_type_code = h_book_type_code
7795: and bk.group_asset_id = h_group_asset_id
7796: and bk.date_ineffective is null
7797: and bk.depreciate_flag = 'YES'

Line 7952: Update FA_BOOKS_MRC_V set adjusted_cost = h_adjusted_cost,

7948: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7949: end if;
7950:
7951: -- Update FA_BOOKS table
7952: Update FA_BOOKS_MRC_V set adjusted_cost = h_adjusted_cost,
7953: eofy_reserve = h_eofy_reserve,
7954: last_update_date = sysdate,
7955: last_updated_by = -1
7956: where book_type_code = h_book_type_code

Line 8365: from FA_BOOKS_MRC_V BK,

8361: order by AD.asset_number asc;
8362:
8363: cursor GET_MEMBER_ASSETS_MRC (p_fiscal_year number,p_period_num number) is
8364: select distinct BK.ASSET_ID, AD.asset_number
8365: from FA_BOOKS_MRC_V BK,
8366: FA_ADDITIONS_B AD
8367: where BK.book_type_code = h_book_type_code
8368: and BK.group_asset_id = h_group_asset_id
8369: and exists

Line 8434: from FA_BOOKS_MRC_V BK1

8430: and BK1.TRANSACTION_HEADER_ID_IN = TH1.TRANSACTION_HEADER_ID);
8431:
8432: cursor GET_MAX_THID_IN_THIS_G_MRC(p_fiscal_year number,p_period_num number,p_member_asset_id number) is
8433: select max(BK1.transaction_header_id_in)
8434: from FA_BOOKS_MRC_V BK1
8435: where BK1.book_type_code = h_book_type_code
8436: and BK1.asset_id = p_member_asset_id
8437: and BK1.group_asset_id = h_group_asset_id
8438: and exists

Line 8456: from FA_BOOKS_MRC_V BK1

8452: and BK1.TRANSACTION_HEADER_ID_IN = TH1.TRANSACTION_HEADER_ID);
8453:
8454: cursor GET_MAX_THID_IN_OTHER_G_MRC(p_fiscal_year number,p_period_num number,p_member_asset_id number) is
8455: select max(BK1.transaction_header_id_in)
8456: from FA_BOOKS_MRC_V BK1
8457: where BK1.book_type_code = h_book_type_code
8458: and BK1.asset_id = p_member_asset_id
8459: and BK1.group_asset_id <> h_group_asset_id
8460: and exists

Line 8492: from fa_books_mrc_v bk

8488: select bk.allocate_to_fully_ret_flag,
8489: bk.allocate_to_fully_rsv_flag,
8490: bk.period_counter_fully_retired,
8491: bk.period_counter_fully_reserved
8492: from fa_books_mrc_v bk
8493: where bk.book_type_code = h_book_type_code
8494: and bk.asset_id = p_asset_id
8495: and bk.date_ineffective is null;
8496:

Line 8549: from FA_BOOKS_MRC_V BK_IN,

8545: BK_IN.ALLOWED_DEPRN_LIMIT_AMOUNT old_deprn_limit,
8546: BK_IN.DEPRECIATE_FLAG depreciate_flag,
8547: BK_IN.group_Asset_id group_asset_id,
8548: BK_IN.period_counter_fully_retired period_counter_fully_retired
8549: from FA_BOOKS_MRC_V BK_IN,
8550: FA_BOOKS_MRC_V BK_OUT
8551: where BK_IN.book_type_code = h_book_type_code
8552: and BK_IN.group_asset_id = h_group_asset_id
8553: and BK_IN.asset_id = h_member_asset_id

Line 8550: FA_BOOKS_MRC_V BK_OUT

8546: BK_IN.DEPRECIATE_FLAG depreciate_flag,
8547: BK_IN.group_Asset_id group_asset_id,
8548: BK_IN.period_counter_fully_retired period_counter_fully_retired
8549: from FA_BOOKS_MRC_V BK_IN,
8550: FA_BOOKS_MRC_V BK_OUT
8551: where BK_IN.book_type_code = h_book_type_code
8552: and BK_IN.group_asset_id = h_group_asset_id
8553: and BK_IN.asset_id = h_member_asset_id
8554: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 8786: from FA_BOOKS_MRC_V BK_IN,

8782: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in;
8783:
8784: cursor GET_NEW_GROUP_MRC(p_member_asset_id number, p_transaction_header_id number) is
8785: select BK_IN.group_Asset_id group_asset_id
8786: from FA_BOOKS_MRC_V BK_IN,
8787: FA_BOOKS_MRC_V BK_OUT
8788: where BK_IN.book_type_code = h_book_type_code
8789: and BK_IN.asset_id = h_member_asset_id
8790: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 8787: FA_BOOKS_MRC_V BK_OUT

8783:
8784: cursor GET_NEW_GROUP_MRC(p_member_asset_id number, p_transaction_header_id number) is
8785: select BK_IN.group_Asset_id group_asset_id
8786: from FA_BOOKS_MRC_V BK_IN,
8787: FA_BOOKS_MRC_V BK_OUT
8788: where BK_IN.book_type_code = h_book_type_code
8789: and BK_IN.asset_id = h_member_asset_id
8790: and BK_IN.transaction_header_id_in = p_transaction_header_id
8791: and BK_OUT.book_type_code(+) = BK_IN.book_type_code

Line 8914: from fa_books_mrc_v

8910: and period_close_date is null;
8911:
8912: select exclude_fully_rsv_flag,recognize_gain_loss
8913: into h_exclude_fully_rsv_flag,h_group_recognize_gain_loss
8914: from fa_books_mrc_v
8915: where book_type_code = h_book_type_code
8916: and asset_id = h_group_asset_id
8917: and date_ineffective is null;
8918: end if;

Line 10558: from fa_books_mrc_v

10554: fetch FA_ADJ_RESERVE_MRC into h_adj_reserve;
10555: close FA_ADJ_RESERVE_MRC;
10556:
10557: select eofy_reserve into h_eofy_reserve
10558: from fa_books_mrc_v
10559: where book_type_code = h_book_type_code
10560: and asset_id = h_member_asset_id
10561: and date_ineffective is null;
10562: