ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4707951A9E05362FB09050512 SELECT A_Fe, MAX(A1) ||MAX(A2) ||MAX(A3) ||MAX(A4) ||MAX(A5) ||MAX(A6) Trans_Data FROM (SELECT A_Fe, DECODE(B,0,Nvl2(Vat_Reg_Num,Rpad('FE001001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE001002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE001003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE001004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE001005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE001006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE001007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE001008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE001009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE001010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE001011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE001012' ||Lpad(Conf_Flag,16,' '),NULL)) A1, DECODE(B,1,Nvl2(Vat_Reg_Num,Rpad('FE002001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE002002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE002003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE002004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE002005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE002006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE002007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE002008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE002009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE002010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE002011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE002012' ||Lpad(Conf_Flag,16,' '),NULL)) A2, DECODE(B,2,Nvl2(Vat_Reg_Num,Rpad('FE003001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE003002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE003003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE003004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE003005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE003006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE003007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE003008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE003009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE003010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE003011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE003012' ||Lpad(Conf_Flag,16,' '),NULL)) A3, DECODE(B,3,Nvl2(Vat_Reg_Num,Rpad('FE004001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE004002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE004003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE004004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE004005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE004006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE004007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE004008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE004009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE004010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE004011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE004012' ||Lpad(Conf_Flag,16,' '),NULL)) A4, DECODE(B,4,Nvl2(Vat_Reg_Num,Rpad('FE005001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE005002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE005003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE005004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE005005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE005006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE005007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE005008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE005009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE005010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE005011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE005012' ||Lpad(Conf_Flag,16,' '),NULL)) A5, DECODE(B,5,Nvl2(Vat_Reg_Num,Rpad('FE006001' ||Vat_Reg_Num,24,' '),NULL) ||Nvl2(taxpayer_id,'FE006002' ||Rpad(taxpayer_id,16,' '),NULL) ||Nvl2(Recap_Inv_Flag,'FE006003' ||Lpad(Recap_Inv_Flag,16,' '),NULL) ||Nvl2(Vat_Not_Exp_Flag,'FE006004' ||Lpad(Vat_Not_Exp_Flag,16,' '),NULL) ||Nvl2(Rental_Flag,Rpad('FE006005' ||Rental_Flag,24,' '),NULL) ||Nvl2(Self_Inv_Flag,'FE006006' ||Lpad(Self_Inv_Flag,16,' '),NULL) ||Nvl2(Document_Date,'FE006007' ||Lpad(Document_Date,16,' '),NULL) ||Nvl2(Registration_Date,'FE006008' ||Lpad(Registration_Date,16,' '),NULL) ||Nvl2(Trx_Num,Je_It_Polyvalent_Decl_Rpt_Pkg.Get_Formatted_String('FE006009',Trx_Num),NULL) ||Nvl2(Taxable_Amt,'FE006010' ||Lpad(Taxable_Amt,16,' '),NULL) ||Nvl2(Tax_Amt,'FE006011' ||Lpad(Tax_Amt,16,' '),NULL) ||Nvl2(Conf_Flag,'FE006012' ||Lpad(Conf_Flag,16,' '),NULL)) A6 FROM (SELECT DECODE(Recap_Inv_Flag,'Y',NULL,DECODE(sign(length(Vat_Registration_Num)-11),0,Vat_Registration_Num,null)) Vat_Reg_Num, DECODE(Recap_Inv_Flag,'Y',NULL,DECODE(sign(length(Vat_Registration_Num)-11),0,null,tax_payer_id)) Taxpayer_Id, DECODE(Recap_Inv_Flag,'Y','1',NULL) Recap_Inv_Flag, DECODE(Vat_Not_Exp_Flag,'Y','1',NULL)Vat_Not_Exp_Flag, DECODE(Self_Inv_Flag,'Y',NULL,trx.rental_flag) Rental_Flag, DECODE(Self_Inv_Flag,'Y','1',NULL) Self_Inv_Flag, TO_CHAR(Trx_Date,'DDMMYYYY') Document_Date, TO_CHAR(Gl_Date,'DDMMYYYY') Registration_Date, Trx_Num, ROUND(Taxable_Amt) Taxable_Amt, DECODE(Vat_Not_Exp_Flag,'Y','0',ROUND(Tax_Amt)) Tax_Amt, DECODE(SIGN(Taxable_Amt -999999),1,'1',NULL) Conf_Flag, TRUNC((Rank_In_Section-1)/6) A_Fe, Mod(Rank_In_Section -1,6) B FROM Je_It_Rpt_Trx_All Trx WHERE Report_Section = 'FE' AND Eft_Num = :P_Eft_Num AND Request_Id = :G_Conc_Request_Id ORDER BY Rank_In_Section ) ) GROUP BY A_Fe ORDER BY A_Fe Y JE JEITPDEF_XMLP AR JE الإقرار متعدد الوظائف في إيطاليا - الملف الإلكتروني (قديم) Imported from BI Publisher Description: الإقرار متعدد الوظائف في إيطاليا - الملف الإلكتروني Application: المحليات الأوروبية Source: الإقرار متعدد الوظائف في إيطاليا - الملف الإلكتروني (قديم) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG D JE Polyvalente Meldung - elektronische Datei (veraltet) Imported from BI Publisher Description: Italien: Polyvalente Meldung - elektronische Datei Application: Europäische Lokalisierungen Source: Italien: Polyvalente Meldung - elektronische Datei (veraltet) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG E JE Declaración Polivalente de Italia - Fichero Electrónico (Obsoleto) Imported from BI Publisher Description: Declaración Polivalente de Italia - Fichero Electrónico Application: Localizaciones Europeas Source: Declaración Polivalente de Italia - Fichero Electrónico (Obsoleto) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG F JE Italie - Déclaration polyvalente - Fichier électronique (obsolète) Imported from BI Publisher Description: Italie - Déclaration polyvalente - Fichier électronique Application: European Localizations Source: Italie - Déclaration polyvalente - Fichier électronique (obsolète) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG I JE Dichiarazione polivalente - File elettronico (Obsoleto) Imported from BI Publisher Description: Italia: Dichiarazione polivalente - File elettronico Application: European Localizations Source: Italia: Dichiarazione polivalente - File elettronico (Obsoleto) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG RU JE Итальянская универсальная декларация - электронный файл (устарело) Imported from BI Publisher Description: Итальянская универсальная декларация - электронный файл Application: Версии для Европы Source: Итальянская универсальная декларация - электронный файл (устарело) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG S JE Italiensk multifunktionell deklaration - elektronisk fil (inaktuell) Imported from BI Publisher Description: Italiensk multifunktionell deklaration - elektronisk fil Application: European Localizations Source: Italiensk multifunktionell deklaration - elektronisk fil (inaktuell) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG TR JE İtalya Çok Değerli Beyannamesi - Elektronik Dosya (Kullanımdan Kalktı) Imported from BI Publisher Description: İtalya Çok Değerli Beyannamesi - Elektronik Dosya Application: Avrupa Yerelleştirmeleri Source: İtalya Çok Değerli Beyannamesi - Elektronik Dosya (Kullanımdan Kalktı) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG US JE Italian Polyvalent Declaration - Electronic File (Obsolete) Imported from BI Publisher Description: Italian Polyvalent Declaration - Electronic File Application: European Localizations Source: Italian Polyvalent Declaration - Electronic File (Obsolete) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG BI Publisher :g_conc_request_id :g_errbuf :g_no :g_no_of_eft_records :g_retcode :g_yes :p_decl_type_dummy :p_declaration_type :p_eft_num :p_exec_name :p_month_of_declaration :p_report_mode :p_transmission_type :p_vat_reporting_entity_id :p_year_of_declaration 1 -30 :p_decl_type_dummy Char select 1 from dual where :$flex$.declaration_type in ('1') AR JEIT_DECL_TYPE_DUMMY افتراضي نوع الإقرار D JEIT_DECL_TYPE_DUMMY Meldeart - Dummy E JEIT_DECL_TYPE_DUMMY Tipo de Declaración Ficticia F JEIT_DECL_TYPE_DUMMY Type de déclaration - Fictif I JEIT_DECL_TYPE_DUMMY Tipo di dichiarazione (fittizio) RU JEIT_DECL_TYPE_DUMMY Фиктивный параметр типа декларации S JEIT_DECL_TYPE_DUMMY Dummy för deklarationstyp TR JEIT_DECL_TYPE_DUMMY Beyanname Tipi Sözde US JEIT_DECL_TYPE_DUMMY Declaration Type Dummy 2 -20 :p_eft_num Number 1 AR رقم التحويل الإلكتروني للأموال رقم التحويل الإلكتروني للأموال D DTA-Nummer DTA-Nummer E Número TEF Número TEF F Numéro de virement Numéro de virement I Numero TEF Numero TEF RU Номер EFT Номер EFT S Gironummer Gironummer TR EFT Numarası EFT Numarası US EFT Number EFT Number 3 -10 :p_exec_name Char JEITPDEF_XMLP AR اسم البرنامج التنفيذي اسم البرنامج التنفيذي D Bezeichnung ausführbares Programm Bezeichnung ausführbares Programm E Nombre de Ejecutable Nombre de Ejecutable F Nom d'exécutable Nom d'exécutable I Nome eseguibile Nome dell'eseguibile RU Имя программы Имя программы S Namn på programfil Namn på programfil TR Yürütülebilir adı Yürütülebilir adı US Executable name Executable name 4 10 :p_vat_reporting_entity_id LOV Oracle JEIT_VAT_REP_ENTITY_ID_FOR_RPT Y select jg.vat_reporting_entity_id id, jg.entity_identifier value, null description from jg_zz_vat_rep_entities jg,(select distinct vat_reporting_entity_id from je_it_rpt_hdr_all) je where jg.vat_reporting_entity_id=je.vat_reporting_entity_id and jg.entity_type_code='LEGAL' 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 5 20 :p_declaration_type LOV Oracle JEIT_DECL_TYPE_FOR_RPT Y select lu.lookup_code id, lu.meaning value, null description from fnd_lookup_values_vl lu,(select distinct vat_reporting_entity_id,declaration_type_code from je_it_rpt_hdr_all) a where lu.lookup_code=a.declaration_type_code and lu.lookup_type='JEIT_DECL_TYPE' and a.vat_reporting_entity_id=:$flex$.jeit_vat_rep_entity_id_for_rpt order by value,description Y AR نوع الإقرار نوع الإقرار D Meldeart Meldeart E Tipo de Declaración Tipo de Declaración F Type de déclaration Type de déclaration I Tipo di dichiarazione Tipo di dichiarazione RU Тип декларации Тип декларации S Deklarationstyp Deklarationstyp TR Beyanname Tipi Beyanname Tipi US Declaration Type Declaration Type 6 30 :p_year_of_declaration LOV Oracle JEIT_DECL_YEAR_FOR_RPT Y select je.year_of_declaration id, je.year_of_declaration value, null description from (select distinct year_of_declaration,vat_reporting_entity_id,declaration_type_code from je_it_rpt_hdr_all) je where je.vat_reporting_entity_id=:$flex$.jeit_vat_rep_entity_id_for_rpt and je.declaration_type_code=:$flex$.jeit_decl_type_for_rpt order by 1 Y AR سنة الإقرار سنة الإقرار D Jahr der Steuererklärung Jahr der Steuererklärung E Año de Declaración Año de Declaración F Année de déclaration Année de déclaration I Anno dichiarazione Anno dichiarazione RU Год подачи декларации Год подачи декларации S Deklarationsår Deklarationsår US Year of Declaration Year of Declaration 7 40 :p_month_of_declaration LOV Oracle JEIT_DECL_MONTH_FOR_RPT Y select a.month_of_declaration id, a.month_of_declaration value, null description from (select distinct vat_reporting_entity_id,year_of_declaration,month_of_declaration,declaration_type_code from je_it_rpt_hdr_all) a,gl_periods b,jg_zz_vat_rep_entities c where a.vat_reporting_entity_id=:$flex$.jeit_vat_rep_entity_id_for_rpt and a.declaration_type_code=:$flex$.jeit_decl_type_for_rpt and :$flex$.jeit_decl_type_dummy is not null and a.year_of_declaration=:$flex$.jeit_decl_year_for_rpt and a.year_of_declaration=b.period_year and a.vat_reporting_entity_id=c.vat_reporting_entity_id and b.period_set_name=c.tax_calendar_name and a.month_of_declaration=b.period_name order by period_num Y AR شهر الإقرار شهر الإقرار D Monat der Meldung Monat der Meldung E Mes de Declaración Mes de Declaración F Mois de déclaration Mois de déclaration I Mese di dichiarazione Mese di dichiarazione RU Месяц подачи декларации Месяц подачи декларации S Deklarationsmånad Deklarationsmånad TR Beyan Ayı Beyan Ayı US Month of Declaration Month of Declaration 8 50 :p_transmission_type LOV Oracle JEIT_UPLOAD_TYPE Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type='JEIT_UPLOAD_TYPE' and enabled_flag='Y' order by lookup_code Y AR نوع التحويل نوع التحويل D Übertragungsart Übertragungsart E Tipo de Transmisión Tipo de Transmisión F Type de transmission Type de transmission I Tipo trasmissione Tipo di trasmissione RU Тип передачи Тип передачи S Överföringstyp Överföringstyp TR İleti Tipi İleti Tipi US Transmission Type Transmission Type 9 60 :p_report_mode LOV Oracle JE_IT_REPORT_MODE_FOR_EFT Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type='JE_IT_REPORT_MODE' order by value,description Y AR وضع التقرير وضع التقرير D Auswertungsmodus Auswertungsmodus E Modo de Informe Modo de Informe F Mode d'édition Mode d'édition I Modalità rapporto Modalità del rapporto RU Режим отчета Режим отчета S Rapportläge Rapportläge TR Rapor Modu Rapor Modu US Repot Mode Repot Mode