ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709451A9E05362FB09050512Y select jzvre.entity_identifier ,map_jzvre.tax_calendar_name ,map_jzvre.tax_regime_code ,map_jzvre.threshold_amount ,map_jzvre.legal_entity_id le_id ,jzvar.allocation_rule_id ,jzvar.source ,nvl2(jzvar.vat_transaction_type, jzvar.vat_transaction_type||' - '||flv.description,jzvar.vat_transaction_type) vat_transaction_type ,jzvar.financial_document_type ,jzvar.tax_rec_sign_flag ,jzvar.tax_non_rec_sign_flag ,jzvar.taxable_rec_sign_flag ,jzvar.taxable_non_rec_sign_flag ,jzvar.tax_code ,jzvar.tax_status ,jzvar.tax_jurisdiction_code ,jzvar.tax_box_recoverable ,jzvar.tax_box_non_recoverable ,jzvar.taxable_box_recoverable ,jzvar.taxable_box_non_recoverable ,jzvar.effective_from_date ,jzvar.effective_to_date ,jzvar.period_type ,jzvar.effective_to_date ,jzvar.period_type ,jzvar.tax_rate_code ,nvl(jzvar.self_assessed_flag,'N') self_assessed_flag ,jzvar.tax_box_self_assess_liability ,jzvar.tax_self_assess_liab_sign_flag from jg_zz_vat_alloc_rules jzvar , jg_zz_vat_rep_entities jzvre , jg_zz_vat_rep_entities map_jzvre , fnd_lookup_values flv where jzvre.vat_reporting_entity_id = :p_vat_reporting_entity_id and ((jzvre.entity_type_code = 'ACCOUNTING' and jzvre.mapping_vat_rep_entity_id = jzvar.vat_reporting_entity_id and jzvre.mapping_vat_rep_entity_id = map_jzvre.vat_reporting_entity_id ) OR (jzvre.entity_type_code = 'LEGAL' and jzvre.vat_reporting_entity_id = jzvar.vat_reporting_entity_id and jzvre.vat_reporting_entity_id = map_jzvre.vat_reporting_entity_id )) and jzvar.vat_transaction_type = flv.lookup_code(+) and flv.lookup_type(+) like 'ZX_JEBE_VAT_TRANS_TYPE' and flv.language(+) = userenv('LANG') and (:P_SOURCE is null or jzvar.source = :P_SOURCE or :P_SOURCE = 'ALL') and (:P_FIN_TRAN_TYPE is null or jzvar.financial_document_type = :P_FIN_TRAN_TYPE) and (:P_VAT_TRAN_TYPE is null or jzvar.vat_transaction_type = :P_VAT_TRAN_TYPE) and (:P_TAX_CODE is null or jzvar.tax_code = :P_TAX_CODE) and (:P_TAX_STATUS is null or jzvar.tax_status = JG_ZZ_JGZZALRL_PKG.get_tax_status_code) and (:P_TAX_JURISDICTION is null or jzvar.tax_jurisdiction_code = :P_TAX_JURISDICTION) and (:P_TAX_RATE_ID is null or jzvar.tax_rate_code = JG_ZZ_JGZZALRL_PKG.get_tax_rate_code) and (:P_TAX_BOX is null or jzvar.tax_box_recoverable = :P_TAX_BOX) and (:P_NON_REC_TAX_BOX is null or jzvar.tax_box_non_recoverable = :P_NON_REC_TAX_BOX) and (:P_TAXABLE_BOX is null or jzvar.taxable_box_recoverable = :P_TAXABLE_BOX) and (:P_NON_REC_TAXABLE_BOX is null or jzvar.taxable_box_non_recoverable = :P_NON_REC_TAXABLE_BOX) order by entity_identifier , vat_transaction_type , source JG JGZZALRL AR JG ضريبة القيمة المضافة لـ EMEA: قائمة قواعد التخصيص Imported from BI Publisher Description: قائمة قواعد التخصيص Application: المحليات الأقليمية Source: ضريبة القيمة المضافة لـ EMEA: قائمة قواعد التخصيص Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG D JG EMEA USt - Umlageregeln Imported from BI Publisher Description: Umlageregeln Application: Regionale Lokalisierungen Source: EMEA USt - Umlageregeln Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG E JG EMEA - IVA: Listado de Reglas de Reparto Imported from BI Publisher Description: Listado de reglas de reparto Application: Localizaciones Regionales Source: EMEA - IVA: Listado de Reglas de Reparto Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG F JG EMEA - TVA : Liste des règles de répartition Imported from BI Publisher Description: Liste des règles de répartition Application: Regional Localizations Source: EMEA - TVA : Liste des règles de répartition Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG I JG IVA EMEA: elenco regole allocazione Imported from BI Publisher Description: Elenco regole allocazione Application: Regional Localizations Source: IVA EMEA: elenco regole allocazione Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG JA JG EMEA VAT: 配賦ルール・リスト Imported from BI Publisher Description: 配賦ルール・リスト Application: Regional Localizations Source: EMEA VAT: 配賦ルール・リスト Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG KO JG EMEA VAT: 배부 규칙 목록 Imported from BI Publisher Description: 배부 규칙 목록 Application: Regional Localizations Source: EMEA VAT: 배부 규칙 목록 Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG PTB JG IVA do EMEA: Lista de Regras de Alocação Imported from BI Publisher Description: Listagem de Regras de Alocação Application: Locais Regionais Source: IVA do EMEA: Lista de Regras de Alocação Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG RU JG НДС (EMEA): список правил размещения Imported from BI Publisher Description: Список правил размещения Application: Местные версии Source: НДС (EMEA): список правил размещения Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG S JG EMEA - moms: Lista över allokeringsregler Imported from BI Publisher Description: Tilldelningsregler - lista Application: Regional Localizations Source: EMEA - moms: Lista över allokeringsregler Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG TR JG EMEA KDV: Paylaştırma Kuralları Listelemesi Imported from BI Publisher Description: Paylaştırma Kuralları Listelemesi Application: Bölgesel Yerelleştirmeler Source: EMEA KDV: Paylaştırma Kuralları Listelemesi Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG US JG EMEA VAT: Allocation Rules Listing Imported from BI Publisher Description: Allocation Rules Listing Application: Regional Localizations Source: EMEA VAT: Allocation Rules Listing Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG ZHS JG EMEA 增值税：分摊规则列表 Imported from BI Publisher Description: 分摊规则列表 Application: 区域性本地化 Source: EMEA 增值税：分摊规则列表 Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG BI Publisher :p_fin_tran_type :p_non_rec_tax_box :p_non_rec_taxable_box :p_source :p_tax_box :p_tax_code :p_tax_jurisdiction :p_tax_rate_id :p_tax_status :p_taxable_box :p_vat_regime :p_vat_reporting_entity_id :p_vat_tran_type 1 -10 :p_vat_regime LOV Oracle JGZZ_TAX_REGIME Y select tax_regime_code id, tax_regime_code value, null description from jg_zz_vat_rep_entities where vat_reporting_entity_id in (select nvl(mapping_vat_rep_entity_id,vat_reporting_entity_id) from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id) order by value,description select TAX_REGIME_CODE FROM JG_ZZ_VAT_REP_ENTITIES WHERE VAT_REPORTING_ENTITY_ID IN (select nvl(mapping_vat_rep_entity_id, vat_reporting_entity_id) from jg_zz_vat_rep_entities where vat_reporting_entity_id = :$flex$.reporting_identifier) AR JGZZ_TAX_REGIME نظام ضريبة القيمة المضافة D JGZZ_TAX_REGIME USt-System E JGZZ_TAX_REGIME Régimen de IVA F JGZZ_TAX_REGIME Régime de TVA I JGZZ_TAX_REGIME Regime IVA JA JGZZ_TAX_REGIME VAT制度 KO JGZZ_TAX_REGIME VAT 제도 PTB JGZZ_TAX_REGIME Regime do IVA RU JGZZ_TAX_REGIME Режим НДС S JGZZ_TAX_REGIME Momssystem TR JGZZ_TAX_REGIME KDV Uygulaması US JGZZ_TAX_REGIME VAT Regime ZHS JGZZ_TAX_REGIME 增值税税制 2 10 :p_vat_reporting_entity_id LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities order by value,description Y AR معرف إعداد التقرير معرف إعداد التقرير D Kennung Steuerpflichtiger Kennung Steuerpflichtiger E Identificador de Informes Identificador de informes F Identifiant de reporting Identifiant de reporting I Identificativo dichiarazione Identificativo dichiarazione JA レポート識別子 レポート識別子 KO 보고 식별자 보고 식별자 PTB Identificador de Relatório Identificador de Relatório RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcı Raporlama Tanımlayıcı US Reporting Identifier Reporting Identifier ZHS 申报标识 申报标识 3 20 :p_source LOV Oracle JGZZ_VAT_SOURCES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_SOURCE' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR المصدر المصدر D Herkunft Herkunft E Origen Origen F Origine Origine I Origine Origine JA ソース ソース KO 출처 출처 PTB Origem Origem RU Источник Источник S Källa Källa TR Kaynak Kaynak US Source Source ZHS 来源 来源 4 30 :p_fin_tran_type LOV Oracle JGZZ_FIN_TRAN_TYPE Y select rules.financial_document_type id, lkup.meaning value, null description from jg_zz_vat_alloc_rules rules,fnd_lookup_values lkup where rules.vat_reporting_entity_id in (select nvl(mapping_vat_rep_entity_id,vat_reporting_entity_id) from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id) and rules.financial_document_type=lkup.lookup_code and ( (:$flex$.jgzz_vat_sources='AP' and lookup_type='JGZZ_AP_OF_TRANS_TYPE') or (:$flex$.jgzz_vat_sources='AR' and lookup_type='JGZZ_AR_OF_TRANS_TYPE') or (:$flex$.jgzz_vat_sources='GL' and lookup_type='JGZZ_GL_OF_TRANS_TYPE') or (:$flex$.jgzz_vat_sources='ALL' and lookup_type in ('JGZZ_AP_OF_TRANS_TYPE' ,'JGZZ_AR_OF_TRANS_TYPE' ,'JGZZ_GL_OF_TRANS_TYPE'))) and rules.rowid=(select min(rowid) from jg_zz_vat_alloc_rules rules1 where rules1.vat_reporting_entity_id= rules.vat_reporting_entity_id and rules1.financial_document_type= rules.financial_document_type) and lkup.language=userenv('LANG') order by value,description AR نوع الحركة المالية نوع الحركة المالية D Finanztransaktionsart Finanztransaktionsart E Tipo de Transacción Financiera Tipo de transacción financiera F Type de mouvement financier Type de mouvement financier I Tipo di transazione finanziaria Tipo di transazione finanziaria JA 財務取引タイプ 財務取引タイプ KO 재무 거래 유형 재무 거래 유형 PTB Tipo de Transação Financeira Tipo de Transação Financeira RU Тип финансовой транзакции Тип финансовой транзакции S Typ av ekonomisk transaktion Typ av ekonomisk transaktion TR Finansal İşlem Tipi Finansal İşlem Tipi US Financial Transaction Type Financial Transaction Type ZHS 财务事务处理类型 财务事务处理类型 5 40 :p_vat_tran_type LOV Oracle JGZZ_VAT_TRANS_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='ZX_JEBE_VAT_TRANS_TYPE' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR نوع حركة ضريبة القيمة المضافة نوع حركة ضريبة القيمة المضافة D USt-Transaktionsart USt-Transaktionsart E Tipo de Transacción de IVA Tipo de Transacción de IVA F Type de mouvement de TVA Type de mouvement de TVA I Tipo di transazione IVA Tipo di transazione IVA JA VAT取引タイプ VAT取引タイプ KO VAT 트랜잭션 유형 VAT 트랜잭션 유형 PTB Tipo de Transação IVA Tipo de Transação IVA RU Тип транзакции НДС Тип транзакции НДС S Momstransaktionstyp Momstransaktionstyp TR KDV İşlem Tipi KDV İşlem Tipi US VAT Transaction Type VAT Transaction Type ZHS 增值税事务处理类型 增值税事务处理类型 6 50 :p_tax_code LOV Oracle JGZZ_TAX_CODE Y select zxt.tax id, zxt.tax value, null description from zx_taxes_b zxt where zxt.rowid in (select max(zxt1.rowid) from zx_taxes_b zxt1,jg_zz_vat_rep_entities jgre1 where jgre1.tax_regime_code=zxt1.tax_regime_code and jgre1.vat_reporting_entity_id in (select nvl(mapping_vat_rep_entity_id,vat_reporting_entity_id) from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id) and sysdate between nvl (effective_from,sysdate) and nvl (effective_to,sysdate) group by zxt1.tax ) order by value,description AR الضريبة رمز الضريبة D Steuer Steuerschlüssel E Impuesto Código de Impuesto F Taxe Code taxe I Imposta Codice imposta JA 税金 税金コード KO 세금 세금 코드 PTB Imposto Cód. Imposto RU Налог Код налога S Skatt Momskod TR Vergi Vergi Kodu US Tax Tax Code ZHS 税 税码 7 60 :p_tax_status LOV Oracle JGZZ_TAX_STATUS_CODE Y select tax_status_id id, tax_status_code value, null description from zx_status_b where tax=:$flex$.jgzz_tax_code and tax_regime_code=:$flex$.jgzz_tax_regime and sysdate between nvl (effective_from,sysdate) and nvl (effective_to,sysdate) order by value,description AR موقف الضريبة موقف الضريبة D Steuerstatus Steuerstatus E Estado Fiscal Estado fiscal F Statut fiscal Statut fiscal I Stato imposta Stato imposta JA 税金ステータス 税金ステータス KO 과세 상태 과세 상태 PTB Status do Imposto Status do Imposto RU Налоговый статус Налоговый статус S Skattestatus Skattestatus TR Vergi Statüsü Vergi Statüsü US Tax Status Tax Status ZHS 纳税状态 纳税状态 8 70 :p_tax_jurisdiction LOV Oracle JGZZ_TAX_JURISDICTION_CODE Y select tax_jurisdiction_code id, tax_jurisdiction_code value, null description from zx_jurisdictions_b where tax=:$flex$.jgzz_tax_code and tax_regime_code=:$flex$.jgzz_tax_regime and sysdate between nvl (effective_from,sysdate) and nvl (effective_to,sysdate) order by value,description AR جهة الاختصاص الضريبي جهة الاختصاص الضريبي D Steuerzuständigkeit Steuerzuständigkeit E Jurisdicción Fiscal Jurisdicción fiscal F Juridiction de taxe Juridiction de taxe I Giurisdizione imposta Giurisdizione imposta JA 税管轄区域 税管轄区域 KO 세금 관할 법원 세금 관할 법원 PTB Jurisdição do Imposto Jurisdição do Imposto RU Налоговая юрисдикция Налоговая юрисдикция S Skatteområde Skatteområde TR Vergi Yasası Vergi Yasası US Tax Jurisdiction Tax Jurisdiction ZHS 税务管辖区 税务管辖区 9 80 :p_tax_rate_id LOV Oracle JGZZ_TAX_RATE Y select rates.tax_rate_id id, rates.tax_rate_code value, null description from zx_rates_b rates,zx_status_b status where rates.tax_status_code=status.tax_status_code and rates.content_owner_id=status.content_owner_id and rates.tax=status.tax and rates.tax_regime_code=status.tax_regime_code and rates.tax=:$flex$.jgzz_tax_code and rates.tax_regime_code=:$flex$.jgzz_tax_regime and status.tax_status_id=:$flex$.jgzz_tax_status_code and trunc(sysdate) between nvl (rates.effective_from,sysdate) and nvl (rates.effective_to,sysdate) order by value,description AR رمز معدل الضريبة معدل الضريبة D Schlüssel Steuersatz Steuersatz E Código de Tipo Impositivo Tipo impositivo F Code taux de taxe Taux de taxe I Codice aliquota Aliquota JA 税率コード 税率 KO 세율 코드 세율 PTB Código da Alíquota de Imposto Alíquota de Imposto RU Код налоговой ставки Ставка S Kod för momssats Skattesats TR Vergi Oran Kodu Vergi Oranı US Tax Rate Code Tax Rate ZHS 税率代码 税率 10 90 :p_tax_box LOV Oracle JGZZ_VAT_REPORT_BOXES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_VAT_REPORT_BOXES' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR مربع الضريبة القابلة للاستعادة مربع الضريبة القابلة للاستعادة D Abzugsfähige Steuer Abzugsfähige Steuer E Buzón Fiscal Recuperable Buzón fiscal recuperable F Case Taxe récupérable Case Taxe récupérable I Casella imposta recuperabile Casella dell'imposta recuperabile JA 還付税金ボックス 還付税金ボックス KO 공제 세금 상자 공제 세금 상자 PTB Caixa de Imposto Recuperável Caixa de Imposto Recuperável RU Поле возвращаемого налога Поле возвращаемого налога S Ruta för återbetalningsbar moms Ruta för återbetalningsbar moms TR Geri Alınabilir Vergi Kutusu Geri Alınabilir Vergi Kutusu US Recoverable Tax Box Recoverable Tax Box ZHS 可退回税目 可退回税目 11 100 :p_non_rec_tax_box LOV Oracle JGZZ_VAT_REPORT_BOXES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_VAT_REPORT_BOXES' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR مربع الضريبة غير القابلة للاستعادة مربع الضريبة غير القابلة للاستعادة D Nicht abzugsfähige Steuer Nicht abzugsfähige Steuer E Buzón Fiscal No Recuperable Buzón fiscal no recuperable F Case Taxe non récupérable Case Taxe non récupérable I Casella imposta non recuperabile Casella dell'imposta non recuperabile JA 非還付税金ボックス 非還付税金ボックス KO 불공제 매입세액 입력란 불공제 매입세액 입력란 PTB Caixa de Imposto Não Recuperável Caixa de Imposto Não Recuperável RU Поле невозмещаемого налога Поле невозмещаемого налога S Ej återbetalningsbar moms, ruta Ej återbetalningsbar moms, ruta TR Geri Alınamayan Vergi Kutusu Geri Alınamayan Vergi Kutusu US Non Recoverable Tax Box Non Recoverable Tax Box ZHS 不可退回税目 不可退回税目 12 110 :p_taxable_box LOV Oracle JGZZ_VAT_REPORT_BOXES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_VAT_REPORT_BOXES' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR مربع الخاضع للضريبة القابلة للاستعادة مربع الخاضع للضريبة القابلة للاستعادة D Abzugsfähig, steuerpflichtig Abzugsfähig, steuerpflichtig E Buzón Fiscal Recuperable 2 Buzón fiscal recuperable F Case Montant soumis à taxe récupérable Case Montant soumis à taxe récupérable I Casella imponibile recuperabile Casella dell'imponibile recuperabile JA 還付課税ボックス 還付課税ボックス KO 공제 매입세액 과세가능 입력란 공제 매입세액 과세가능 입력란 PTB Caixa Tributável Recuperável Caixa Tributável Recuperável RU Поле возмещаемого налогообложения Поле возмещаемого налогообложения S Ruta för återbetalningsbart skattepliktigt Ruta för återbetalningsbart skattepliktigt TR Geri Alınabilir Vergiye Tabi Kutu Geri Alınabilir Vergiye Tabi Kutu US Recoverable Taxable Box Recoverable Taxable Box ZHS 可退回应纳税目 可退回应纳税目