[Home] [Help]
91: l_info_rec.functional_currency_code,
92: l_info_rec.set_of_books_id,
93: l_info_rec.deprn_calendar
94: FROM fa_system_controls sc,
95: fa_book_controls bc,
96: gl_sets_of_books sob,
97: fnd_currencies cur
98: WHERE bc.book_type_code = p_book_type_code
99: AND sob.set_of_books_id = bc.set_of_books_id
292: l_group_rec.cost_retired,
293: l_group_rec.reserve_retired,
294: l_group_rec.recapture_amount
295: FROM fa_retirements ret,
296: fa_book_controls bc,
297: fa_fiscal_year fy,
298: fa_transaction_headers thg,
299: fa_transaction_headers thm
300: WHERE bc.book_type_code = p_book_type_code
330: 0)), 0)
331: INTO l_group_adjustment_amount,
332: l_second_half_grp_adjustment
333: FROM fa_adjustments adj,
334: fa_book_controls bc,
335: fa_fiscal_year fy,
336: fa_transaction_headers thg
337: WHERE thg.asset_id = l_group_rec.asset_id
338: AND thg.book_type_code = p_book_type_code
987: ''CIP COST-DR'', adj.adjustment_amount,
988: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
989: adjustment_amount
990: FROM fa_adjustments adj,
991: fa_book_controls bc,
992: fa_fiscal_year fy,
993: fa_transaction_headers thm,
994: fa_books bkm
995: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1037: NVL(SUM(ret.cost_of_removal), 0) cost_of_removal,
1038: NVL(SUM(ret.cost_retired), 0) cost_retired,
1039: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1040: FROM fa_retirements ret,
1041: fa_book_controls bc,
1042: fa_fiscal_year fy,
1043: fa_transaction_headers thm,
1044: fa_books bkm
1045: WHERE bkm.group_asset_id = ' || p_group_asset_id || '