ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D051A9E05362FB09050512Y select ta.CODE ,ta.NAME NAME ,ta.TAX_REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.SHORT_YEAR_DEPRN_FLAG) SHORT_YEAR_DEPRN_FLAG ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.BONUS_DEPRN_FLAG) BONUS_DEPRN_FLAG ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.NON_TAXABLE_ASSETS_FLAG) NON_TAXABLE_ASSETS_FLAG ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.TAX_STANDARD_EXCEPTION_FLAG) TAX_STANDARD_EXCEPTION_FLAG ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.SPECIAL_DEPRN_FLAG) SPECIAL_DEPRN_FLAG ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fnd_meaning('YES_NO',ta.DEPRN_METHOD_UNDER_TAX_LAW) DEPRN_METHOD_UNDER_TAX_LAW ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_METHOD_TYPE',decode(nvl(ta.DEPRN_METHOD_UNDER_TAX_LAW,'A'),'A','AMOUNT','R','RATE','AMOUNT')) DEPRN_METHOD_UNDER_TAX_LAW_D ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.BLUE_RETURN_FLAG) BLUE_RETURN_FLAG ,ta.ASSET_ADDRESS1 ASSET_ADDRESS1 ,ta.ASSET_ADDRESS2 ASSET_ADDRESS2 ,ta.ASSET_ADDRESS3 ASSET_ADDRESS3 ,ta.PRINCIPAL_LOCATION_NUMBER PRINCIPAL_LOCATION_NUMBER ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.LEASED_ASSETS_FLAG) LEASED_ASSETS_FLAG ,ta.LESSOR_NAME LESSOR_NAME ,ta.LESSOR_ADDRESS LESSOR_ADDRESS ,ta.LESSOR_PHONE LESSOR_PHONE ,ta.LOCATION_OWNERSHIP LOCATION_OWNERSHIP ,ta.OWNED_LOCATION_NUMBERS OWNED_LOCATION_NUMBERS ,ta.LEASED_LOCATION_NUMBERS LEASED_LOCATION_NUMBERS ,ta.REFERENCE_LINE1 REFERENCE_LINE1 ,ta.REFERENCE_LINE2 REFERENCE_LINE2 ,ta.REFERENCE_LINE3 REFERENCE_LINE3 ,ta.REFERENCE_LINE4 REFERENCE_LINE4 ,ta.REFERENCE_LINE5 REFERENCE_LINE5 ,ta.REFERENCE_LINE6 REFERENCE_LINE6 ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.d_decisionformula(ta.CODE) DECISION from FA_DEPRN_TAX_AUTHORITIES ta where ta.code=nvl(:P_STATE,ta.code) and ta.company_id = (select company_id from fa_deprn_tax_entities where book_type_code = :P_BOOK) and exists (select 1 from FA_DEPRN_TAX_REP_ITF itf where itf.request_id = :p_request_id and itf.book_type_code = :p_book and itf.year = :p_year and itf.state = ta.code) ORDER BY ta.CODE OFA FADTXS AR FA تقرير إجمالي ضريبة الأصول القابلة للإهلاك اليابانية Imported from BI Publisher Application: الأصول Source: تقرير إجمالي ضريبة الأصول القابلة للإهلاك اليابانية Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG D FA Japan - Steuern auf abschreibungsfähige Anlagen - Übersicht Imported from BI Publisher Application: Anlagen Source: Japan - Steuern auf abschreibungsfähige Anlagen - Übersicht Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG E FA Japón - Informe Resumen de Impuestos de Activos Amortizables Imported from BI Publisher Description: Japón - Informe Resumen de impuestos de activos amortizables Application: Assets Source: Japón - Informe Resumen de Impuestos de Activos Amortizables Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG F FA Etat de synthèse des taxes sur immobilisations amortissables (Japon) Imported from BI Publisher Application: Assets Source: Etat de synthèse des taxes sur immobilisations amortissables (Japon) Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG I FA Rapporto Sintetico imposte cespiti ammortizzabili (Giappone) Imported from BI Publisher Application: Assets Source: Rapporto Sintetico imposte cespiti ammortizzabili (Giappone) Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG JA FA 償却資産申告書 (償却資産課税台帳) Imported from BI Publisher Application: Assets Source: 償却資産申告書 (償却資産課税台帳) Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG KO FA 일본 감가상각 자산 세금 요약 보고서 Imported from BI Publisher Application: Assets Source: 일본 감가상각 자산 세금 요약 보고서 Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG PTB FA Relatório Sumariado de Impostos de Ativos Depreciáveis - Japão Imported from BI Publisher Application: Assets Source: Relatório Sumariado de Impostos de Ativos Depreciáveis - Japão Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG RU FA Сводный налоговый отчет по амортизируемым активам (Япония) Imported from BI Publisher Application: Активы Source: Сводный налоговый отчет по амортизируемым активам (Япония) Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG S FA Japansk Avskrivningsbara anläggningar - momsöversiktsrapport Imported from BI Publisher Application: Assets Source: Japansk Avskrivningsbara anläggningar - momsöversiktsrapport Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG TR FA Japonya Amortismana Esas Varlık Vergi Özet Raporu Imported from BI Publisher Application: Duran Varlıklar Source: Japonya Amortismana Esas Varlık Vergi Özet Raporu Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG US FA Japanese Depreciable Assets Tax Summary Imported from BI Publisher Application: Assets Source: Japanese Depreciable Assets Tax Summary Report Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG ZHS FA 日本应折旧资产税汇总报表 Imported from BI Publisher Application: 资产 Source: 日本应折旧资产税汇总报表 Short Name: FADTXS DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG BI Publisher :currency_code :h_decision :h_imperial_code :h_imperial_year :h_loc_flex_struct :h_state_desc :h_today_imperial_code :h_today_imperial_year :p_book :p_category_structure_id :p_conc_request_id :p_end_tax_asset_type :p_minor_category_exists_check :p_request_id :p_start_tax_asset_type :p_state :p_tax_asset_type_segment :p_year 1 -10 :p_not_used_in_report Number SELECT LOCATION_FLEX_STRUCTURE FROM FA_SYSTEM_CONTROLS Y AR معرف هيكل الموقع معرف هيكل الموقع D Kennung Standortstruktur Kennung Standortstruktur E Id Estructura de Ubicación Id Estructura de Ubicación F ID structure de lieu ID structure de lieu I ID struttura ubicazione ID struttura ubicazione JA 事業所体系ID 事業所体系ID KO 위치 구조 ID 위치 구조 ID PTB ID da Estrutura do Local ID da Estrutura do Local RU Идентификатор структуры расположения Идентификатор структуры расположения S Platsstrukturs-id Platsstrukturs-id TR Yerleşim Yapısı No Yerleşim Yapısı No US Location Structure ID Location Structure ID ZHS 地点结构标识 地点结构标识 2 10 :p_request_id Number Y AR معرف الطلب معرف طلب التزامن D Prozess-Nr. Hintergrundprozess-Nr. E Id Solicitud Id Solicitud Simultánea F Numéro de traitement Numéro du traitement simultané I Id richiesta Id richiesta concorrente JA 要求ID コンカレント要求ID KO 요청 ID 동시작업 요청 ID PTB ID da Solicitação ID da Solicitação Concorrente RU Идент. запроса Идент. параллельного запроса S Jobb-id Begäran-id TR Talep No Eşzamanlı Talep No US Request ID Concurrent Request ID ZHS 请求编号 并发请求编号 3 20 :p_book LOV Oracle FA_NOBUD_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class!='BUDGET' order by book_type_code Y AR الدفتر رمز نوع دفتر الحسابات D AfA-Buch Art AfA-Buch E Libro Código de Tipo de Libro F Livre Code type de livre I Registro Codice tipo di registro JA 台帳 台帳タイプ・コード KO 장부 장부 유형 코드 PTB Livro Código do Tipo de Livro RU Книга Код типа книги S Bok Boktypskod TR Defter Defter Tipi Kodu US Book Book Type Code ZHS 帐簿 账簿类型代码 4 30 :p_year Number Y AR السنة السنة الهدف D Jahr Zieljahr E Año Año de Finalización F Année Année cible I Anno Anno obiettivo JA 年 対象年 KO 연도 대상 연도 PTB Ano Ano de Destino RU Год Намеченный год S År Målår TR Yıl Hedef Yıl US Year Target Year ZHS 年 目标年度 5 40 :p_state Char AR الولاية ولاية الموقع D Bundesland Bundesland Standort E Provincia Provincia de Ubicación F Département Lieu : département I Stato Stato ubicazione JA 市区町村区分 事業所 - 市区町村区分 KO 도 위치 상태 PTB Estado Estado do Local RU Республика Республика расположения S Delstat Platsstatus TR Eyalet Yerleşim Eyaleti US State Location State ZHS 省（州） 地点 - 省（州）