ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705E51A9E05362FB09050512 SELECT jg_info_v1 SEQ_NAME ,TO_CHAR(jg_info_d2,'DD-Mon-RRRR') ACCOUNTING_DATE ,jg_info_n2 DOC_SEQUENCE_VALUE /* jg_info_v25. Bug#8278481*/ ,jg_info_v7 INVOICE_NUM ,TO_CHAR(jg_info_d1,'DD-Mon-RRRR') INVOICE_DATE ,jg_info_v2 VENDOR_NAME ,jg_info_v8 INVOICE_CURRENCY_CODE ,jg_info_v20 FUNC_CURRENCY_CODE ,jg_info_v3 VAT_NUM ,jg_info_v4 VAT_NAME ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,jg_info_n20,jg_info_n13), 2)) TAXABLE_REC_AMT ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,jg_info_n21,jg_info_n14), 2)) TAXABLE_NREC_AMT ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,decode(jg_info_v29,'Y',nvl(jg_info_n22,0)+nvl(jg_info_n23,0),jg_info_n22), decode(jg_info_v29,'Y',nvl(jg_info_n15,0)+nvl(jg_info_n16,0),jg_info_n15)) , 2)) TAX_REC_AMT ,SUM(ROUND(decode(jg_info_v29,'Y',0,decode(jg_info_v20, jg_info_v8,jg_info_n23,jg_info_n16)), 2)) TAX_NREC_AMT /* Bug 16395602 ,SUM(ROUND(DECODE(jg_info_v21,'', DECODE(jg_info_v20, jg_info_v8, DECODE(nvl(jg_info_v9,'N'),'N',jg_info_n3,0), DECODE(nvl(jg_info_v9,'N'),'N',jg_info_n4,0)), NVL(jg_info_n7,0) + DECODE(nvl(jg_info_v9,'N'),'N',nvl(jg_info_n4,0),0)) + decode(jg_info_v20, jg_info_v8, jg_info_n5, jg_info_n6), 2)) TOTAL_AMT */ ,SUM(ROUND(DECODE(jg_info_v20, jg_info_v8, nvl(jg_info_n20,0)+nvl(jg_info_n21,0),nvl(jg_info_n13,0)+nvl(jg_info_n14,0)) + decode(jg_info_v20, jg_info_v8, nvl(jg_info_n22,0)+nvl(jg_info_n23,0), nvl(jg_info_n15,0)+nvl(jg_info_n16,0)), 2)) TOTAL_AMT --Bug 16395602 ,SUM(decode(jg_info_v20, jg_info_v8, 0, decode(jg_info_v39,'N',decode(jg_info_v21,'OFFSET', NVL(jg_info_n20,0) + NVL(jg_info_n21,0), NVL(jg_info_n22,0) + NVL(jg_info_n23,0) + NVL(jg_info_n20,0) + NVL(jg_info_n21,0)), NVL(jg_info_n20,0) + NVL(jg_info_n21,0)))) FOREIGN_AMT ,TO_CHAR(jg_info_d2,'DD-Mon-RRRR') C_ACCOUNTING_DATE ,TO_CHAR(jg_info_d1,'DD-Mon-RRRR') C_INVOICE_DATE FROM jg_zz_vat_trx_gt WHERE :P_REPORT_NAME = 'JEITAPSR' AND jg_info_v30 = 'JEITAPSR' GROUP BY jg_info_v1 /* SEQ_NAME */ ,jg_info_d2 /* ACCOUNTING_DATE */ ,jg_info_n2 /* DOC_SEQUENCE_VALUE */ /* jg_info_v25 Bug#8278481 */ ,jg_info_v7 /* INVOICE_NUM */ ,jg_info_d1 /* INVOICE_DATE */ ,jg_info_v2 /* VENDOR_NAME */ ,jg_info_v3 /* VAT_NUM */ ,jg_info_v4 /* VAT_NAME */ ,jg_info_v8 /* INVOICE_CURRENCY_CODE */ ,jg_info_v20 /* FUNC_CURRENCY_CODE */ ORDER BY jg_info_v1 /* SEQ_NAME */ ,jg_info_n2 /* DOC_SEQUENCE_VALUE */ /* jg_info_v25 Bug#8278481 */ ,jg_info_d2 /* ACCOUNTING_DATE */ ,jg_info_v7 /* INVOICE_NUM */ ,jg_info_d1 /* INVOICE_DATE */ ,jg_info_v2 /* VENDOR_NAME */ ,jg_info_v4 /* VAT_NAME */ ,jg_info_v8 /* INVOICE_CURRENCY_CODE */ Y JE JEESRVAR_XMLP AR JE تقرير يومية الفواتير الأسبانية داخل الاتحاد الأوروبي Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير يومية الفواتير الأسبانية داخل الاتحاد الأوروبي Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg D JE Innergemeinschaftliche Rechnungen - Journal Imported from BI Publisher Application: Europäische Lokalisierungen Source: Spanien: Innergemeinschaftliche Rechnungen - Journal Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg E JE España - Informe Asientos de Facturas Intracomunitarias Imported from BI Publisher Application: Localizaciones Europeas Source: España - Informe Asientos de Facturas Intracomunitarias Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg F JE Espagne - Etat des pièces de factures inter-UE Imported from BI Publisher Application: European Localizations Source: Espagne - Etat des pièces de factures inter-UE Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg I JE Spagna - rapporto Scritture contabili fatture intereuropee Imported from BI Publisher Application: European Localizations Source: Spagna - rapporto Scritture contabili fatture intereuropee Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg RU JE Отчет по журналу счетов-фактур внутри ЕС (Испания) Imported from BI Publisher Application: Версии для Европы Source: Отчет по журналу счетов-фактур внутри ЕС (Испания) Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg S JE Spanska fakturor inom EU - verifikationsrapport Imported from BI Publisher Application: European Localizations Source: Spanska fakturor inom EU - verifikationsrapport Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg TR JE İspanya AB Ülkeleri Arası Faturalar Fiş Raporu Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: İspanya AB Ülkeleri Arası Faturalar Fiş Raporu Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg US JE Spanish Inter-EU Invoices Journal Imported from BI Publisher Application: European Localizations Source: Spanish Inter-EU Invoices Journal Report Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg BI Publisher :g_precision :l_err_msg :l_rec_count :p_balancing_segment :p_debug_flag :p_detail_summary :p_document_sequence_name_from :p_document_sequence_name_to :p_first_page_num :p_period :p_period_to :p_register_type :p_report_name :p_start_inv_sequence :p_tax_type :p_vat_register_id :p_vat_rep_entity_id :p_vendor_name_from :p_vendor_name_to 1 -20 :p_chart_of_account_id LOV Oracle JG_ZZ_VAT_CHART_OF_ACCT_ID Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id in (select ledger_id from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and entity_level_code in ('LEDGER','BSV') union select ledger_id from gl_ledger_le_v where legal_entity_id=(select legal_entity_id from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and entity_level_code='LE') and ledger_category_code='PRIMARY') order by value,description select chart_of_accounts_id from gl_ledgers where ledger_id in(select ledger_id from jg_zz_vat_rep_entities where vat_reporting_entity_id= :$flex$.reporting_identifier and entity_level_code in ('LEDGER','BSV') Union select ledger_id from gl_ledger_le_v where legal_entity_id = (select legal_entity_id from jg_zz_vat_rep_entities where vat_reporting_entity_id =:$flex$.reporting_identifier and entity_level_code='LE') and ledger_category_code='PRIMARY' ) Y AR P_CHART_OF_ACCOUNT_ID معرف دليل الحسابات D P_CHART_OF_ACCOUNT_ID Kontenplankennung E P_CHART_OF_ACCOUNT_ID Id Plan de Cuentas F P_CHART_OF_ACCOUNT_ID ID plan de comptes I P_CHART_OF_ACCOUNT_ID Id piano dei conti RU P_CHART_OF_ACCOUNT_ID Идент. плана счетов S P_CHART_OF_ACCOUNT_ID Kontoplans-id US P_CHART_OF_ACCOUNT_ID Chart of Account Id 2 -10 :p_report_name Char JEESRVAR AR طلب التقرير طلب التقرير D Aufrufende Auswertung Aufrufende Auswertung E Informe Que Solicita los Datos Informe Que Solicita los Datos F Etat appelant Etat appelant I Rapporto chiamante Rapporto chiamante RU Отчет вызова Отчет вызова S Anropar rapport Anropar rapport US Calling Report Calling Report 3 10 :p_vat_rep_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 Entidad Fiscal Identificador de Entidad Fiscal F Identifiant d'entité déclarante Identifiant d'entité déclarante I Identificativo soggetto fiscale Identificativo soggetto fiscale RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcısı Raporlama Tanımlayıcısı US Reporting Identifier Reporting Identifier 4 20 :p_period LOV Oracle JGZZ_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$.jgzz_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$.jgzz_vat_reporting_entity_id group by rps1.tax_calendar_period) order by period_start_date Y AR فترة تقويم الضريبة من فترة تقويم الضريبة من D Von Steuerkalenderperiode Von Steuerkalenderperiode E De Período de Calendario Fiscal De Período de Calendario Fiscal F Période du calendrier fiscal - De Période du calendrier fiscal - De I Periodo calendario fiscale -Da Periodo calendario fiscale -Da RU Налоговый календарный период с Налоговый календарный период с S Från skattekalenderperiod Från skattekalenderperiod TR Vergi Takvimi Başlangıç Dönemi Vergi Takvimi Başlangıç Dönemi US Tax Calendar Period From Tax Calendar Period From 5 30 :p_period_to LOV Oracle JGZZ_TAX_CALENDAR_PERIOD_TO 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$.jgzz_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$.jgzz_vat_reporting_entity_id and trunc(rps1.period_start_date)>=(select trunc(min(period_start_date)) from jg_zz_vat_rep_status rps2 where rps2.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and rps2.tax_calendar_period=:$flex$.jgzz_tax_calendar_period_entity) group by rps1.tax_calendar_period) order by period_start_date select :$flex$.tax_calendar_period_from from dual Y AR فترة تقويم الضريبة إلى فترة تقويم الضريبة إلى D Bis Steuerkalenderperiode Bis Steuerkalenderperiode E A Período de Calendario Fiscal A Período de Calendario Fiscal F Période du calendrier fiscal - A Période du calendrier fiscal - A I Periodo calendario fiscale - A Periodo calendario fiscale - A RU Налоговый календарный период по Налоговый календарный период по S Till skattekalenderperiod Till skattekalenderperiod TR Vergi Takvimi Son Dönemi Vergi Takvimi Son Dönemi US Tax Calendar Period To Tax Calendar Period To 6 40 :p_tax_type LOV Oracle JGZZ_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,jg_zz_vat_rep_entities rps 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 rps.vat_reporting_entity_id=(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 nvl(zrt.tax_regime_code,rps.tax_regime_code)=rps.tax_regime_code order by value,description AR رمز نوع تقرير الضريبة نوع الضريبة D Schlüssel Steuerauswertungsart Steuerart E Código de Tipo de Declaración de Impuestos Tipo de Impuesto F Code type de déclaration fiscale Type de taxe I Codice tipo di rapporti imposte Tipo di imposta RU Код типа налоговой отчетности Тип налога S Kod för skatterapporteringstyp Skattetyp TR Vergi Raporlama Tipi Kodu Vergi Tipi US Tax Reporting Type Code Tax Type 7 50 :p_balancing_segment Char AR مقطع الترصيد مقطع الترصيد D Buchungskreis Buchungskreis E Segmento de Balance Segmento de Balance F Segment d'équilibrage Segment d'équilibrage I Segmento di quadratura Segmento di quadratura RU Балансирующий сегмент Балансирующий сегмент S Balanssegment Balanssegment TR Dengeleme Segmenti Dengeleme Segmenti US Balancing Segment Balancing Segment 8 60 :p_start_inv_sequence Number 1 AR بدء مسلسل الفاتورة بدء مسلسل الفاتورة D Von Rechnungsnummer Von Rechnungsnummer E Iniciar Secuencia de Facturas Iniciar Secuencia de Facturas F Séquence de début de facture Séquence de début de facture I Avvia sequenza fatture Avvia sequenza fatture RU Начальный номер счета-фактуры Начальный номер счета-фактуры S Första fakturasekvensen Första fakturasekvensen US Start Invoice Sequence Start Invoice Sequence :$flex$.jgzz_tax_calendar_period_entity Tax Calendar Period From Tax Calendar Period To :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier P_CHART_OF_ACCOUNT_ID :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period From :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period To :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Reporting Type Code :$flex$.reporting_identifier Reporting Identifier P_CHART_OF_ACCOUNT_ID :$flex$.tax_calendar_period_from Tax Calendar Period From Tax Calendar Period To