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_DEPRN_PERIODS_MRC_V

Line 8908: from fa_deprn_periods_mrc_v

8904: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8905:
8906: select period_counter
8907: into h_cur_period_Counter
8908: from fa_deprn_periods_mrc_v
8909: where book_type_Code = h_book_type_code
8910: and period_close_date is null;
8911:
8912: select exclude_fully_rsv_flag,recognize_gain_loss

Line 10336: from fa_deprn_periods_mrc_v

10332: and period_close_date is null;
10333:
10334: cursor GET_CUR_PERIOD_MRC is
10335: select period_counter, fiscal_year, period_num
10336: from fa_deprn_periods_mrc_v
10337: where book_type_code = h_book_type_code
10338: and period_close_date is null;
10339:
10340: cursor MEM_EXP_RESERVE is

Line 10358: fa_deprn_periods_mrc_v dp1

10354:
10355: cursor MEM_EXP_RESERVE_MRC is
10356: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10357: from fa_deprn_summary_mrc_v ds1,
10358: fa_deprn_periods_mrc_v dp1
10359: where ds1.book_type_code = h_book_type_code
10360: and ds1.asset_id = h_member_asset_id
10361: and dp1.book_type_code = ds1.book_type_Code
10362: and dp1.period_counter = ds1.period_counter

Line 10404: fa_deprn_periods_mrc_v dp1,

10400: and ret.asset_id = h_member_asset_id
10401: and exists
10402: (select th1.transaction_header_id
10403: from fa_transaction_headers th1,
10404: fa_deprn_periods_mrc_v dp1,
10405: fa_deprn_periods_mrc_v dp3
10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =

Line 10405: fa_deprn_periods_mrc_v dp3

10401: and exists
10402: (select th1.transaction_header_id
10403: from fa_transaction_headers th1,
10404: fa_deprn_periods_mrc_v dp1,
10405: fa_deprn_periods_mrc_v dp3
10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =
10409: (select dp2.fiscal_year

Line 10410: from fa_deprn_periods_mrc_v dp2

10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =
10409: (select dp2.fiscal_year
10410: from fa_deprn_periods_mrc_v dp2
10411: where dp2.book_type_code = dp1.book_type_code
10412: and dp2.period_Counter = h_period_counter - 1)
10413: and dp1.period_num = 1
10414: and dp3.book_type_code = dp1.book_type_code

Line 10454: from fa_deprn_periods_mrc_v dp1,

10450: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
10451: and adj.source_type_code = 'ADJUSTMENT'
10452: and exists
10453: (select dp2.period_counter
10454: from fa_deprn_periods_mrc_v dp1,
10455: fa_deprn_periods_mrc_v dp2
10456: where dp1.book_type_code = adj.book_type_code
10457: and dp1.period_counter = h_period_counter - 1
10458: and dp2.book_type_code = dp1.book_type_code

Line 10455: fa_deprn_periods_mrc_v dp2

10451: and adj.source_type_code = 'ADJUSTMENT'
10452: and exists
10453: (select dp2.period_counter
10454: from fa_deprn_periods_mrc_v dp1,
10455: fa_deprn_periods_mrc_v dp2
10456: where dp1.book_type_code = adj.book_type_code
10457: and dp1.period_counter = h_period_counter - 1
10458: and dp2.book_type_code = dp1.book_type_code
10459: and dp2.fiscal_year = dp1.fiscal_year