[Home] [Help]
462: nvl(ds.ytd_deprn,0) ytd_deprn,
463: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
464: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
465: from fa_mc_books bk,
466: fa_mc_deprn_summary ds,
467: fa_additions_b ad
468: where bk.group_asset_id = h_group_asset_id
469: and bk.book_type_code = h_book_type_code
470: and bk.date_ineffective is null
473: and ds.book_type_code = h_book_type_code
474: and ds.asset_id = bk.asset_id
475: and ds.period_counter =
476: (select max(ds1.period_counter)
477: from fa_mc_deprn_summary ds1
478: where ds1.book_type_code = h_book_type_code
479: and ds1.asset_id = bk.asset_id
480: and ds1.set_of_books_id = p_set_of_books_id
481: and ds1.period_counter <= h_period_counter - 1)
665: ds.bonus_deprn_reserve,
666: ds.bonus_ytd_deprn
667: from fa_track_members tr,
668: fa_mc_books bk,
669: fa_mc_deprn_summary ds,
670: fa_mc_deprn_periods dp,
671: fa_additions_b ad
672: where tr.group_asset_id = h_group_asset_id
673: and tr.period_counter = h_period_counter
3993: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3994: temp.eofy_salvage_value temp_eofy_salvage_value,
3995: temp.eop_salvage_value temp_eop_salvage_value
3996: from fa_mc_books bk,
3997: fa_mc_deprn_summary ds,
3998: fa_track_members temp
3999: where bk.book_type_code = h_book_type_code
4000: and bk.group_asset_id = h_group_asset_id
4001: and bk.date_ineffective is null
4004: and ds.asset_id = bk.asset_id
4005: -- and ds.period_counter = h_period_counter - 1
4006: and (ds.period_counter =
4007: (select max(ds1.period_counter)
4008: from fa_mc_deprn_summary ds1
4009: where ds1.book_type_code=h_book_type_code
4010: and ds1.asset_id=bk.asset_id
4011: and ds1.set_of_books_id = h_set_of_books_id
4012: and ds1.period_counter <= h_period_counter - 1)
6156: dp1.fiscal_year
6157: from fa_mc_books bk,
6158: fa_mc_deprn_periods dp,
6159: fa_mc_deprn_periods dp1,
6160: fa_mc_deprn_summary ds,
6161: fa_additions_b ad
6162: where dp.book_type_code = h_book_type_code
6163: and dp.period_counter = h_loop_period_counter
6164: and dp.set_of_books_id = p_set_of_books_id
6178: and bk.depreciate_flag = decode(p_transaction_header_id,NULL,'YES',bk.depreciate_flag) -- added for bug 8584206
6179: and ds.book_type_code = bk.book_type_code
6180: and ds.period_counter =
6181: (select min(period_counter)
6182: from fa_mc_deprn_summary ds1
6183: where ds1.book_type_code = h_book_type_code
6184: and ds1.asset_id = bk.asset_id
6185: and ds1.period_counter >= h_period_counter - 1)
6186: and ds.set_of_books_id = p_set_of_books_id
6248: ds.bonus_ytd_deprn,
6249: dp.fiscal_year
6250: from fa_mc_books bk,
6251: fa_mc_deprn_periods dp,
6252: fa_mc_deprn_summary ds,
6253: fa_additions_b ad
6254: where dp.book_type_code = h_book_type_code
6255: and dp.period_counter = h_loop_period_counter
6256: and dp.set_of_books_id = p_set_of_books_id
6261: and bk.depreciate_flag = 'YES'
6262: and ds.book_type_code = bk.book_type_code
6263: and ds.period_counter =
6264: (select min(period_counter)
6265: from fa_mc_deprn_summary ds1
6266: where ds1.book_type_code = h_book_type_code
6267: and ds1.asset_id = bk.asset_id
6268: and ds1.period_counter >= h_period_counter - 1)
6269: and ds.set_of_books_id = p_set_of_books_id
6425:
6426: cursor ADDITION_RESERVE_YTD_MRC is
6427: select ds.deprn_reserve,
6428: ds.ytd_deprn
6429: from fa_mc_deprn_summary ds
6430: where ds.book_type_code=h_book_type_code
6431: and ds.asset_id=h_member_asset_id
6432: and ds.deprn_source_code='BOOKS'
6433: and ds.set_of_books_id=p_set_of_books_id;
7282: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
7283: select deprn_source_code,
7284: ytd_deprn,
7285: deprn_reserve
7286: from fa_mc_deprn_summary
7287: where book_type_code = h_book_type_code
7288: and asset_id = p_asset_id
7289: and period_counter = p_period_counter
7290: and set_of_books_id = h_set_of_books_id;
8164: But its being populated as full value. in Fa_books also its populated with full value.
8165: But the above update statement is updating the correct value, if tracking method is allocate.
8166: The following update statement written similar to above. */
8167:
8168: Update fa_mc_deprn_summary set adjusted_cost = h_adjusted_cost
8169: where book_type_code = h_book_type_code
8170: and asset_id = h_member_asset_id
8171: and not exists (select 'non period of addition'
8172: from fa_mc_deprn_summary
8168: Update fa_mc_deprn_summary set adjusted_cost = h_adjusted_cost
8169: where book_type_code = h_book_type_code
8170: and asset_id = h_member_asset_id
8171: and not exists (select 'non period of addition'
8172: from fa_mc_deprn_summary
8173: where deprn_source_code = 'DEPRN'
8174: and asset_id = h_member_asset_id
8175: and book_type_code = h_book_type_code
8176: and set_of_books_id = h_set_of_books_id)
8872: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
8873: select deprn_source_code,
8874: ytd_deprn,
8875: deprn_reserve
8876: from fa_mc_deprn_summary
8877: where book_type_code = h_book_type_code
8878: and asset_id = p_asset_id
8879: and period_counter = p_period_counter
8880: and set_of_books_id = h_set_of_books_id;
10679: and period_counter <= h_period_counter);
10680:
10681: cursor MEM_EXP_RESERVE_MRC is
10682: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10683: from fa_mc_deprn_summary ds1,
10684: fa_mc_deprn_periods dp1
10685: where ds1.book_type_code = h_book_type_code
10686: and ds1.asset_id = h_member_asset_id
10687: and ds1.set_of_books_id = h_set_of_books_id
10689: and dp1.period_counter = ds1.period_counter
10690: and dp1.set_of_books_id = h_set_of_books_id
10691: and ds1.period_counter =
10692: (select max(period_counter)
10693: from fa_mc_deprn_summary ds2
10694: where ds2.book_type_code = h_book_type_code
10695: and ds2.asset_id = h_member_asset_id
10696: and period_counter <= h_period_counter
10697: and set_of_books_id = h_set_of_books_id);