[Home] [Help]
636: l_life_in_months fa_Books.life_in_months%TYPE;
637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
643: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
644: l_dep_backlog NUMBER;
679: 0 Acc_Deprn_backlog,
680: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Total
681: FROM fa_additions ad,
682: fa_Books bk,
683: fa_distribution_history dh,
684: fa_deprn_Detail dd,
685: gl_code_combinations cc,
686: fa_categories cf,
687: fa_asset_history ah,
757: sum(nvl(id.Deprn_Reserve_backlog, 0) ) Acc_Deprn_Backlog ,
758: sum(nvl(id.Deprn_Reserve+dd.deprn_reserve+id.deprn_Reserve_backlog, 0)) Acc_Deprn_Total
759: FROM fa_additions ad ,
760: fa_Books bk ,
761: fa_distribution_history dh,
762: fa_deprn_Detail dd ,
763: igi_iac_det_balances id,
764: igi_iac_fa_deprn ifd,
765: gl_code_combinations cc,
1029: l_life_in_months fa_Books.life_in_months%TYPE;
1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1036: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1037: l_dep_backlog NUMBER;
1084: 0 Acc_Deprn_backlog,
1085: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Total
1086: FROM fa_additions ad,
1087: fa_Books bk,
1088: fa_distribution_history dh,
1089: fa_deprn_Detail dd,
1090: gl_code_combinations cc,
1091: fa_categories cf,
1092: fa_asset_history ah,
1181: sum(nvl(id.Deprn_Reserve_backlog, 0) ) Acc_Deprn_Backlog ,
1182: sum(nvl(id.Deprn_Reserve+dd.deprn_reserve+id.deprn_Reserve_backlog, 0)) Acc_Deprn_Total
1183: FROM fa_additions ad ,
1184: fa_Books bk ,
1185: fa_distribution_history dh,
1186: fa_deprn_Detail dd ,
1187: igi_iac_det_balances id,
1188: igi_iac_fa_deprn ifd,
1189: gl_code_combinations cc,
1546: l_life_in_months fa_Books.life_in_months%TYPE;
1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1553: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1554: l_dep_backlog NUMBER;
1589: 0 Oper_Acct_Backlog,
1590: 0 Oper_Acct_Net
1591: FROM fa_additions ad,
1592: fa_Books bk,
1593: fa_distribution_history dh,
1594: fa_deprn_Detail dd,
1595: gl_code_combinations cc,
1596: fa_categories cf,
1597: fa_category_books cb,
1665: sum(nvl(id.operating_acct_backlog * -1 ,0)) Oper_Acct_Backlog,
1666: sum(nvl(id.operating_acct_net * -1 ,0)) Oper_Acct_Net
1667: FROM fa_additions ad ,
1668: fa_Books bk ,
1669: fa_distribution_history dh,
1670: fa_deprn_Detail dd ,
1671: igi_iac_det_balances id ,
1672: gl_code_combinations cc,
1673: fa_categories cf,
1922: l_life_in_months fa_Books.life_in_months%TYPE;
1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1929: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
1930: l_dep_backlog NUMBER;
1977: 0 Oper_Acct_Backlog,
1978: 0 Oper_Acct_Net
1979: FROM fa_additions ad,
1980: fa_Books bk,
1981: fa_distribution_history dh,
1982: fa_deprn_Detail dd,
1983: gl_code_combinations cc,
1984: fa_categories cf,
1985: fa_category_books cb,
2072: sum(nvl(id.operating_acct_backlog * -1,0)) Oper_Acct_Backlog,
2073: sum(nvl(id.operating_acct_net * -1 ,0)) Oper_Acct_Net
2074: FROM fa_additions ad ,
2075: fa_Books bk ,
2076: fa_distribution_history dh,
2077: fa_deprn_Detail dd ,
2078: igi_iac_det_balances id ,
2079: gl_code_combinations cc,
2080: fa_categories cf,
2430: l_life_in_months fa_Books.life_in_months%TYPE;
2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2437: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2438: l_dep_backlog NUMBER;
2473: 0 Reval_Reserve_Gen_Fund,
2474: 0 Reval_Reserve_Net
2475: FROM fa_additions ad,
2476: fa_Books bk,
2477: fa_distribution_history dh,
2478: fa_deprn_Detail dd,
2479: gl_code_combinations cc,
2480: fa_categories cf,
2481: fa_category_books cb,
2551: sum(nvl(id.reval_reserve_gen_fund, 0)) Reval_Reserve_Gen_Fund,
2552: sum(nvl(id.reval_reserve_net, 0) ) Reval_Reserve_Net
2553: FROM fa_additions ad ,
2554: fa_Books bk ,
2555: fa_distribution_history dh ,
2556: fa_deprn_Detail dd ,
2557: igi_iac_det_balances id ,
2558: gl_code_combinations cc,
2559: fa_categories cf,
2821: l_life_in_months fa_Books.life_in_months%TYPE;
2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2828: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
2829: l_dep_backlog NUMBER;
2876: 0 Reval_Reserve_Gen_Fund,
2877: 0 Reval_Reserve_Net
2878: FROM fa_additions ad,
2879: fa_Books bk,
2880: fa_distribution_history dh,
2881: fa_deprn_Detail dd,
2882: gl_code_combinations cc,
2883: fa_categories cf,
2884: fa_category_books cb,
2972: sum(nvl(id.reval_reserve_gen_fund, 0)) Reval_Reserve_Gen_Fund,
2973: sum(nvl(id.reval_reserve_net, 0) ) Reval_Reserve_Net
2974: FROM fa_additions ad ,
2975: fa_Books bk ,
2976: fa_distribution_history dh ,
2977: fa_deprn_Detail dd ,
2978: igi_iac_det_balances id ,
2979: gl_code_combinations cc,
2980: fa_categories cf,
3326: l_life_in_months fa_Books.life_in_months%TYPE;
3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3333: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3334: l_dep_backlog NUMBER;
3370: sum(nvl(dd.deprn_reserve,0)) Acct_Deprn,
3371: 0 Backlog
3372: FROM fa_additions ad,
3373: fa_Books bk,
3374: fa_distribution_history dh,
3375: fa_deprn_Detail dd,
3376: gl_code_combinations cc,
3377: fa_categories cf,
3378: fa_category_books cb,
3449: sum(nvl(id.deprn_reserve + dd.deprn_reserve, 0) ) Acct_Deprn,
3450: sum(nvl( id.deprn_reserve_backlog , 0)) Backlog
3451: FROM fa_additions ad ,
3452: fa_Books bk ,
3453: fa_distribution_history dh,
3454: fa_deprn_Detail dd ,
3455: igi_iac_det_balances id ,
3456: gl_code_combinations cc,
3457: fa_categories cf,
3716: l_life_in_months fa_Books.life_in_months%TYPE;
3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3723: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;
3724: l_dep_backlog NUMBER;
3772: sum(nvl(dd.deprn_reserve,0)) Acct_Deprn,
3773: 0 Backlog
3774: FROM fa_additions ad,
3775: fa_Books bk,
3776: fa_distribution_history dh,
3777: fa_deprn_Detail dd,
3778: gl_code_combinations cc,
3779: fa_categories cf,
3780: fa_category_books cb,
3868: sum(nvl(id.deprn_reserve + dd.deprn_reserve, 0) ) Acct_Deprn,
3869: sum(nvl( id.deprn_reserve_backlog , 0)) Backlog
3870: FROM fa_additions ad ,
3871: fa_Books bk ,
3872: fa_distribution_history dh,
3873: fa_deprn_Detail dd ,
3874: igi_iac_det_balances id ,
3875: gl_code_combinations cc,
3876: fa_categories cf,