[Home] [Help]
580: n_period_counter fa_deprn_summary.period_counter%TYPE)
581: IS
582: SELECT DISTINCT fh.asset_id asset_id
583: FROM fa_books fb,
584: fa_additions fh,
585: igi_iac_category_books fcb
586: WHERE fb.book_type_code = n_book_code
587: AND fb.book_type_code = fcb.book_type_code
588: AND fcb.category_id = fh.asset_category_id
604: n_period_counter fa_deprn_summary.period_counter%TYPE)
605: IS
606: SELECT DISTINCT fh.asset_id asset_id
607: FROM fa_books fb,
608: fa_additions fh,
609: igi_iac_category_books fcb
610: WHERE fb.book_type_code = n_book_code
611: AND fb.book_type_code = fcb.book_type_code
612: AND fcb.category_id = fh.asset_category_id
633: sum(nvl(id.adjustment_cost,0) + nvl(dd.cost,0)) adjusted_cost,
634: sum(nvl(id.Deprn_Period+dd.deprn_amount-dd.deprn_adjustment_amount, 0)) deprn_period,
635: sum(nvl(id.Deprn_YTD+ifd.deprn_ytd, 0)) deprn_ytd,
636: 'IAC' source_type
637: FROM fa_additions ad ,
638: fa_Books bk ,
639: fa_distribution_history dh,
640: fa_deprn_Detail dd ,
641: igi_iac_det_balances id ,
683: sum(nvl(dd.cost,0)) adjusted_cost,
684: sum(nvl(dd.deprn_amount,0)-nvl(dd.deprn_adjustment_amount,0)) deprn_period,
685: sum(nvl(dd.ytd_deprn,0)) deprn_ytd,
686: 'FA' source_type
687: FROM fa_additions ad,
688: fa_Books bk,
689: fa_distribution_history dh,
690: fa_deprn_Detail dd,
691: gl_code_combinations cc,
727: sum(nvl(dd.cost,0)) adjusted_cost,
728: 0 deprn_period,
729: 0 deprn_ytd,
730: 'NONDEPFA' source_type
731: FROM fa_additions ad,
732: fa_Books bk,
733: fa_distribution_history dh,
734: fa_deprn_Detail dd,
735: gl_code_combinations cc,
766: sum(nvl(dd.cost,0)) adjusted_cost,
767: sum(nvl(dd.deprn_amount,0)-nvl(dd.deprn_adjustment_amount,0)) deprn_period,
768: sum(nvl(dd.ytd_deprn,0)) deprn_ytd,
769: 'FULLRSVDFA' source_type
770: FROM fa_additions ad,
771: fa_Books bk,
772: fa_distribution_history dh,
773: fa_deprn_Detail dd,
774: gl_code_combinations cc,