[Home] [Help]
65: CURSOR ret_adj_cur IS
66: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
67: fad.adjustment_type adj_type
68: FROM fa_adjustments fad,
69: fa_book_controls bc,
70: fa_fiscal_year fy,
71: fa_transaction_headers thg
72: WHERE fad.asset_id = l_group_rec.asset_id
73: AND fad.book_type_code = p_book_type_code
85: CURSOR mc_ret_adj_cur IS
86: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
87: fad.adjustment_type adj_type
88: FROM fa_mc_adjustments fad,
89: fa_book_controls bc,
90: fa_fiscal_year fy,
91: fa_transaction_headers thg
92: WHERE fad.asset_id = l_group_rec.asset_id
93: AND fad.book_type_code = p_book_type_code
136: if h_sob_id is not null then
137: begin
138: select 'P'
139: into H_MRCSOBTYPE
140: from fa_book_controls
141: where book_type_code = p_book_type_code
142: and set_of_books_id = h_sob_id;
143: exception
144: when no_data_found then
162: l_info_rec.functional_currency_code,
163: l_info_rec.set_of_books_id,
164: l_info_rec.deprn_calendar
165: FROM fa_system_controls sc,
166: fa_book_controls bc,
167: gl_sets_of_books sob,
168: fnd_currencies cur
169: WHERE bc.book_type_code = p_book_type_code
170: AND sob.set_of_books_id = decode(H_MRCSOBTYPE, 'P', bc.set_of_books_id, h_sob_id) -- MRC
363: l_group_rec.cost_retired,
364: l_group_rec.reserve_retired,
365: l_group_rec.recapture_amount
366: FROM fa_retirements ret,
367: fa_book_controls bc,
368: fa_fiscal_year fy,
369: fa_transaction_headers thg,
370: fa_transaction_headers thm
371: WHERE bc.book_type_code = p_book_type_code
393: l_group_rec.cost_retired,
394: l_group_rec.reserve_retired,
395: l_group_rec.recapture_amount
396: FROM fa_mc_retirements ret,
397: fa_book_controls bc,
398: fa_fiscal_year fy,
399: fa_transaction_headers thg,
400: fa_transaction_headers thm
401: WHERE bc.book_type_code = p_book_type_code
460: 0)), 0)
461: INTO l_group_adjustment_amount,
462: l_second_half_grp_adjustment
463: FROM fa_adjustments adj,
464: fa_book_controls bc,
465: fa_fiscal_year fy,
466: fa_transaction_headers thg
467: WHERE thg.asset_id = l_group_rec.asset_id
468: AND thg.book_type_code = p_book_type_code
489: 0)), 0)
490: INTO l_group_adjustment_amount,
491: l_second_half_grp_adjustment
492: FROM fa_mc_adjustments adj,
493: fa_book_controls bc,
494: fa_fiscal_year fy,
495: fa_transaction_headers thg
496: WHERE thg.asset_id = l_group_rec.asset_id
497: AND thg.book_type_code = p_book_type_code
533: INTO l_group_reclass_cost_in_out
534: FROM fa_books bk,
535: fa_books bk_old,
536: fa_transaction_headers fth,
537: fa_book_controls bc,
538: fa_deprn_periods dp
539: WHERE bk.transaction_header_id_in = fth.transaction_header_id
540: AND bk_old.transaction_header_id_out = fth.transaction_header_id
541: AND fth.ASSET_ID = l_group_rec.asset_id
573: FROM fa_mc_books bk,
574: fa_mc_books bk_old,
575: fa_transaction_headers fth,
576: fa_mc_book_controls bc,
577: fa_book_controls bc1,
578: fa_mc_deprn_periods dp
579: WHERE bk.transaction_header_id_in = fth.transaction_header_id
580: AND bk_old.transaction_header_id_out = fth.transaction_header_id
581: AND fth.ASSET_ID = l_group_rec.asset_id
1268: ''CIP COST-DR'', adj.adjustment_amount,
1269: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
1270: adjustment_amount
1271: FROM fa_adjustments adj,
1272: fa_book_controls bc,
1273: fa_fiscal_year fy,
1274: fa_transaction_headers thm,
1275: fa_books bkm
1276: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1314: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
1315: adjustment_amount
1316: FROM fa_mc_adjustments adj,
1317: fa_mc_book_controls bc,
1318: fa_book_controls bc1,
1319: fa_fiscal_year fy,
1320: fa_transaction_headers thm,
1321: fa_mc_books bkm
1322: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1372: NVL(SUM(ret.cost_of_removal), 0) cost_of_removal,
1373: NVL(SUM(ret.cost_retired), 0) cost_retired,
1374: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1375: FROM fa_retirements ret,
1376: fa_book_controls bc,
1377: fa_fiscal_year fy,
1378: fa_transaction_headers thm,
1379: fa_books bkm
1380: WHERE bkm.group_asset_id = ' || p_group_asset_id || '