ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705B51A9E05362FB09050512Y SELECT RECORD_TYPE, MODEL, YEAR, DECLARING_NIF, DECLARED_NIF, LEGAL_REP_NIF, DECLARED_NAME, COUNTRY_CODE, KEY_ID, FISCAL_ID, BOOK_TYPE, TRANSACTION_CODE, ISSUE_DATE, TRANSACTION_DATE, TAX_RATE , DECODE(SIGN(SUM(TAXABLE_AMT_ORIG)), -1, 'N', ' ') || SUBSTR(TO_CHAR(SUM(TAXABLE_AMT_ORIG), '00000000000D00'), 2, 11) || substrb(TO_CHAR(SUM(TAXABLE_AMT_ORIG), '00000000000D00'), 14, 2) TAXABLE_AMT, decode(SIGN(sum(TAX_AMT_ORIG)), -1, 'N', ' ') || substr(to_char(sum(TAX_AMT_ORIG), '00000000000D00'), 2, 11) || substrb(to_char(sum(TAX_AMT_ORIG), '00000000000D00'), 14, 2) TAX_AMT, decode(SIGN(sum(INV_TOTAL_AMT_ORIG)), -1, 'N', ' ') || substr(to_char(sum(INV_TOTAL_AMT_ORIG), '00000000000D00'), 2, 11) || substrb(to_char(sum(INV_TOTAL_AMT_ORIG), '00000000000D00'), 14, 2)INV_TOTAL_AMT, decode(SIGN(nvl(sum(COST_TAX_AMT1),0)), -1, 'N', ' ') || substr(to_char(nvl(sum(COST_TAX_AMT1),0), '00000000000D00'), 2, 11) || substrb(to_char(nvl(sum(COST_TAX_AMT1),0), '00000000000D00'), 14, 2) COST_TAX_AMT, INVOICE_IDENT, REGISTER_NUMBER, NUM_OF_INVOICES, NUM_OF_RECORDS, ACCUM_INT_IDENT, decode(SIGN(nvl(sum(DEDUCTABLE_AMT),0)), -1, 'N', ' ') || substr(to_char(sum(DEDUCTABLE_AMT), '00000000000D00'), 2, 11) || substrb(to_char(sum(DEDUCTABLE_AMT), '00000000000D00'), 14, 2) DEDUCTABLE_AMT, TRANSACTION_DATE_ORIG, ISSUE_DATE_ORIG, sum(TAXABLE_AMT_ORIG) TAXABLE_AMT_ORIG, sum(TAX_AMT_ORIG) TAX_AMT_ORIG, sum(INV_TOTAL_AMT_ORIG) INV_TOTAL_AMT_ORIG, sum(TAX_RATE_ORIG) TAX_RATE_ORIG , SUBSTR(TO_CHAR(SUM(PAYMENT_AMT_ORIG), '00000000000D00'), 2, 11) || substrb(TO_CHAR(SUM(PAYMENT_AMT_ORIG), '00000000000D00'), 14, 2) PAYMENT_AMT ,sum(PAYMENT_AMT_ORIG) PAYMENT_AMT_ORIG ,PAYMENT_DATE_ORIG ,PAYMENT_DATE ,PAYMENT_REFERENCE ,PAYMENT_METHOD_CODE ,DEFERRED_TRX FROM (SELECT '2' RECORD_TYPE ,jg_info_v1 MODEL ,jg_info_v20 YEAR ,jg_info_v2 DECLARING_NIF ,jg_info_v4 DECLARED_NIF ,null LEGAL_REP_NIF ,jg_info_v5 DECLARED_NAME ,jg_info_v6 COUNTRY_CODE ,jg_info_v7 KEY_ID ,jg_info_v8 FISCAL_ID ,jg_info_v9 BOOK_TYPE ,jg_info_v10 TRANSACTION_CODE ,to_char(jg_info_d1, 'YYYYMMDD') ISSUE_DATE ,to_char(jg_info_d2, 'YYYYMMDD') TRANSACTION_DATE ,substr(to_char(jg_info_n1, '000D00'), 2, 3) || substr(to_char(jg_info_n1, '000D00'), 6, 2) TAX_RATE ,sum(jg_info_n5) COST_TAX_AMT1 ,jg_info_v11 INVOICE_IDENT ,jg_info_v12 REGISTER_NUMBER ,'1' NUM_OF_INVOICES ,decode (jg_info_v10,'C',row_number () over (partition by jg_info_v1 ,jg_info_v20 ,jg_info_v2 ,jg_info_v4 ,jg_info_v5 ,jg_info_v6 ,jg_info_v7 ,jg_info_v8 ,jg_info_v9 -- ,jg_info_v10 ,to_char(jg_info_d1, 'YYYYMMDD') ,to_char(jg_info_d2, 'YYYYMMDD') -- ,substr(to_char(jg_info_n1, '000D00'), 2, 3) || substr(to_char(jg_info_n1, '000D00'), 6, 2) ,jg_info_v11 ,jg_info_v12 ,to_char(jg_info_d2,'YYYY-MM-DD') ,to_char(jg_info_d1,'YYYY-MM-DD') order by jg_info_v5,jg_info_v11,jg_info_v31 nulls first) ,1) NUM_OF_RECORDS -- Bug 16236159 ,null ACCUM_INT_IDENT , sum(jg_info_n7) DEDUCTABLE_AMT ,to_char(jg_info_d2,'YYYY-MM-DD') TRANSACTION_DATE_ORIG ,to_char(jg_info_d1,'YYYY-MM-DD') ISSUE_DATE_ORIG ,sum(jg_info_n2) TAXABLE_AMT_ORIG ,sum(jg_info_n3) TAX_AMT_ORIG ,sum(jg_info_n4) INV_TOTAL_AMT_ORIG ,jg_info_n1 TAX_RATE_ORIG ,to_char(jg_info_d3,'YYYY-MM-DD') PAYMENT_DATE_ORIG ,to_char(jg_info_d3, 'YYYYMMDD') PAYMENT_DATE ,jg_info_v33 PAYMENT_REFERENCE ,sum(nvl(jg_info_n11,0)) PAYMENT_AMT_ORIG ,jg_info_v35 PAYMENT_METHOD_CODE ,jg_info_v36 DEFERRED_TRX FROM JG_ZZ_VAT_TRX_GT WHERE NVL(jg_info_v30, 'X') <> 'H' AND jg_info_v1 = '340' AND jg_info_v9 in ('R','S') AND :P_MODELO = '340' GROUP BY '2' ,jg_info_v1 ,jg_info_v20 ,jg_info_v2 ,jg_info_v4 ,null ,jg_info_v5 ,jg_info_v6 ,jg_info_v7 ,jg_info_v8 ,jg_info_v9 ,jg_info_v10 ,to_char(jg_info_d1, 'YYYYMMDD') ,to_char(jg_info_d2, 'YYYYMMDD') ,substr(to_char(jg_info_n1, '000D00'), 2, 3) || substr(to_char(jg_info_n1, '000D00'), 6, 2) ,jg_info_v11 ,jg_info_v31 -- Bug 16236159 ,jg_info_v32 -- Bug 16236159 ,jg_info_v12 ,'1' ,null ,to_char(jg_info_d2,'YYYY-MM-DD') ,to_char(jg_info_d1,'YYYY-MM-DD') ,jg_info_n1 --19350438 ,to_char(jg_info_d3, 'YYYYMMDD') ,to_char(jg_info_d3,'YYYY-MM-DD') ,jg_info_v33 ,jg_info_v35 ,jg_info_v36 HAVING (sum(jg_info_n2) <> 0 OR sum(jg_info_n3) <> 0 OR sum(jg_info_n4) <> 0 OR sum(nvl(jg_info_n11,0)) <> 0 ) ORDER BY jg_info_v11 desc ) T_TABLE group by RECORD_TYPE, MODEL, YEAR, DECLARING_NIF, DECLARED_NIF, LEGAL_REP_NIF, DECLARED_NAME, COUNTRY_CODE, KEY_ID, FISCAL_ID, BOOK_TYPE, TRANSACTION_CODE, ISSUE_DATE, TRANSACTION_DATE, TAX_RATE, INVOICE_IDENT, REGISTER_NUMBER, NUM_OF_INVOICES, NUM_OF_RECORDS, ACCUM_INT_IDENT, TRANSACTION_DATE_ORIG, ISSUE_DATE_ORIG ,PAYMENT_DATE_ORIG ,PAYMENT_DATE ,PAYMENT_REFERENCE ,PAYMENT_METHOD_CODE ,DEFERRED_TRX HAVING (sum(TAXABLE_AMT_ORIG) <> 0 OR sum(TAX_AMT_ORIG) <> 0 OR sum(INV_TOTAL_AMT_ORIG) <> 0 OR sum(PAYMENT_AMT_ORIG) <> 0) JE JEESPMOR_XMLP AR JE تقرير النموذج الدوري في أسبانيا Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير النموذج الدوري في أسبانيا Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg D JE Modelo - Periodendaten Imported from BI Publisher Description: Spanien: Auswertung "Modelo - Periodendaten" Application: Europäische Lokalisierungen Source: Spanien: Modelo - Periodendaten Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg E JE España - Modelo Periódico Imported from BI Publisher Application: Localizaciones Europeas Source: España - Modelo Periódico Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg F JE Espagne - Etat Modelo périodique Imported from BI Publisher Application: European Localizations Source: Espagne - Etat Modelo périodique Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg I JE Spagna - rapporto Modello periodico Imported from BI Publisher Application: European Localizations Source: Spagna - rapporto Modello periodico Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg RU JE Периодический отчет Мodelo (Испания) Imported from BI Publisher Application: Версии для Европы Source: Периодический отчет Мodelo (Испания) Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg S JE Spansk rapport över periodisk modelo Imported from BI Publisher Application: European Localizations Source: Spansk rapport över periodisk modelo Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg TR JE Spanish Periodic Modelo Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Spanish Periodic Modelo Report Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg US JE Spanish Periodic Modelo Imported from BI Publisher Application: European Localizations Source: Spanish Periodic Modelo Report Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg BI Publisher :g_min_value :p_340_end_date :p_340_period :p_340_start_date :p_change_periodicity :p_city :p_collective :p_contact_name :p_contact_tel :p_contact_tel_code :p_driving_date :p_elec_code :p_format_type :p_from_period :p_main_activity :p_main_activity_cd :p_medium :p_min_cash_amount_value :p_min_value :p_modelo :p_org_id :p_p_nif :p_postal_code :p_prv_reference_number :p_rec_count :p_reference_number :p_report_name :p_second_activity :p_second_activity_cd :p_source :p_street_name :p_street_number :p_street_type :p_substitution :p_tax_off_reg_codes :p_tax_office :p_tax_period :p_tax_period_to :p_tax_year :p_to_period :p_total_purchases :p_total_sales :p_vat_rep_entity_id :p_voucher 1 -60 :p_enable_driving_date Number Select 1 from dual where :$flex$.modelo_name in ('340','349') US JEES_MODELO_340_ENABLE p_enable_driving_date 2 -50 :p_enable_source Number select 1 from dual where :$flex$.modelo_name in ('347', '349', '415') US FND_NUMBER p_enable_source 3 -40 :p_enable_minvalue Number select 1 from dual where :$flex$.modelo_name in ('347', '415') AR تمكين حقل الحد الأدنى للمبلغ تمكين حقل الحد الأدنى للمبلغ D Feld "Mindestbetrag" aktivieren Feld "Mindestbetrag" aktivieren E Activar Campo Importe Mínimo Activar Campo Importe Mínimo F Activer le champ Montant minimum Activer le champ Montant minimum I Abilita campo Importo minimo Abilita campo Importo minimo RU Включить поле минимальной суммы Включить поле минимальной суммы S Aktivera fältet Lägsta belopp Aktivera fältet Lägsta belopp US Enable Minimum Amount field Enable Minimum Amount field 4 -30 :p_enable_347 Number select 1 from dual where :$flex$.modelo_name in ( '347','340') AR p_enable_347 تمكين حقول النموذج 347 فقط D p_enable_347 Nur Felder in Modelo 347 aktivieren E p_enable_347 Activar solo campos de Modelo 347 F p_enable_347 Activer les champs Modelo 347 uniquement I p_enable_347 Abilita solo i campi del modello 415. RU p_enable_347 Включить только поля Modelo 347 S p_enable_347 Aktivera endast fält för Modelo 347 TR p_enable_347 Sadece Modelo 347 alanlarını etkinleştirir US p_enable_347 Enable Modelo 347 only fields 5 -20 :p_report_name Char JEESPMOR 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 6 -10 :p_enable_rsou Number select 1 from dual where :$flex$.modelo_name in ('415', '340','347') AR FND_NUMBER_2 تمكين وحدة تشغيل موقع التقرير D FND_NUMBER_2 Betriebseinheit für Steuerstandort aktivieren E FND_NUMBER_2 Activación de la unidad operativa de sitio de declaración F FND_NUMBER_2 Activer l'unité opérationnelle du site de déclaration I FND_NUMBER_2 Abilita l'unità operativa della sede dichiarazione RU FND_NUMBER_2 Разрешить операционную единицу отчетного отделения S FND_NUMBER_2 Aktivera operativ enhet för rapporteringsort TR FND_NUMBER_2 Raporlama İşletmesi Faaliyet Birimini Etkinleştir US FND_NUMBER_2 Enable Reporting Site Operating Unit 7 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 8 20 :p_tax_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 9 30 :p_tax_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 10 40 :p_modelo LOV Oracle JEES_MODELO_NAME Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021433 order by ffvv.flex_value Y AR اسم النموذج اسم النموذج D Modelo-Bezeichnung Modelo-Bezeichnung E Nombre de Modelo Nombre de Modelo F Nom du Modelo Nom du Modelo I Nome modello Nome modello RU Modelo: имя Modelo: имя S Namn på modelo Namn på modelo US Modelo Name Modelo Name 11 50 :p_driving_date LOV Oracle JE_ES_340_DRIVING_DATE Y select fl.lookup_code id, fl.lookup_code value, fl.description description from jg_zz_vat_rep_entities jzvre,fnd_lookups fl where fl.lookup_type='JEES_340_DRIVING_DATE' and jzvre.vat_reporting_entity_id= (select nvl(mapping_vat_rep_entity_id,:$flex$.jgzz_vat_reporting_entity_id) from jg_zz_vat_rep_entities jzvre1 where jzvre1.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id) and decode(jzvre.driving_date_code,'GL-TRX',fl.enabled_flag,jzvre.driving_date_code) =decode(jzvre.driving_date_code,'GL-TRX','Y',fl.lookup_code) and :$flex$.jees_modelo_340_enable is not null order by value,description SELECT DECODE(:$flex$.modelo_name,'340',DECODE(jzvre.driving_date_code,'GL-TRX','GL','TRX','TRX','GL','GL',NULL),'349',decode(jzvre.driving_date_code,'GL-TRX','TRX','TRX','TRX','GL','GL',NULL),NULL) FROM jg_zz_vat_rep_entities jzvre where jzvre.vat_reporting_entity_id =(Select nvl(mapping_vat_rep_entity_id,:$flex$.reporting_identifier) from jg_zz_vat_rep_entities jzvre1 where jzvre1.vat_reporting_entity_id = :$flex$.reporting_identifier) Y AR تاريخ التشغيل تاريخ التشغيل D Basisdatum Basisdatum E Fecha de Conducción Fecha de Conducción F Date d'opération Date d'opération I Data di riferimento Data di riferimento RU Ведущая дата Ведущая дата S Kördatum Kördatum TR İşlem Tarihi İşlem Tarihi US Driving Date Driving Date 12 60 :p_source LOV Oracle JGZZ_VAT_SOURCE_MODELO Y select flv.lookup_code id, flv.meaning value, null description from fnd_lookup_values flv where flv.lookup_type='JGZZ_SOURCE' and flv.language=userenv('LANG') and flv.lookup_code in ('AP','AR') and :$flex$.fnd_number is not null order by value,description Y AR المصدر المصدر D Herkunft Herkunft E Origen Origen F Origine Origine I Origine Origine RU Источник Источник S Källa Källa TR Kaynak Kaynak US Source Source 13 70 :p_min_value Char 0 Y AR الحد الأدنى للمبلغ المحرر له فاتورة الحد الأدنى للمبلغ المحرر له فاتورة D Mindestbetrag Rechnung Mindestbetrag Rechnung E Importe Mínimo Facturado Importe Mínimo Facturado F Montant minimum facturé Montant minimum facturé I Importo minimo fatturato Importo minimo fatturato RU Минимальная сумма по счету-фактуре Минимальная сумма по счету-фактуре S Lägsta fakturerade belopp Lägsta fakturerade belopp TR Minimum Faturalanan Tutar Minimum Faturalanan Tutar US Minimum Invoiced Amount Minimum Invoiced Amount 14 80 :p_min_cash_amount_value Number 0 Y AR الحد الأدنى لمبلغ النقدية المستلم الحد الأدنى لمبلغ النقدية المستلم D Mindestbetrag erhaltene Zahlungen Mindestbetrag erhaltene Zahlungen E Importe Mínimo Recibido en Efectivo Importe Mínimo Recibido en Efectivo F Montant minimum reçu en espèces Montant minimum reçu en espèces I Importo minimo contante ricevuto Importo minimo ricevuto in contanti RU Мин. сумма полученных денежных средств Мин. сумма полученных денежных средств S Minsta mottagna kontantbelopp Minsta mottagna kontantbelopp TR Alınan Minimum Nakit Tutarı Alınan Minimum Nakit Tutarı US Minimum Cash Amount Received Minimum Cash Amount Received 15 90 :p_org_id LOV Oracle JEES_PERIOD_MODELO_SITE_OU Y select hr.organization_id id, hr.name value, null description from xle_le_ou_ledger_v xle,hr_operating_units hr where xle.operating_unit_id=hr.organization_id and :$flex$.fnd_number_2 is not null and (xle.ledger_id=(select ledger_id from jg_zz_vat_rep_entities where vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and entity_type_code='ACCOUNTING') or xle.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_type_code='LEGAL') ) order by value,description Y AR وحدة تشغيل موقع إعداد التقارير وحدة تشغيل موقع إعداد التقارير D Betriebseinheit Steuerstandort Betriebseinheit Steuerstandort E Unidad Operativa de Sitio de Declaración Unidad Operativa de Sitio de Declaración F Unité opérationnelle du site de déclaration Unité opérationnelle du site de déclaration I Unità operativa sede dichiarazione Unità operativa della sede dichiarazione RU Операционная единица отчетного отделения Операционная единица отчетного отделения S Operativ enhet för rapporteringsort Operativ enhet för rapporteringsort TR Raporlama İşletmesi Faaliyet Birimi Raporlama İşletmesi Faaliyet Birimi US Reporting Site Operating Unit Reporting Site Operating Unit