ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1953869E053B46B63588994Y select DTI.STATE STATE, DTI.ASSET_NUMBER, DTI.ASSET_DESCRIPTION, DTI.TAX_ASSET_TYPE TAX_ASSET_TYPE, DTI.ASSET_ID ASSET_ID, DTI.END_UNITS_ASSIGNED, DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED ADD_UNITS_ASSIGNED, DTI.END_COST, DTI.INCREASE_COST, decode(:p_decision_cost,'AUTO',DTI.EVALUATED_NBV, DTI.THEORETICAL_NBV) ASSET_NBV, DTI.ERA_NAME_NUM, DTI.ADD_ERA_YEAR, DTI.ADD_MONTH, DTI.END_LIFE, DTI.THEORETICAL_RESIDUAL_RATE ASSET_RESIDUAL_RATE, DTI.EXCEPTION_CODE, DTI.EXCEPTION_RATE, DTI.THEORETICAL_TAXABLE_COST ASSET_TAXABLE_COST, DTI.ALL_REASON_CODE, DTI.ALL_DESCRIPTION, DTI.ADDDEC_REASON_CODE, DTI.ADDDEC_DESCRIPTION from FA_DEPRN_TAX_REP_ITF DTI where &H_WHERE and REQUEST_ID = :p_request_id and BOOK_TYPE_CODE = :p_book and STATE = nvl(:p_state,state) and YEAR = :p_year and ((:check_amount >= 0 and nvl(:p_decision_cost,'N') <>'EVALUATED') or (:check_amount < 0 and nvl(:p_decision_cost,'N') = 'THEORETICAL')) UNION select DTI.STATE STATE, DTI.ASSET_NUMBER, DTI.ASSET_DESCRIPTION, DTI.TAX_ASSET_TYPE TAX_ASSET_TYPE, DTI.ASSET_ID ASSET_ID, DTI.END_UNITS_ASSIGNED, DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED ADD_UNITS_ASSIGNED, DTI.END_COST, DTI.INCREASE_COST, DTI.EVALUATED_NBV ASSET_NBV, DTI.ERA_NAME_NUM, DTI.ADD_ERA_YEAR, DTI.ADD_MONTH, DTI.END_LIFE, DTI.EVALUATED_RESIDUAL_RATE ASSET_RESIDUAL_RATE, DTI.EXCEPTION_CODE, DTI.EXCEPTION_RATE, DTI.EVALUATED_TAXABLE_COST ASSET_TAXABLE_COST, DTI.ALL_REASON_CODE, DTI.ALL_DESCRIPTION, DTI.ADDDEC_REASON_CODE, DTI.ADDDEC_DESCRIPTION from FA_DEPRN_TAX_REP_ITF DTI where &H_WHERE and REQUEST_ID= :p_request_id and BOOK_TYPE_CODE = :p_book and STATE = nvl(:p_state,state) and YEAR = :p_year and ((:check_amount < 0 and nvl(:p_decision_cost,'N') <>'THEORETICAL') or (:check_amount >= 0 and nvl(:p_decision_cost,'N') = 'EVALUATED')) and DTI.STATE=:sum_state order by STATE,TAX_ASSET_TYPE, ASSET_ID OFA FADSTR AR FA سجل ضرائب إجمالي الإهلاك (روسيا) Application: الأصول Source: سجل ضرائب إجمالي الإهلاك (روسيا) Short Name: FADSTR DB package: FADTXA D FA Steuerregister Abschreibungsübersicht (Russland) Application: Anlagen Source: Steuerregister Abschreibungsübersicht (Russland) Short Name: FADSTR DB package: FADTXA F FA Registre fiscal de synthèse des amortissements (Russie) Application: Assets Source: Registre fiscal de synthèse des amortissements (Russie) Short Name: FADSTR DB package: FADTXA US FA Depreciation Summary Tax Register (Russia) Application: Assets Source: Depreciation Summary Tax Register (Russia) Short Name: FADSTR DB package: FADTXA ZHS FA 折旧汇总税登记表（俄罗斯） Application: 资产 Source: 折旧汇总税登记表（俄罗斯） Short Name: FADSTR DB package: FADTXA BI Publisher &h_where :check_amount :p_book :p_decision_cost :p_request_id :p_state :p_year :sum_state 1 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y AR اسم الدفتر D AfA-Buch F Nom du livre d'amortissement US Book Name ZHS 帐簿名称 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter Y AR اسم الفترة D Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称