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 215: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL

211: if nvl(P_mode,'DEPRECIATION') = 'UNPLANNED' or
212: nvl(P_mode,'DEPRECIATION') = 'GROUP ADJUSTMENT' then
213:
214: -- This is a case when this program is called from Group Adjustments.
215: -- So allocated amount will be inserted/updated into FA_ADJUSTMENTS or FA_DEPRN_SUMMARY/DETAIL
216: -- or FA_BOOKS following P_mode
217:
218: if not ins_dd_adj(P_book_type_Code => P_book_type_code,
219: P_group_asset_id => P_group_asset_id,

Line 409: fa_deprn_summary ds,

405: nvl(ds.ytd_deprn,0) ytd_deprn,
406: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
407: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
408: from fa_books bk,
409: fa_deprn_summary ds,
410: fa_additions_b ad
411: where bk.group_asset_id = h_group_asset_id
412: and bk.book_type_code = h_book_type_code
413: and bk.date_ineffective is null

Line 419: from fa_deprn_summary ds1

415: and ds.book_type_code = h_book_type_code
416: and ds.asset_id = bk.asset_id
417: and ds.period_counter =
418: (select max(ds1.period_counter)
419: from fa_deprn_summary ds1
420: where ds1.book_type_code = h_book_type_code
421: and ds1.asset_id = bk.asset_id
422: and ds1.period_counter <= h_period_counter - 1)
423: and ad.asset_id = bk.asset_id

Line 634: fa_deprn_summary ds,

630: ds.bonus_deprn_reserve,
631: ds.bonus_ytd_deprn
632: from fa_track_members tr,
633: fa_books bk,
634: fa_deprn_summary ds,
635: fa_deprn_periods dp,
636: fa_additions_b ad
637: where tr.group_asset_id = h_group_asset_id
638: and tr.period_counter = h_period_counter

Line 3950: fa_deprn_summary ds,

3946: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3947: temp.eofy_salvage_value temp_eofy_salvage_value,
3948: temp.eop_salvage_value temp_eop_salvage_value
3949: from fa_books bk,
3950: fa_deprn_summary ds,
3951: fa_track_members temp
3952: where bk.book_type_code = h_book_type_code
3953: and bk.group_asset_id = h_group_asset_id
3954: and bk.date_ineffective is null

Line 3959: from fa_deprn_summary ds1

3955: and ds.book_type_code = bk.book_type_code
3956: and ds.asset_id = bk.asset_id
3957: and (ds.period_counter =
3958: (select max(ds1.period_counter)
3959: from fa_deprn_summary ds1
3960: where ds1.book_type_code=h_book_type_code
3961: and ds1.asset_id=bk.asset_id
3962: and ds1.period_counter <= h_period_counter - 1)
3963: or

Line 5903: FA_DEPRN_SUMMARY_PKG.Update_Row

5899: l_asset_deprn_rec.deprn_reserve||':'||l_asset_deprn_rec.ytd_deprn, p_log_level_rec => p_log_level_rec);
5900: fa_debug_pkg.add(l_calling_fn, 'l_deprn_adjustment_amount', l_deprn_adjustment_amount, p_log_level_rec => p_log_level_rec);
5901: end if;
5902:
5903: FA_DEPRN_SUMMARY_PKG.Update_Row
5904: (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
5905: X_Asset_Id => p_asset_hdr_rec.asset_id,
5906: X_Ytd_Deprn => l_asset_deprn_rec.ytd_deprn,
5907: X_Deprn_Reserve => l_asset_deprn_rec.deprn_reserve,

Line 6111: fa_deprn_summary ds,

6107: dp1.fiscal_year
6108: from fa_books bk,
6109: fa_deprn_periods dp,
6110: fa_deprn_periods dp1,
6111: fa_deprn_summary ds,
6112: fa_additions_b ad
6113: where dp.book_type_code = h_book_type_code
6114: and dp.period_counter = h_loop_period_counter
6115: and bk.book_type_code = dp.book_type_code

Line 6130: from fa_deprn_summary ds1

6126: and bk.depreciate_flag = decode(p_transaction_header_id,NULL,'YES',bk.depreciate_flag) -- added for bug 8584206
6127: and ds.book_type_code = bk.book_type_code
6128: and ds.period_counter =
6129: (select min(period_counter)
6130: from fa_deprn_summary ds1
6131: where ds1.book_type_code = h_book_type_code
6132: and ds1.asset_id = bk.asset_id
6133: and ds1.period_counter >= h_period_counter - 1)
6134: and ds.asset_id = bk.asset_id

Line 6214: fa_deprn_summary ds,

6210: ds.bonus_ytd_deprn,
6211: dp.fiscal_year
6212: from fa_books bk,
6213: fa_deprn_periods dp,
6214: fa_deprn_summary ds,
6215: fa_additions_b ad
6216: where dp.book_type_code = h_book_type_code
6217: and dp.period_counter = h_loop_period_counter
6218: and bk.book_type_code = dp.book_type_code

Line 6225: from fa_deprn_summary ds1

6221: and bk.depreciate_flag = 'YES'
6222: and ds.book_type_code = bk.book_type_code
6223: and ds.period_counter =
6224: (select min(period_counter)
6225: from fa_deprn_summary ds1
6226: where ds1.book_type_code = h_book_type_code
6227: and ds1.asset_id = bk.asset_id
6228: and ds1.period_counter >= h_period_counter - 1)
6229: and ds.asset_id = bk.asset_id

Line 6421: from fa_deprn_summary ds

6417:
6418: cursor ADDITION_RESERVE_YTD is
6419: select ds.deprn_reserve,
6420: ds.ytd_deprn
6421: from fa_deprn_summary ds
6422: where ds.book_type_code=h_book_type_code
6423: and ds.asset_id=h_member_asset_id
6424: and ds.deprn_source_code='BOOKS';
6425:

Line 7277: from fa_deprn_summary

7273: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is
7274: select deprn_source_code,
7275: ytd_deprn,
7276: deprn_reserve
7277: from fa_deprn_summary
7278: where book_type_code = h_book_type_code
7279: and asset_id = p_asset_id
7280: and period_counter = p_period_counter;
7281:

Line 8085: Update fa_deprn_summary set adjusted_cost = h_adjusted_cost

8081: when the member asset is added in second half then its adjusted_cost should be 50%.
8082: But its being populated as full value in 'Book' row of fa_ds. in Fa_books also its populated with full value.
8083: But the above update statement is updating the correct value, if tracking method is allocate.
8084: The following update statement written similar to above. */
8085: Update fa_deprn_summary set adjusted_cost = h_adjusted_cost
8086: where book_type_code = h_book_type_code
8087: and asset_id = h_member_asset_id
8088: and not exists (select 'non period of addition'
8089: from fa_Deprn_summary

Line 8089: from fa_Deprn_summary

8085: Update fa_deprn_summary set adjusted_cost = h_adjusted_cost
8086: where book_type_code = h_book_type_code
8087: and asset_id = h_member_asset_id
8088: and not exists (select 'non period of addition'
8089: from fa_Deprn_summary
8090: where deprn_source_code = 'DEPRN'
8091: and asset_id = h_member_asset_id
8092: and book_type_code = h_book_type_code)
8093: and exists (select 'reduction rate'

Line 8867: from fa_deprn_summary

8863: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is
8864: select deprn_source_code,
8865: ytd_deprn,
8866: deprn_reserve
8867: from fa_deprn_summary
8868: where book_type_code = h_book_type_code
8869: and asset_id = p_asset_id
8870: and period_counter = p_period_counter;
8871:

Line 10668: from fa_deprn_summary ds1,

10664: and set_of_books_id = h_set_of_books_id;
10665:
10666: cursor MEM_EXP_RESERVE is
10667: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10668: from fa_deprn_summary ds1,
10669: fa_deprn_periods dp1
10670: where ds1.book_type_code = h_book_type_code
10671: and ds1.asset_id = h_member_asset_id
10672: and dp1.book_type_code = ds1.book_type_Code

Line 10676: from fa_deprn_summary ds2

10672: and dp1.book_type_code = ds1.book_type_Code
10673: and dp1.period_counter = ds1.period_counter
10674: and ds1.period_counter =
10675: (select max(period_counter)
10676: from fa_deprn_summary ds2
10677: where ds2.book_type_code = h_book_type_code
10678: and ds2.asset_id = h_member_asset_id
10679: and period_counter <= h_period_counter);
10680: