[Home] [Help]
368: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
369: INTO l_group_reclass_in
370: FROM fa_adjustments adj,
371: fa_transaction_headers thg,
372: fa_books bkm,
373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id
375: FROM fa_books bk_pre,
376: fa_deprn_summary ds_pre,
371: fa_transaction_headers thg,
372: fa_books bkm,
373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id
375: FROM fa_books bk_pre,
376: fa_deprn_summary ds_pre,
377: fa_deprn_periods dp_pre
378: WHERE bk_pre.book_type_code = p_book_type_code
379: AND dp_pre.book_type_code = bk_pre.book_type_code
406: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
407: INTO l_group_reclass_out
408: FROM fa_adjustments adj,
409: fa_transaction_headers thg,
410: fa_books bkm
411: WHERE adj.asset_id = l_group_rec.asset_id
412: AND adj.book_type_code = p_book_type_code
413: AND thg.transaction_header_id = adj.transaction_header_id
414: AND adj.period_counter_created
479: AND NVL(l_group_rec.rule_name, ' ') = FA_RXGA_POSITIVE_REDUCTION THEN
480:
481: SELECT COUNT(*)
482: INTO l_non_cip_num
483: FROM fa_books bk, fa_additions ad
484: WHERE bk.book_type_code = p_book_type_code
485: AND bk.group_asset_id = l_group_rec.asset_id
486: AND ad.asset_type <> 'CIP'
487: AND bk.asset_id = ad.asset_id;
753: x_sql_stmt OUT NOCOPY VARCHAR2)
754: IS
755: BEGIN
756:
757: -- Subquery is to get fa_books and fa_deprn_summary,
758: -- which are used to calculate beginning NBV.
759: -- Subquery doesn't necessarily get the previous year info.
760: -- If there was no depreciation calculation in the previous year,
761: -- subquery gets the max period counter prior to the fiscal year.
761: -- subquery gets the max period counter prior to the fiscal year.
762:
763: x_sql_stmt := ' FROM
764: fa_additions ad,
765: fa_books bk,
766: fa_categories_b cat,
767: fa_deprn_basis_rules br,
768: fa_methods met,
769: fa_deprn_periods dp,
772: bk_pre.group_asset_id,
773: bk_pre.cost,
774: bk_pre.cip_cost,
775: ds_pre.deprn_reserve
776: FROM fa_books bk_pre,
777: fa_deprn_summary ds_pre,
778: fa_deprn_periods dp_pre,
779: fa_additions ad_pre
780: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
826: x_sql_stmt OUT NOCOPY VARCHAR2)
827: IS
828: BEGIN
829:
830: -- This where clause ges fa_books, which corresponds to
831: -- the last depreciated period in the fiscal year.
832:
833: -- This also gets fa_deprn_summary no matter what.
834: -- There is at least deprn_source_code = 'BOOKS' row for every asset.
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 || '
996: AND adj.asset_id = bkm.asset_id
997: AND bkm.transaction_header_id_in = thm.transaction_header_id
998: AND adj.book_type_code = ''' || p_info_rec.book_type_code || '''
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 || '
1046: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''
1047: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '
1048: AND fy.fiscal_year_name = bc.fiscal_year_name
1325: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1326: INTO l_group_reclass_out
1327: FROM fa_adjustments adj,
1328: fa_transaction_headers thg,
1329: fa_books bkm
1330: WHERE adj.asset_id = p_group_rec.asset_id
1331: AND adj.book_type_code = p_info_rec.book_type_code
1332: AND thg.transaction_header_id = adj.transaction_header_id
1333: AND adj.period_counter_created
1361: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1362: INTO l_group_reclass_in
1363: FROM fa_adjustments adj,
1364: fa_transaction_headers thg,
1365: fa_books bkm
1366: WHERE adj.asset_id = p_group_rec.asset_id
1367: AND adj.book_type_code = p_info_rec.book_type_code
1368: AND thg.transaction_header_id = adj.transaction_header_id
1369: AND adj.period_counter_created