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_SUMMARY

Line 195: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL

191: if nvl(P_mode,'DEPRECIATION') = 'UNPLANNED' or
192: nvl(P_mode,'DEPRECIATION') = 'GROUP ADJUSTMENT' then
193:
194: -- This is a case when this program is called from Group Adjustments.
195: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL
196: -- or FA_BOOKS following P_mode
197:
198: if not ins_dd_adj(P_book_type_Code => P_book_type_code,
199: P_group_asset_id => P_group_asset_id,

Line 381: fa_deprn_summary ds,

377: nvl(ds.ytd_deprn,0) ytd_deprn,
378: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
379: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
380: from fa_books bk,
381: fa_deprn_summary ds,
382: fa_additions_b ad
383: where bk.group_asset_id = h_group_asset_id
384: and bk.book_type_code = h_book_type_code
385: and bk.date_ineffective is null

Line 391: from fa_deprn_summary ds1

387: and ds.book_type_code = h_book_type_code
388: and ds.asset_id = bk.asset_id
389: and ds.period_counter =
390: (select max(ds1.period_counter)
391: from fa_deprn_summary ds1
392: where ds1.book_type_code = h_book_type_code
393: and ds1.asset_id = bk.asset_id
394: and ds1.period_counter <= h_period_counter - 1)
395: and ad.asset_id = bk.asset_id

Line 605: fa_deprn_summary ds,

601: ds.bonus_deprn_reserve,
602: ds.bonus_ytd_deprn
603: from fa_track_members tr,
604: fa_books bk,
605: fa_deprn_summary ds,
606: fa_deprn_periods dp,
607: fa_additions_b ad
608: where tr.group_asset_id = h_group_asset_id
609: and tr.period_counter = h_period_counter

Line 3800: fa_deprn_summary ds,

3796: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3797: temp.eofy_salvage_value temp_eofy_salvage_value,
3798: temp.eop_salvage_value temp_eop_salvage_value
3799: from fa_books bk,
3800: fa_deprn_summary ds,
3801: fa_track_members temp
3802: where bk.book_type_code = h_book_type_code
3803: and bk.group_asset_id = h_group_asset_id
3804: and bk.date_ineffective is null

Line 3809: from fa_deprn_summary ds1

3805: and ds.book_type_code = bk.book_type_code
3806: and ds.asset_id = bk.asset_id
3807: and (ds.period_counter =
3808: (select max(ds1.period_counter)
3809: from fa_deprn_summary ds1
3810: where ds1.book_type_code=h_book_type_code
3811: and ds1.asset_id=bk.asset_id
3812: and ds1.period_counter <= h_period_counter - 1)
3813: or

Line 5741: FA_DEPRN_SUMMARY_PKG.Update_Row

5737: l_asset_deprn_rec.deprn_reserve||':'||l_asset_deprn_rec.ytd_deprn, p_log_level_rec);
5738: fa_debug_pkg.add(l_calling_fn, 'l_deprn_adjustment_amount', l_deprn_adjustment_amount, p_log_level_rec);
5739: end if;
5740:
5741: FA_DEPRN_SUMMARY_PKG.Update_Row
5742: (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
5743: X_Asset_Id => p_asset_hdr_rec.asset_id,
5744: X_Ytd_Deprn => l_asset_deprn_rec.ytd_deprn,
5745: X_Deprn_Reserve => l_asset_deprn_rec.deprn_reserve,

Line 5950: fa_deprn_summary ds,

5946: dp1.fiscal_year
5947: from fa_books bk,
5948: fa_deprn_periods dp,
5949: fa_deprn_periods dp1,
5950: fa_deprn_summary ds,
5951: fa_additions_b ad
5952: where dp.book_type_code = h_book_type_code
5953: and dp.period_counter = h_loop_period_counter
5954: and bk.book_type_code = dp.book_type_code

Line 5969: from fa_deprn_summary ds1

5965: and bk.depreciate_flag = 'YES'
5966: and ds.book_type_code = bk.book_type_code
5967: and ds.period_counter =
5968: (select min(period_counter)
5969: from fa_deprn_summary ds1
5970: where ds1.book_type_code = h_book_type_code
5971: and ds1.asset_id = bk.asset_id
5972: and ds1.period_counter >= h_period_counter - 1)
5973: and ds.asset_id = bk.asset_id

Line 6052: fa_deprn_summary ds,

6048: ds.bonus_ytd_deprn,
6049: dp.fiscal_year
6050: from fa_books bk,
6051: fa_deprn_periods dp,
6052: fa_deprn_summary ds,
6053: fa_additions_b ad
6054: where dp.book_type_code = h_book_type_code
6055: and dp.period_counter = h_loop_period_counter
6056: and bk.book_type_code = dp.book_type_code

Line 6063: from fa_deprn_summary ds1

6059: and bk.depreciate_flag = 'YES'
6060: and ds.book_type_code = bk.book_type_code
6061: and ds.period_counter =
6062: (select min(period_counter)
6063: from fa_deprn_summary ds1
6064: where ds1.book_type_code = h_book_type_code
6065: and ds1.asset_id = bk.asset_id
6066: and ds1.period_counter >= h_period_counter - 1)
6067: and ds.asset_id = bk.asset_id

Line 6259: from fa_deprn_summary ds

6255:
6256: cursor ADDITION_RESERVE_YTD is
6257: select ds.deprn_reserve,
6258: ds.ytd_deprn
6259: from fa_deprn_summary ds
6260: where ds.book_type_code=h_book_type_code
6261: and ds.asset_id=h_member_asset_id
6262: and ds.deprn_source_code='BOOKS';
6263:

Line 7103: from fa_deprn_summary

7099: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is
7100: select deprn_source_code,
7101: ytd_deprn,
7102: deprn_reserve
7103: from fa_deprn_summary
7104: where book_type_code = h_book_type_code
7105: and asset_id = p_asset_id
7106: and period_counter = p_period_counter;
7107:

Line 7112: from fa_deprn_summary_mrc_v

7108: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
7109: select deprn_source_code,
7110: ytd_deprn,
7111: deprn_reserve
7112: from fa_deprn_summary_mrc_v
7113: where book_type_code = h_book_type_code
7114: and asset_id = p_asset_id
7115: and period_counter = p_period_counter;
7116:

Line 8595: from fa_deprn_summary

8591: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is
8592: select deprn_source_code,
8593: ytd_deprn,
8594: deprn_reserve
8595: from fa_deprn_summary
8596: where book_type_code = h_book_type_code
8597: and asset_id = p_asset_id
8598: and period_counter = p_period_counter;
8599:

Line 8604: from fa_deprn_summary_mrc_v

8600: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
8601: select deprn_source_code,
8602: ytd_deprn,
8603: deprn_reserve
8604: from fa_deprn_summary_mrc_v
8605: where book_type_code = h_book_type_code
8606: and asset_id = p_asset_id
8607: and period_counter = p_period_counter;
8608:

Line 10342: from fa_deprn_summary ds1,

10338: and period_close_date is null;
10339:
10340: cursor MEM_EXP_RESERVE is
10341: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10342: from fa_deprn_summary ds1,
10343: fa_deprn_periods dp1
10344: where ds1.book_type_code = h_book_type_code
10345: and ds1.asset_id = h_member_asset_id
10346: and dp1.book_type_code = ds1.book_type_Code

Line 10350: from fa_deprn_summary ds2

10346: and dp1.book_type_code = ds1.book_type_Code
10347: and dp1.period_counter = ds1.period_counter
10348: and ds1.period_counter =
10349: (select max(period_counter)
10350: from fa_deprn_summary ds2
10351: where ds2.book_type_code = h_book_type_code
10352: and ds2.asset_id = h_member_asset_id
10353: and period_counter <= h_period_counter);
10354:

Line 10357: from fa_deprn_summary_mrc_v ds1,

10353: and period_counter <= h_period_counter);
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

Line 10365: from fa_deprn_summary ds2

10361: and dp1.book_type_code = ds1.book_type_Code
10362: and dp1.period_counter = ds1.period_counter
10363: and ds1.period_counter =
10364: (select max(period_counter)
10365: from fa_deprn_summary ds2
10366: where ds2.book_type_code = h_book_type_code
10367: and ds2.asset_id = h_member_asset_id
10368: and period_counter <= h_period_counter);
10369: