ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704C51A9E05362FB09050512Y SELECT fndlk.meaning Source , jg.PRL_NO Tax_Class , jg.ACCOUNTING_DATE GL_Date , jg.TRX_TAX_NATURAL_ACCOUNT , jg.ACCOUNT_DESCRIPTION , jg.TAX_RATE_CODE , jg.trx_id ID , jgvrs.tax_calendar_period period_name , DECODE( jg.EXTRACT_SOURCE_LEDGER ,'GL', TO_CHAR(DOC_SEQ_VALUE) , jg.TRX_NUMBER ) Transaction_Number , DECODE (LEAD(tax_rate_code) OVER (PARTITION BY jg.TRX_ID ORDER BY jg.TRX_ID DESC NULLS LAST) ,NULL,'' ,tax_rate_code,'' ,'*') AS SPLIT , DECODE( jg.EXTRACT_SOURCE_LEDGER ,'AR', jg.TAX_LINE_NUMBER ,'GL', jg.TRX_LINE_NUMBER ) Line_Number , jg.TRX_CURRENCY_CODE currency , DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) posted_amount , jg.currency_conversion_rate , DECODE( jg.currency_conversion_rate ,NULL, DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) , DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) * jg.currency_conversion_rate ) AS currency_amount_posted , NVL(jg.TAX_AMT,0) posted_VAT , DECODE( jg.currency_conversion_rate ,NULL, DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) * jg.TAX_RATE / 100 , DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) * jg.currency_conversion_rate *jg.TAX_RATE / 100) AS calculated_VAT , DECODE( jg.currency_conversion_rate ,NULL, ABS(ABS(NVL(jg.TAX_AMT,0) - (DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) * jg.TAX_RATE / 100)) - 0.01) , ABS(ABS(NVL(jg.TAX_AMT,0) - (DECODE( jg.EXTRACT_SOURCE_LEDGER,'GL',NVL(jg.TAXABLE_AMT,0) , NVL(jg.TRX_LINE_AMT,0)) * jg.currency_conversion_rate *jg.TAX_RATE / 100))) - 0.01) AS Difference FROM jg_zz_vat_trx_details jg , jg_zz_vat_rep_status jgvrs , FND_LOOKUPS fndlk , jg_zz_vat_rep_entities jgve WHERE fndlk.LOOKUP_TYPE = 'JEAT_SOURCE' -- Bug 7293559 AND jg.trx_currency_code = :P_Currency AND jg.TRX_TAX_BALANCING_SEGMENT = :P_Balancing_Segment AND fndlk.LOOKUP_CODE = jg.EXTRACT_SOURCE_LEDGER AND jg.ACCOUNTING_DATE >= :start_date AND jg.ACCOUNTING_DATE <= :end_date AND jg.ledger_id =:p_ledger_id AND jg.TAX_REGIME_CODE = jgve.TAX_REGIME_CODE AND ( ( jg.TAX_RATE = NVL(:P_Tax , jg.TAX_RATE) ) OR ( jg.TAX_RATE IS NULL ) ) AND ( ( jg.TAX_STATUS_CODE = NVL(:P_Tax_Status , jg.TAX_STATUS_CODE) ) OR ( jg.TAX_STATUS_CODE IS NULL ) ) AND ( ( jg.TAX_JURISDICTION_CODE = NVL(:P_Tax_Jurisdiction, jg.TAX_JURISDICTION_CODE) ) OR ( jg.TAX_JURISDICTION_CODE IS NULL ) ) AND ( ( jg.TAX_TYPE_CODE = NVL(:P_Tax_Type_Code , jg.TAX_TYPE_CODE) ) OR ( jg.TAX_TYPE_CODE IS NULL ) ) AND ( ( jg.TAX_RATE_CODE = NVL(:P_Tax_Rate_Code , jg.TAX_RATE_CODE) ) OR ( jg.TAX_RATE_CODE IS NULL ) ) AND ( ( jgve.TAX_REGIME_CODE = NVL(:P_Tax_Regime_Code, jgve.TAX_REGIME_CODE) ) OR ( jgve.TAX_REGIME_CODE IS NULL ) ) AND jgvrs.reporting_status_id = jg.reporting_status_id AND jg.accounting_date >= period_start_date AND jg.accounting_date <= period_end_date AND jgvrs.tax_calendar_name = jgve.tax_calendar_name AND ( ( jgvrs.vat_reporting_entity_id = NVL(:P_Reporting_Entity_Identifier, jgvrs.vat_reporting_entity_id) ) OR ( jgvrs.vat_reporting_entity_id IS NULL ) ) AND ( ( APPLICATION_ID IN (222,101) AND jg.accounting_date is not null ) OR ( APPLICATION_ID = 200 AND jg.POSTED_FLAG = 'A' ) ) ORDER BY period_name , tax_rate_code, trx_tax_natural_account JE JEATVATD AR JE تقرير تسوية ضريبة القيمة المضافة في النمسا Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير تسوية ضريبة القيمة المضافة في النمسا Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG D JE Umsatzsteuerverprobung Imported from BI Publisher Application: Europäische Lokalisierungen Source: Österreich: Umsatzsteuerverprobung Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG E JE Austria - Conciliación de IVA Imported from BI Publisher Application: Localizaciones Europeas Source: Austria - Conciliación de IVA Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG F JE Autriche - Etat de rapprochement de la TVA Imported from BI Publisher Application: European Localizations Source: Autriche - Etat de rapprochement de la TVA Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG I JE Austria - rapporto Quadratura IVA Imported from BI Publisher Application: European Localizations Source: Austria - rapporto Quadratura IVA Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG RU JE Отчет о выверке НДС (Израиль) Imported from BI Publisher Application: Версии для Европы Source: Отчет о выверке НДС (Израиль) Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG S JE Österrikisk momsavstämningsrapport Imported from BI Publisher Application: European Localizations Source: Österrikisk momsavstämningsrapport Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG TR JE Austrian VAT Reconciliation Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Austrian VAT Reconciliation Report Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG US JE Austrian VAT Reconciliation Imported from BI Publisher Application: European Localizations Source: Austrian VAT Reconciliation Report Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG BI Publisher :end_date :p_balancing_segment :p_chart_of_accounts_id :p_currency :p_ledger_id :p_legal_entity_id :p_period_from :p_period_to :p_reporting_entity_identifier :p_tax :p_tax_jurisdiction :p_tax_rate_code :p_tax_regime_code :p_tax_registration_number :p_tax_status :p_tax_type_code :pwhereclause :start_date 1 -20 :p_chart_of_accounts_id Number select chart_of_accounts_id from gl_ledgers where ledger_id=:$flex$.ledger AR معرف دليل الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I ID piano dei conti Id piano dei conti RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart Of Accounts Id Chart Of Accounts ID 2 10 :p_ledger_id LOV Oracle JGZZ_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name Y AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro Mayor F Livre Livre I Libro contabile Libro contabile RU Книга Книга S Huvudbok Huvudbok US Ledger Ledger 3 20 :p_currency LOV Oracle JGZZ_SRS_LEDGER_CURRENCIES Y select currency_code id, currency_code value, null description from gl_ledgers_public_v where ledger_id=:$flex$.jgzz_srs_ledger_name order by value,description select currency_code from gl_ledgers where ledger_id=:$flex$.ledger Y AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency 4 30 :p_legal_entity_id LOV Oracle JGZZ_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where ledger_id=:$flex$.jgzz_srs_ledger_name order by value,description Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity 5 40 :p_balancing_segment Char Y AR JGZZ_BALANCING_SEGMENT مقطع الترصيد D JGZZ_BALANCING_SEGMENT Buchungskreis E JGZZ_BALANCING_SEGMENT Segmento de Balance F JGZZ_BALANCING_SEGMENT Segment d'équilibrage I JGZZ_BALANCING_SEGMENT Segmento di quadratura RU JGZZ_BALANCING_SEGMENT Балансирующий сегмент S JGZZ_BALANCING_SEGMENT Balanssegment TR JGZZ_BALANCING_SEGMENT Dengeleme Segmenti US JGZZ_BALANCING_SEGMENT Balancing Segment 6 50 :p_tax_registration_number LOV Oracle JEAT_TAX_REG_NUM Y select tax_registration_number id, tax_registration_number value, null description from jg_zz_vat_rep_entities where legal_entity_id=:$flex$.jgzz_legal_entity order by value,description Y AR رقم تسجيل الضريبة رقم تسجيل الضريبة D USt-IdNr. USt-IdNr. E Número de IVA Número de IVA F Numéro d'identification fiscale Numéro d'identification fiscale I Partita IVA Partita IVA RU Идентификационный номер налогоплательщика Идентификационный номер налогоплательщика S Momsregistreringsnummer Momsregistreringsnummer US Tax Registration Number Tax Registration Number 7 60 :p_reporting_entity_identifier LOV Oracle JEAT_VAT_REPORTING_ENTITY_ID Y select op.vat_reporting_entity_id id, op.entity_identifier value, null description from jg_zz_vat_rep_entities ip,jg_zz_vat_rep_entities op where op.ledger_id=:$flex$.jgzz_srs_ledger_name and op.balancing_segment_value=:$flex$.jgzz_balancing_segment and ip.legal_entity_id=:$flex$.jgzz_legal_entity and ip.tax_registration_number=:$flex$.jeat_tax_reg_num and ip.vat_reporting_entity_id=op.mapping_vat_rep_entity_id order by value,description AR معرف كيان التقارير معرف كيان التقارير D Kennung Steuerpflichtiger Kennung Steuerpflichtiger E Identificador de Entidad Fiscal Identificador de Entidad Fiscal F Identifiant de l'entité de déclaration Identifiant de l'entité de déclaration I Identificativo soggetto fiscale Identificativo soggetto fiscale RU Идентификатор отчетной единицы Идентификатор отчетной единицы S Rapporteringsenhets-id Rapporteringsenhets-id US Reporting Entity Identifier Reporting Entity Identifier 8 70 :p_period_from LOV Oracle JEAT_TAX_CALENDAR_PERIOD_ENTITY Y select rps.tax_calendar_period id, rps.tax_calendar_period value, null description from jg_zz_vat_rep_status rps where rps.vat_reporting_entity_id=:$flex$.jeat_vat_reporting_entity_id and rps.rowid in (select max(rps1.rowid) from jg_zz_vat_rep_status rps1 where rps1.vat_reporting_entity_id=:$flex$.jeat_vat_reporting_entity_id group by rps1.tax_calendar_period) order by value,description Y AR اسم الفترة من اسم الفترة من D Von Periode Von Periode E De Nombre del Período De Nombre del Período F Nom de la période - De Nom de la période - De I Nome periodo - Da Nome periodo - Da RU Имя периода с Имя периода с S Från periodnamn Från periodnamn TR Dönem Adı, İlk Dönem Adı, İlk US Period Name From Period Name From 9 80 :p_period_to LOV Oracle JEAT_TAX_CALENDAR_PERIOD_ENTITY Y select rps.tax_calendar_period id, rps.tax_calendar_period value, null description from jg_zz_vat_rep_status rps where rps.vat_reporting_entity_id=:$flex$.jeat_vat_reporting_entity_id and rps.rowid in (select max(rps1.rowid) from jg_zz_vat_rep_status rps1 where rps1.vat_reporting_entity_id=:$flex$.jeat_vat_reporting_entity_id group by rps1.tax_calendar_period) order by value,description Y AR اسم الفترة إلى اسم الفترة إلى D Bis Periode Bis Periode E A Nombre del Período A Nombre del Período F Nom de la période - A Nom de la période - A I Nome periodo - A Nome periodo - A RU Имя периода по Имя периода по S Till periodnamn Till periodnamn TR Dönem Adı, Son Dönem Adı, Son US Period Name To Period Name To 10 90 :p_tax_regime_code LOV Oracle JEAT_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 ip.vat_reporting_entity_id from jg_zz_vat_rep_entities ip,jg_zz_vat_rep_entities op where op.ledger_id=:$flex$.jgzz_srs_ledger_name and op.balancing_segment_value=:$flex$.jgzz_balancing_segment and ip.legal_entity_id=:$flex$.jgzz_legal_entity and ip.tax_registration_number=:$flex$.jeat_tax_reg_num and ip.vat_reporting_entity_id=op.mapping_vat_rep_entity_id) order by value,description Y AR رمز نظام الضريبة رمز نظام الضريبة D Schlüssel Steuersystem Schlüssel Steuersystem E Código de Régimen Fiscal Código de Régimen Fiscal F Code régime fiscal Code régime fiscal I Codice regime fiscale Codice regime fiscale RU Код налогового режима Код налогового режима S Skatteförvaltningskod Skatteförvaltningskod US Tax Regime Code Tax Regime Code 11 100 :p_tax LOV Oracle JEAT_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$.jeat_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 RU Налог Код налога S Skatt Momskod TR Tax Vergi Kodu US Tax Tax Code 12 110 :p_tax_status LOV Oracle JEAT_TAX_STATUS_CODE Y select tax_status_code id, tax_status_code value, null description from zx_status_b where tax=:$flex$.jeat_tax_code and tax_regime_code=:$flex$.jeat_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 RU Налоговый статус Налоговый статус S Skattestatus Skattestatus US Tax Status Tax Status 13 120 :p_tax_jurisdiction_code LOV Oracle JEAT_TAX_JURISDICTION_CODE Y select tax_jurisdiction_code id, tax_jurisdiction_code value, null description from zx_jurisdictions_b where tax=:$flex$.jeat_tax_code and tax_regime_code=:$flex$.jeat_tax_regime and sysdate between nvl (effective_from,sysdate) and nvl (effective_to,sysdate) order by value,description Y AR رمز جهة الاختصاص الضريبي رمز جهة الاختصاص الضريبي D Steuerzuständigkeitsschlüssel Steuerzuständigkeitsschlüssel E Código de Jurisdicción Fiscal Código de Jurisdicción Fiscal F Code juridiction de taxe Code juridiction de taxe I Codice giurisdizione fiscale Codice giurisdizione fiscale RU Код налоговой юрисдикции Код налоговой юрисдикции S Kod för skatteområde Kod för skatteområde US Tax Jurisdiction Code Tax Jurisdiction Code 14 130 :p_tax_type_code LOV Oracle JEAT_TAX_TYPE Y select zrc.reporting_code_char_value id, zrc.reporting_code_char_value value, zrctl.reporting_code_name description from zx_reporting_types_b zrt,zx_reporting_codes_b zrc,zx_reporting_codes_tl zrctl where zrt.reporting_type_code='EMEA_VAT_REPORTING_TYPE' and zrt.reporting_type_id=zrc.reporting_type_id and zrc.reporting_code_id=zrctl.reporting_code_id and sysdate between nvl(zrc.effective_from,sysdate) and nvl(zrc.effective_to,sysdate) and zrctl.language in userenv('LANG') and nvl(zrt.tax_regime_code,:$flex$.jeat_tax_regime)=:$flex$.jeat_tax_regime order by value,description AR رمز نوع تقرير الضريبة رمز نوع الضريبة D Schlüssel Steuerauswertungsart Steuerartschlüssel E Código de Tipo de Declaración de Impuestos Código de tipo de impuesto F Code type de déclaration fiscale Code type de taxe I Codice tipo di rapporti imposte Codice tipo di imposta RU Код типа налоговой отчетности Код типа налога S Kod för skatterapporteringstyp Skattetypkod TR Vergi Raporlama Tipi Kodu Tax Type Code US Tax Reporting Type Code Tax Type Code 15 140 :p_tax_rate_code LOV Oracle JEAT_TAX_RATE Y select rates.tax_rate_code 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$.jeat_tax_code and rates.tax_regime_code=:$flex$.jeat_tax_regime and status.tax_status_code=:$flex$.jeat_tax_status_code and trunc(sysdate) between nvl (rates.effective_from,sysdate) and nvl (rates.effective_to,sysdate) order by value,description Y AR رمز معدل الضريبة رمز معدل الضريبة D Schlüssel Steuersatz Schlüssel Steuersatz E Código de Tipo Impositivo Código de Tipo Impositivo F Code taux de taxe Code taux de taxe I Codice aliquota Codice aliquota RU Код налоговой ставки Код налоговой ставки S Kod för momssats Kod för momssats US Tax Rate Code Tax Rate Code