ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0F83869E053B46B63588994 SELECT substr(fad.description,1,11) Asset_Description, substr(fad.asset_number,1,8) Asset_Number, sum(nvl(fdd3.deprn_reserve,0)) Tax_Dp_reserve, sum(nvl(fdd3.cost,0) - nvl(fdd3.deprn_reserve,0)) Initial_NBV, fad.asset_id Asset_id, fah.category_id Asset_Category_Id --JE_JEFIASDR_XMLP_PKG.cf_asset_close_nbvformula(:CF_ASS_INITIAL_NBV_ADJUSTED, :CF_ASS_TAX_ADDITIONS, :CS_ASS_TAX_RETIREMENT, --:a1_1, :CF_ASS_DEF_DP) CF_ASS_CLOSE_NBV, --&CS_ASS_TAX_ADDITIONS CF_ASS_TAX_ADDITIONS, -- JE_JEFIASDR_XMLP_PKG.cf_ass_def_dpformula(:CS_ASS_TAX_DEPRN, :a1_1, :CS_ass_this_fisadj) CF_ASS_DEF_DP, -- JE_JEFIASDR_XMLP_PKG.cf_ass_initial_nbv_adjustedfor(substr ( fad.asset_number , 1 , 8 ), :CAT_ID, :ENABLED_FLAG, sum ( nvl --( fdd3.cost , 0 ) - nvl ( fdd3.deprn_reserve , 0 ) ), :CS_ASS_FISCAL_ADJUSTMENT) CF_ASS_INITIAL_NBV_ADJUSTED, -- JE_JEFIASDR_XMLP_PKG.cf_ass_tax_dp_reserve_adjusted(sum ( nvl ( fdd3.deprn_reserve , 0 ) ), :CS_ASS_FISCAL_ADJUSTMENT) --CF_ASS_TAX_DP_RESERVE_ADJUSTED, --&CS_ASS_CORP_ADDITIONS CF_ASS_CORP_ADDITIONS FROM fa_asset_history fah, fa_additions fad, fa_deprn_detail fdd3, fa_books bks WHERE fah.asset_id = fad.asset_id and fdd3.asset_id = fad.asset_id and fad.asset_id = bks.asset_id and fdd3.book_type_code = bks.book_type_code and bks.book_type_code = :P_TAX_BOOK and (fdd3.period_counter = :C_FROM_COUNTER - 1 OR (fdd3.period_counter between :C_FROM_COUNTER and :C_TO_COUNTER and fdd3.deprn_source_code= 'B') OR (bks.depreciate_flag = 'NO' and fdd3.period_counter < :C_FROM_COUNTER)) and fah.transaction_header_id_in = ( SELECT max(ah2.transaction_header_id_in) FROM fa_asset_history ah2 WHERE ah2.asset_id = fah.asset_id and ah2.category_id = fah.category_id and to_date(ah2.date_effective,'dd-mon-yy') <=:C_TIME_TO_CLOSE_DATE and nvl(ah2.date_ineffective,:C_TIME_TO_CLOSE_DATE) >= :C_TIME_TO_CLOSE_DATE ) and to_date(bks.date_effective,'dd-mon-yy') <= :C_TO_CLOSE_DATE and nvl(bks.date_ineffective,:C_TO_CLOSE_DATE) >= :C_TO_OPEN_DATE and nvl(bks.period_counter_fully_retired,:C_FROM_COUNTER) >= :C_FROM_COUNTER &C_ASSET_WHERE and bks.transaction_header_id_in = (SELECT min(bks2.transaction_header_id_in) FROM fa_books bks2 WHERE bks2.book_type_code = :P_TAX_BOOK and bks2.asset_id = fad.asset_id and to_date(bks2.date_effective,'dd-mon-yy') <= :C_TO_CLOSE_DATE and nvl(bks2.date_ineffective,:C_TO_CLOSE_DATE) >= :C_TO_OPEN_DATE and nvl(bks2.period_counter_fully_retired,:C_FROM_COUNTER) >= :C_FROM_COUNTER) GROUP BY fad.description, fad.asset_number, bks.cost, fad.asset_id, fah.category_id UNION ALL SELECT substr(fad.description,1,11) Asset_Description, substr(fad.asset_number,1,8) Asset_Number, 0 Tax_Dp_reserve, 0 Initial_NBV, fad.asset_id Asset_id, fah.category_id Asset_Category_Id -- JE_JEFIASDR_XMLP_PKG.cf_asset_close_nbvformula(:CF_ASS_INITIAL_NBV_ADJUSTED, :CF_ASS_TAX_ADDITIONS, :CS_ASS_TAX_RETIREMENT, --:a1_1, :CF_ASS_DEF_DP) CF_ASS_CLOSE_NBV, -- &CS_ASS_TAX_ADDITIONS CF_ASS_TAX_ADDITIONS, -- JE_JEFIASDR_XMLP_PKG.cf_ass_def_dpformula(:CS_ASS_TAX_DEPRN, :a1_1, :CS_ass_this_fisadj) CF_ASS_DEF_DP, -- JE_JEFIASDR_XMLP_PKG.cf_ass_initial_nbv_adjustedfor(substr ( fad.asset_number , 1 , 8 ), :CAT_ID, :ENABLED_FLAG, -- sum ( nvl ( fdd3.cost , 0 ) - nvl ( fdd3.deprn_reserve , 0 ) ), :CS_ASS_FISCAL_ADJUSTMENT) --CF_ASS_INITIAL_NBV_ADJUSTED, -- JE_JEFIASDR_XMLP_PKG.cf_ass_tax_dp_reserve_adjusted(sum ( nvl ( fdd3.deprn_reserve , 0 ) ), :CS_ASS_FISCAL_ADJUSTMENT) --CF_ASS_TAX_DP_RESERVE_ADJUSTED, -- &CS_ASS_CORP_ADDITIONS CF_ASS_CORP_ADDITIONS FROM fa_asset_history fah, fa_additions fad, fa_books bks WHERE fah.asset_id = fad.asset_id and fad.asset_id = bks.asset_id and bks.book_type_code = :P_TAX_BOOK and not exists (select 'x' from fa_deprn_detail fdd3 where fdd3.asset_id = fad.asset_id and fdd3.book_type_code = :P_tax_book and ( (fdd3.period_counter = :C_FROM_COUNTER - 1) OR (fdd3.period_counter between :C_FROM_COUNTER and :C_TO_COUNTER and fdd3.deprn_source_code= 'B') OR (bks.depreciate_flag = 'NO' and fdd3.period_counter < :C_FROM_COUNTER) ) ) and exists (select 'x' from fa_deprn_detail fddcorp where fddcorp.asset_id = fad.asset_id and fddcorp.book_type_code = :C_distribution_source_book and fddcorp.period_counter >= :C_corp_from_counter ) and fah.transaction_header_id_in = (SELECT max(ah2.transaction_header_id_in) FROM fa_asset_history ah2 WHERE ah2.asset_id = fah.asset_id and ah2.category_id = fah.category_id and to_date(ah2.date_effective,'dd-mon-yy') <= :C_TIME_TO_CLOSE_DATE and nvl(ah2.date_ineffective, :C_TIME_TO_CLOSE_DATE) >= :C_TIME_TO_CLOSE_DATE) and to_date(bks.date_effective,'dd-mon-yy') <= :C_TO_CLOSE_DATE and nvl(bks.date_ineffective, :C_TO_CLOSE_DATE) >= :C_TO_OPEN_DATE and nvl(bks.period_counter_fully_retired, :C_FROM_COUNTER) >= :C_FROM_COUNTER &C_ASSET_WHERE and bks.transaction_header_id_in = (SELECT min(bks2.transaction_header_id_in) FROM fa_books bks2 WHERE bks2.book_type_code = :P_TAX_BOOK and bks2.asset_id = fad.asset_id and to_date(bks2.date_effective,'dd-mon-yy') <= :C_TO_CLOSE_DATE and nvl(bks2.date_ineffective, :C_TO_CLOSE_DATE) >= :C_TO_OPEN_DATE and nvl(bks2.period_counter_fully_retired, :C_FROM_COUNTER) >= :C_FROM_COUNTER) and fah.category_id=:Cat_id GROUP BY fad.description, fad.asset_number, bks.cost, fad.asset_id, fah.category_id ORDER BY asset_number Y JE JEFIASDR_XML US JE Finnish Deferred Depreciation Expense - draft Application: European Localizations Source: Finnish Deferred Depreciation Expense Report (XML) - Not Supported: Reserved For Future Use Short Name: JEFIASDR_XML DB package: JE_JEFIASDR_XMLP_PKG BI Publisher &c_asset_where &cs_ass_corp_additions &cs_ass_tax_additions :c_account_flex_id :c_acct_flex_bal_seg :c_acct_flex_struct :c_all_category :c_asset_key_struct :c_asset_where :c_book_class :c_book_type_code :c_calendar_close_date :c_calendar_open_date :c_cat_flex_struct :c_close_date :c_corp_calendar_close_date :c_corp_calendar_open_date :c_corp_from_counter :c_corp_time_to_close_date :c_corp_to_close_date :c_corp_to_counter :c_corp_to_open_date :c_cost_account :c_cost_acct_desc :c_cost_company :c_currency_code :c_distribution_corp_book :c_distribution_source_book :c_end_counter :c_fiscal_year :c_from_close_date :c_from_counter :c_from_fiscal_year :c_from_open_date :c_major_category :c_precision :c_report_date :c_set_of_books_id :c_sob_name :c_start_counter :c_start_date :c_time_to_close_date :c_to_close_date :c_to_counter :c_to_fiscal_year :c_to_open_date :c_where_cat_flex :cat_id :cp_calendar_close_date :cp_calendar_open_date :cp_close_date :cp_currency_code :cp_distribution_corp_book :cp_from_fiscal_year :cp_lastyr_begin_period_counter :cp_period_name :cp_report_name :cp_report_type :cp_sob_name :cp_tax_book :func_currency :operating_unit :orderby_acct :p_as_num_high :p_as_num_low :p_category_flex_from :p_category_flex_to :p_conc_request_id :p_debug_switch :p_period_name :p_report_type :p_set_of_books_id :p_tax_book :precision :select_all :set_of_books_name :struct_num :where_flex 1 10 :p_tax_book LOV Oracle FA_TAX_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='TAX' order by book_type_code Y US Tax Book 2 20 :p_period_name LOV Oracle JGZZ_FA_TAX_BOOK_DEPRN_PERIODS Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_tax_books and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_tax_books) and (period_close_date is not null or (period_close_date is null and deprn_run is not null)) order by period_counter Y US Period 3 30 :p_report_type LOV Oracle JEDE_FA_REPORT_CATEGORY Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=102990 order by ffvv.flex_value Y US Report Type 4 40 :p_category_flex_from Char US Category From 5 50 :p_category_flex_to Char US Category To 6 60 :p_as_num_low LOV Oracle JEFI_ASSET_LIST Y select asset_number id, asset_number value, null description from fa_additions where asset_id in (select asset_id from fa_books fb where fb.book_type_code=:$flex$.fa_tax_books) order by value,description US Asset Number From 7 70 :p_as_num_high LOV Oracle JEFI_ASSET_LIST Y select asset_number id, asset_number value, null description from fa_additions where asset_id in (select asset_id from fa_books fb where fb.book_type_code=:$flex$.fa_tax_books) order by value,description US Asset Number To