ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4707851A9E05362FB09050512 SELECT ROWNUM SEQ ,PARTY_NAME ,LAST_NAME ,FIRST_NAME ,DOB ,INDV_COUNTRY_OF_BIRTH ,INDV_PROVINCE_CODE ,FOREIGN_COUNTRY ,COMPANY_NAME ,COMPANY_CITY ,COMP_COUNTRY ,COMPANY_ADDRESS ,VAT_REG_NUM ,TOTAL_AMT_AR ,TOTAL_TAX_AR ,TOTAL_AMT_GOODS ,TOTAL_AMT_SERVICES ,TOTAL_AMT_AR_C ,TOTAL_TAX_AR_C ,TOTAL_AMT_AP ,TOTAL_TAX_AP ,TOTAL_AMT ,TOTAL_AMT_AP_C ,TOTAL_TAX_AP_C FROM (SELECT PARTY_NAME ,LAST_NAME ,FIRST_NAME ,DOB ,INDV_COUNTRY_OF_BIRTH ,INDV_PROVINCE_CODE ,FOREIGN_COUNTRY ,COMPANY_NAME ,COMPANY_CITY ,COMP_COUNTRY ,COMPANY_ADDRESS ,VAT_REG_NUM ,SUM(TOTAL_AMT_AR) TOTAL_AMT_AR ,SUM(TOTAL_TAX_AR) TOTAL_TAX_AR ,SUM(TOTAL_AMT_GOODS) TOTAL_AMT_GOODS ,SUM(TOTAL_AMT_SERVICES) TOTAL_AMT_SERVICES ,SUM(TOTAL_AMT_AR_C) TOTAL_AMT_AR_C ,SUM(TOTAL_TAX_AR_C) TOTAL_TAX_AR_C ,SUM(TOTAL_AMT_AP) TOTAL_AMT_AP ,SUM(TOTAL_TAX_AP) TOTAL_TAX_AP ,SUM(TOTAL_AMT) TOTAL_AMT ,SUM(TOTAL_AMT_AP_C) TOTAL_AMT_AP_C ,SUM(TOTAL_TAX_AP_C) TOTAL_TAX_AP_C FROM ( SELECT JRL.PARTY_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',TRX.INDV_PARTY_LAST_NAME,NULL) LAST_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',Trx.INDV_PARTY_FIRST_NAME,NULL ) FIRST_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',TO_CHAR(TRX.INDV_PARTY_DOB,'DD-Mon-YYYY'),NULL ) DOB, DECODE(TRX.PARTY_TYPE,'PERSON',TRX.INDV_PARTY_BIRTH_CITY,NULL) INDV_COUNTRY_OF_BIRTH , DECODE(TRX.PARTY_TYPE,'PERSON',DECODE(Trx.INDV_PARTY_PROVINCE,'IT',Trx.INDV_PARTY_PROVINCE,'EE')) INDV_PROVINCE_CODE, DECODE(TRX.PARTY_TYPE,'PERSON',NVL2(CC.ITALY_CODE,LPAD(CC.ITALY_CODE,3,'0'),NULL)) FOREIGN_COUNTRY, --SHOULD BE NUMERIC DECODE(TRX.PARTY_TYPE,'ORGANIZATION',TRX.PARTY_NAME,NULL) COMPANY_NAME, DECODE(Trx.Party_Type,'ORGANIZATION',Trx.Party_City,NULL) COMPANY_CITY, DECODE(TRX.PARTY_TYPE,'ORGANIZATION',NVL2(CC.ITALY_CODE,LPAD(CC.ITALY_CODE,3,'0'),NULL)) COMP_COUNTRY, --SHOULD BE NUMERIC DECODE(TRX.PARTY_TYPE,'ORGANIZATION',TRX.PARTY_ADDRESS,NULL) COMPANY_ADDRESS, Nvl(Trx.Vat_Registration_Num,Null) Vat_Reg_Num, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',0,DECODE(JRL.APPLICATION_ID,'200',(JRL.TAXABLE_AMT),0)) TOTAL_AMT_AP, Decode(Jrl.Listing_Column_Code,'NONVAT',0,Decode(Jrl.Application_Id,'200',Jrl.Tax_Amt,0)) Total_Tax_Ap, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',0,DECODE(JRL.APPLICATION_ID,'222',(JRL.TAXABLE_AMT),0)) TOTAL_AMT_AR, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',0,DECODE(JRL.APPLICATION_ID,'222',JRL.TAX_AMT,0)) TOTAL_TAX_AR, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',DECODE(JRL.APPLICATION_ID,'200',(JRL.TAXABLE_AMT),0),0) TOTAL_AMT, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',DECODE(JRL.APPLICATION_ID,'222',DECODE(PRODUCT_TYPE,'G',(JRL.TAXABLE_AMT),0),0),0) TOTAL_AMT_GOODS, DECODE(JRL.LISTING_COLUMN_CODE,'NONVAT',DECODE(JRL.APPLICATION_ID,'222',DECODE(PRODUCT_TYPE,'S',(JRL.TAXABLE_AMT),0),0),0) TOTAL_AMT_SERVICES, 0 TOTAL_AMT_AP_C, 0 TOTAL_TAX_AP_C, 0 TOTAL_AMT_AR_C, 0 TOTAL_TAX_AR_C FROM Je_It_Rpt_Trx_Lines_All Jrl, Je_It_Rpt_Trx_All Trx, (SELECT DISTINCT Country_Code, Italian_Country_Code Italy_Code FROM JE_IT_COUNTRY_REP_CODES ) Cc Where Jrl.Request_Id = :G_Conc_Request_Id AND Jrl.Trx_Type not In ('CREDIT','DEBIT','CM','DM') AND JRL.REQUEST_ID = TRX.REQUEST_ID AND JRL.PARTY_ID = TRX.PARTY_ID And JRL.Party_Site_Id = TRX.Party_Site_Id and jrl.is_above_threshold_flag = 'Y' And TRX.Report_Section = 'BL' AND TRX.COUNTRY = CC.COUNTRY_CODE (+) UNION ALL SELECT JRL.PARTY_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',TRX.INDV_PARTY_LAST_NAME,NULL) LAST_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',Trx.INDV_PARTY_FIRST_NAME,NULL ) FIRST_NAME, DECODE(TRX.PARTY_TYPE,'PERSON',TO_CHAR(TRX.INDV_PARTY_DOB,'DD-Mon-YYYY'),NULL ) DOB, DECODE(TRX.PARTY_TYPE,'PERSON',TRX.INDV_PARTY_BIRTH_CITY,NULL) INDV_COUNTRY_OF_BIRTH , DECODE(TRX.PARTY_TYPE,'PERSON',DECODE(Trx.INDV_PARTY_PROVINCE,'IT',Trx.INDV_PARTY_PROVINCE,'EE')) INDV_PROVINCE_CODE, DECODE(TRX.PARTY_TYPE,'PERSON',NVL2(CC.ITALY_CODE,LPAD(CC.ITALY_CODE,3,'0'),NULL)) FOREIGN_COUNTRY, --SHOULD BE NUMERIC DECODE(TRX.PARTY_TYPE,'ORGANIZATION',TRX.PARTY_NAME,NULL) COMPANY_NAME, DECODE(Trx.Party_Type,'ORGANIZATION',Trx.Party_City,NULL) Company_CITY, DECODE(TRX.PARTY_TYPE,'ORGANIZATION',NVL2(CC.ITALY_CODE,LPAD(CC.ITALY_CODE,3,'0'),NULL)) COMP_COUNTRY, --SHOULD BE NUMERIC DECODE(TRX.PARTY_TYPE,'ORGANIZATION',TRX.PARTY_ADDRESS,NULL) COMPANY_ADDRESS, NVL(trx.Vat_Registration_Num,NULL) VAT_REG_NUM, 0 TOTAL_AMT_AP, 0 TOTAL_TAX_AP, 0 TOTAL_AMT_AR, 0 TOTAL_TAX_AR, 0 TOTAL_AMT, 0 TOTAL_AMT_GOODS, 0 TOTAL_AMT_SERVICES, Nvl(Decode(Jrl.Application_Id,'200',(Jrl.Taxable_Amt)),0) Total_Amt_Ap_C, Nvl(Decode(Jrl.Application_Id,'200',Jrl.Tax_Amt),0) Total_Tax_Ap_C, Nvl(Decode(Jrl.Application_Id,'222',(Jrl.Taxable_Amt)),0) Total_Amt_Ar_C, NVL(DECODE(JRL.APPLICATION_ID,'222',JRL.TAX_AMT),0) TOTAL_TAX_AR_C From Je_It_Rpt_Trx_Lines_All Jrl, Je_It_Rpt_Trx_All Trx, (SELECT DISTINCT Country_Code, Italian_Country_Code Italy_Code FROM JE_IT_COUNTRY_REP_CODES ) Cc WHERE JRL.REQUEST_ID = :G_Conc_Request_Id --40669700 AND Jrl.Trx_Type In ('CREDIT','DEBIT','CM','DM') AND JRL.REQUEST_ID = TRX.REQUEST_ID AND JRL.PARTY_ID = TRX.PARTY_ID And JRL.Party_Site_Id = TRX.Party_Site_Id and jrl.is_above_threshold_flag = 'Y' And TRX.Report_Section = 'BL' AND Trx.Country = Cc.Country_Code (+) ) GROUP BY PARTY_NAME, Vat_Reg_Num, LAST_NAME, FIRST_NAME, DOB, INDV_COUNTRY_OF_BIRTH , INDV_PROVINCE_CODE, FOREIGN_COUNTRY, COMPANY_NAME, COMPANY_CITY, COMP_COUNTRY, COMPANY_ADDRESS) Y JE JEITPDAR_XMLP AR JE الإقرار متعدد الوظائف في إيطاليا - تقرير التدقيق (قديم) Imported from BI Publisher Description: الفواتير الإيطالية الأعلى من الحد - تقرير التدقيق Application: المحليات الأوروبية Source: الإقرار متعدد الوظائف في إيطاليا - تقرير التدقيق (قديم) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG D JE Polyvalente Meldung - Prüfprotokoll (veraltet) Imported from BI Publisher Description: Italien: Rechnungen über Schwellenwert - Prüfprotokoll Application: Europäische Lokalisierungen Source: Italien: Polyvalente Meldung - Prüfprotokoll (veraltet) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG E JE Declaración Polivalente de Italia - Informe de Auditoría (Obsoleto) Imported from BI Publisher Description: Italia - Facturas por Encima de Umbral - Informe de Auditoría Application: Localizaciones Europeas Source: Declaración Polivalente de Italia - Informe de Auditoría (Obsoleto) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG F JE Italie - Déclaration polyvalente - Etat d'audit (obsolète) Imported from BI Publisher Description: Italie - Factures au-dessus du seuil - Etat d'audit Application: European Localizations Source: Italie - Déclaration polyvalente - Etat d'audit (obsolète) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG I JE Dichiarazione polivalente - Rapporto audit (Obsoleto) Imported from BI Publisher Description: Fatture italiane al di sopra della soglia - Rapporto audit Application: European Localizations Source: Italia: Dichiarazione polivalente - Rapporto audit (Obsoleto) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG RU JE Итальянская универсальная декларация - отчет об аудите (устарело) Imported from BI Publisher Description: СФ больше порога - отчет об аудите (Италия) Application: Версии для Европы Source: Итальянская универсальная декларация - отчет об аудите (устарело) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG S JE Italiensk multifunktionell deklaration - granskningsrapport (inaktuell) Imported from BI Publisher Description: Italienska fakturor över tröskelvärdet - revisionsrapport Application: European Localizations Source: Italiensk multifunktionell deklaration - granskningsrapport (inaktuell) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG TR JE İtalya Çok Değerli Beyannamesi - Denetleme Raporu (Kullanımdan Kalktı) Imported from BI Publisher Description: Eşiğin Üstündeki İtalyan Faturaları - Denetleme Raporu Application: Avrupa Yerelleştirmeleri Source: İtalya Çok Değerli Beyannamesi - Denetleme Raporu (Kullanımdan Kalktı) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG US JE Italian Polyvalent Declaration - Audit Report (Obsolete) Imported from BI Publisher Description: Italian Invoices Above Threshold - Auditing Report Application: European Localizations Source: Italian Polyvalent Declaration - Audit Report (Obsolete) Short Name: JEITPDAR_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 -20 :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 -10 :p_exec_name Char JEITPDAR_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 3 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 4 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 5 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 6 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 7 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