ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4705A51A9E05362FB09050512Y 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 JEESMODELOEXT_XMLP AR JE ضريبة قيمة مضافة لـ EMEA: استخراج النموذج الأسباني Imported from BI Publisher Description: استخراج النموذج الأسباني Application: المحليات الأوروبية Source: ضريبة قيمة مضافة لـ EMEA: استخراج النموذج الأسباني Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg D JE EMEA USt: Spanien: Modelo - Datenauszug Imported from BI Publisher Description: Spanien: Modelo - Datenauszug Application: Europäische Lokalisierungen Source: EMEA USt: Spanien: Modelo - Datenauszug Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg E JE España - IVA de EMEA: Extracto de Modelo Imported from BI Publisher Description: España: Extracto de modelo Application: Localizaciones Europeas Source: España - IVA de EMEA: Extracto de Modelo Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg F JE TVA EMEA : Espagne - Extrait de Modelo Imported from BI Publisher Description: Espagne - Extrait de Modelo Application: European Localizations Source: TVA EMEA : Espagne - Extrait de Modelo Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg I JE EMEA IVA: Spagna - estrazione modello Imported from BI Publisher Description: Spagna - estrazione modello Application: European Localizations Source: EMEA IVA: Spagna - estrazione modello Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg RU JE НДС EMEA: извлечение modelo (Испания) Imported from BI Publisher Description: Извлечение modelo (Испания) Application: Версии для Европы Source: НДС EMEA: извлечение modelo (Испания) Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg S JE Moms för EMEA: Spansk extrahering av modelo Imported from BI Publisher Description: Spansk extrahering av modelo Application: European Localizations Source: Moms för EMEA: Spansk extrahering av modelo Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg TR JE EMEA VAT: Spanish Modelo Extract Imported from BI Publisher Description: Spanish Modelo Extract Application: Avrupa Yerelleştirmeleri Source: EMEA VAT: Spanish Modelo Extract Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg US JE EMEA VAT: Spanish Modelo Extract Imported from BI Publisher Description: Spanish Modelo Extract Application: European Localizations Source: EMEA VAT: Spanish Modelo Extract Short Name: JEESMODELOEXT_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 -20 :p_enable_source Number 1 US FND_NUMBER p_enable_source 2 -10 :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 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_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 Steuerkalenderperiode Steuerkalenderperiode E Período de Calendario Fiscal Período de Calendario Fiscal F Période du calendrier fiscal Période du calendrier fiscal I Periodo calendario fiscale Periodo calendario fiscale RU Налоговый календарный период Налоговый календарный период S Skattekalenderperiod Skattekalenderperiod US Tax Calendar Period Tax Calendar Period 5 30 :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