ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704B51A9E05362FB09050512 SELECT CASE WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') or NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') ) AND SUM(NVL(ABS(JZVTD.TAX_AMT_FUNCL_CURR),ABS(JZVTD.TAX_AMT))) >=1 THEN 1 WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') AND NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') ) THEN 1 END COUNT_INV, JZVTD.TRX_ID INV_ID, DECODE(JZVTD.REPORTING_CODE, 'VAT-RA',NVL(apinvl.GLOBAL_ATTRIBUTE14,apinv.invoice_num),'VAT-RS',NVL(apinvl.GLOBAL_ATTRIBUTE14,apinv.invoice_num),NULL) IMPORT_NUMBER, SUM( CASE WHEN JZVTD.REPORTING_CODE IN ('VAT-A','VAT-RA') THEN NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT) ELSE 0 END) VAT_ON_FA, SUM( CASE WHEN JZVTD.REPORTING_CODE IN ('VAT-S','VAT-RS','VAT-C','VAT-P','VAT-H') THEN NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT) ELSE 0 END) VAT_ON_OTHER_TRX, 0 EXCEEDED_VAT_ON_FA, 0 EXCEEDED_VAT_ON_OTHER_TRX, PVS.GLOBAL_ATTRIBUTE15, PVSS.GLOBAL_ATTRIBUTE15 FROM JG_ZZ_VAT_TRX_DETAILS JZVTD, JG_ZZ_VAT_REP_STATUS JZVRS, ap_invoices_all apinv, ap_invoice_lines_all apinvl, AP_SUPPLIERS PVS, AP_SUPPLIER_SITES_ALL PVSS, zx_lines zxl WHERE JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID AND :P_REPORT_NAME = 'JEILSVAT' AND JZVRS.SOURCE = 'AP' AND JZVRS.VAT_REPORTING_ENTITY_ID = :P_VAT_REP_ENTITY_ID AND JZVRS.TAX_CALENDAR_PERIOD = :P_PERIOD AND JZVTD.TAX_RATE_REGISTER_TYPE_CODE = 'TAX' AND(:P_VAT_TRX_TYPE IS NULL OR JZVTD.TAX_RATE_VAT_TRX_TYPE_CODE = :P_VAT_TRX_TYPE) AND JZVTD.REPORTING_CODE IN('VAT-A','VAT-S','VAT-RA','VAT-RS','VAT-C','VAT-P','VAT-H') AND apinv.invoice_id = jzvtd.trx_id AND APINV.VENDOR_ID =PVS.VENDOR_ID AND APINV.VENDOR_SITE_ID =PVSS.VENDOR_SITE_ID AND PVS.VENDOR_ID =PVSS.VENDOR_ID AND zxl.trx_id = apinv.invoice_id AND zxl.trx_id = apinvl.invoice_id(+) AND zxl.tax_line_id =jzvtd.tax_line_id AND zxl.summary_tax_line_id = apinvl.summary_tax_line_id(+) GROUP BY JZVTD.REPORTING_CODE, JZVTD.TRX_ID, DECODE(JZVTD.REPORTING_CODE, 'VAT-RA',NVL(apinvl.GLOBAL_ATTRIBUTE14,apinv.invoice_num),'VAT-RS',NVL(apinvl.GLOBAL_ATTRIBUTE14,apinv.invoice_num),NULL) ,PVS.GLOBAL_ATTRIBUTE15 ,PVSS.GLOBAL_ATTRIBUTE15 UNION ALL SELECT CASE WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') or NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') ) AND SUM(NVL(ABS(JZVTD.TAX_AMT_FUNCL_CURR),ABS(JZVTD.TAX_AMT))) >=1 THEN 1 WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') AND NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') ) THEN 1 END COUNT_INV, JZVTD.TRX_ID INV_ID, NULL IMPORT_NUMBER, SUM(DECODE(JZVTD.REPORTING_CODE,'VAT-KA',NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT),0)) VAT_ON_FA, SUM(DECODE(JZVTD.REPORTING_CODE,'VAT-KS',NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT),0)) VAT_ON_OTHER_TRX, 0 EXCEEDED_VAT_ON_FA, 0 EXCEEDED_VAT_ON_OTHER_TRX ,PVS.GLOBAL_ATTRIBUTE15 ,PVSS.GLOBAL_ATTRIBUTE15 FROM JG_ZZ_VAT_TRX_DETAILS JZVTD, JG_ZZ_VAT_REP_STATUS JZVRS ,ap_invoices_all apinv ,AP_SUPPLIERS PVS ,AP_SUPPLIER_SITES_ALL PVSS WHERE :P_REPORT_NAME = 'JEILSVAT' AND JZVRS.SOURCE = 'AP' AND JZVRS.VAT_REPORTING_ENTITY_ID = :P_VAT_REP_ENTITY_ID AND JZVTD.IL_VAT_REP_STATUS_ID = &l_vat_rep_status_id AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID AND JZVRS.PERIOD_END_DATE <= (SELECT period_end_date --bug 12606816 FROM jg_zz_vat_rep_status jgzz WHERE jgzz.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND jgzz.source = 'AP' AND jgzz.tax_calendar_period = :P_PERIOD) AND JZVTD.TAX_RATE_REGISTER_TYPE_CODE = 'TAX' AND(:P_VAT_TRX_TYPE IS NULL OR JZVTD.TAX_RATE_VAT_TRX_TYPE_CODE = :P_VAT_TRX_TYPE) AND JZVTD.REPORTING_CODE IN ('VAT-KS','VAT-KA') AND apinv.invoice_id = jzvtd.trx_id AND APINV.VENDOR_ID =PVS.VENDOR_ID AND APINV.VENDOR_SITE_ID =PVSS.VENDOR_SITE_ID AND PVS.VENDOR_ID =PVSS.VENDOR_ID GROUP BY JZVTD.REPORTING_CODE, JZVTD.TRX_ID ,PVS.GLOBAL_ATTRIBUTE15 ,PVSS.GLOBAL_ATTRIBUTE15 UNION ALL SELECT CASE WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') or NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') IN ('9','92','93') ) AND SUM(NVL(ABS(JZVTD.TAX_AMT_FUNCL_CURR),ABS(JZVTD.TAX_AMT))) >=1 THEN 1 WHEN ( NVL(PVS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') AND NVL(PVSS.GLOBAL_ATTRIBUTE15,'x') NOT IN ('9','92','93') ) THEN 1 END COUNT_INV, JZVTD.TRX_ID INV_ID,NULL IMPORT_NUMBER, 0 VAT_ON_FA, 0 VAT_ON_OTHER_TRX, SUM(DECODE(JZVTD.REPORTING_CODE,'VAT-KA',NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT),0)) EXCEEDED_VAT_ON_FA, SUM(DECODE(JZVTD.REPORTING_CODE,'VAT-KS',NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT),0)) EXCEEDED_VAT_ON_OTHER_TRX ,PVS.GLOBAL_ATTRIBUTE15 ,PVSS.GLOBAL_ATTRIBUTE15 FROM JG_ZZ_VAT_TRX_DETAILS JZVTD, JG_ZZ_VAT_REP_STATUS JZVRS ,ap_invoices_all apinv ,AP_SUPPLIERS PVS ,AP_SUPPLIER_SITES_ALL PVSS WHERE :P_REPORT_NAME = 'JEILSVAT' AND JZVRS.SOURCE = 'AP' AND JZVRS.VAT_REPORTING_ENTITY_ID = :P_VAT_REP_ENTITY_ID AND JZVTD.IL_VAT_REP_STATUS_ID = -999 AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID AND JZVRS.PERIOD_END_DATE <= (SELECT period_end_date --bug 12606816 FROM jg_zz_vat_rep_status jgzz WHERE jgzz.vat_reporting_entity_id = :P_VAT_REP_ENTITY_ID AND jgzz.source = 'AP' AND jgzz.tax_calendar_period = :P_PERIOD) AND JZVTD.TAX_RATE_REGISTER_TYPE_CODE = 'TAX' AND(:P_VAT_TRX_TYPE IS NULL OR JZVTD.TAX_RATE_VAT_TRX_TYPE_CODE = :P_VAT_TRX_TYPE) AND JZVTD.REPORTING_CODE IN ('VAT-KS','VAT-KA') AND apinv.invoice_id = jzvtd.trx_id AND APINV.VENDOR_ID =PVS.VENDOR_ID AND APINV.VENDOR_SITE_ID =PVSS.VENDOR_SITE_ID AND PVS.VENDOR_ID =PVSS.VENDOR_ID GROUP BY JZVTD.REPORTING_CODE,JZVTD.TRX_ID ,PVS.GLOBAL_ATTRIBUTE15 ,PVSS.GLOBAL_ATTRIBUTE15 Y JE JEAEVA01_XMLP AR JE تقرير ضريبة القيمة المضافة في الإمارات العربية المتحدة Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير ضريبة القيمة المضافة في الإمارات العربية المتحدة Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg D JE USt-Auswertung Imported from BI Publisher Application: Europäische Lokalisierungen Source: VAE: USt-Auswertung Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg E JE Informe de IVA de Emiratos Árabes Unidos Imported from BI Publisher Application: Localizaciones Europeas Source: Informe de IVA de Emiratos Árabes Unidos Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg F JE EAU - Déclaration de la TVA Imported from BI Publisher Application: European Localizations Source: EAU - Déclaration de la TVA Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg I JE Rapporto IVA (Emirati Arabi Uniti) Imported from BI Publisher Description: Rapporto IVA per gli Emirati Arabi Uniti Application: European Localizations Source: Rapporto IVA (Emirati Arabi Uniti) Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg RU JE Отчет по НДС (ОАЭ) Imported from BI Publisher Application: Версии для Европы Source: Отчет по НДС (ОАЭ) Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg S JE momsrapportering Imported from BI Publisher Application: European Localizations Source: UAE: momsrapportering Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg TR JE Birleşik Arap Emirlikleri KDV Raporu Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Birleşik Arap Emirlikleri KDV Raporu Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg US JE UAE VAT Imported from BI Publisher Application: European Localizations Source: UAE VAT Report Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg BI Publisher &l_vat_rep_status_id :g_period_start_date :g_precision :l_err_msg :l_ledger_id :l_vat_aggregation_limit_amt :l_vat_rep_status_id :p_box_from :p_box_to :p_debug_flag :p_detail_summary :p_doc_name :p_doc_seq_value :p_first_page_num :p_func_curr :p_ichud_oskim_num :p_legal_entity_id :p_legal_entity_name :p_location :p_operation_code :p_period :p_report_format :p_report_name :p_source :p_trn_num :p_var_on_purchases :p_var_on_sales :p_vat_box :p_vat_rep_entity_id :p_vat_rep_entity_id10 :p_vat_rep_entity_id2 :p_vat_rep_entity_id3 :p_vat_rep_entity_id4 :p_vat_rep_entity_id5 :p_vat_rep_entity_id6 :p_vat_rep_entity_id7 :p_vat_rep_entity_id8 :p_vat_rep_entity_id9 :p_vat_trx_type :p_vat_trx_type_high :p_vat_trx_type_low :temp_flag 1 -10 :p_report_name Char JEAEVA01 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 del chiamante RU Отчет вызова Отчет вызова S Anropar rapport Anropar rapport TR Çağrı raporu Çağrı raporu US Calling report Calling report 2 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 Informes Identificador de Informes F Identifiant d'entité déclarante Identifiant d'entité déclarante I Identificativo soggetto fiscale Identificativo del soggetto fiscale RU Идентификатор отчета Идентификатор отчета S Rapporterings-id Rapporterings-id TR Raporlama Tanımlayıcısı Raporlama Tanımlayıcısı US Reporting Identifier Reporting Identifier 3 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 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 del calendario fiscale RU Налоговый календарный период Налоговый календарный период S Skattekalenderperiod Skattekalenderperiod TR Vergi Takvim Dönemi Vergi Takvim Dönemi US Tax Calendar Period Tax Calendar Period 4 30 :p_vat_box LOV Oracle JGZZ_VAT_REPORT_BOXES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_VAT_REPORT_BOXES' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR مربع تقرير ضريبة القيمة المضافة مربع تقرير ضريبة القيمة المضافة D USt USt E Casilla de Informe de IVA Casilla de Informe de IVA F Case de déclaration TVA Case de déclaration TVA I Casella rapporto IVA Casella del rapporto IVA RU Поле отчета об НДС Поле отчета об НДС S Momsrapportruta Momsrapportruta TR KDV Raporu Kutusu KDV Raporu Kutusu US VAT Report Box VAT Report Box 5 40 :p_vat_trx_type_low LOV Oracle JGZZ_VAT_TRANS_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='ZX_JEBE_VAT_TRANS_TYPE' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR نوع حركة ضريبة القيمة المضافة من نوع حركة ضريبة القيمة المضافة من D Von USt-Transaktionsart Von USt-Transaktionsart E De Tipo de Transacción de IVA De Tipo de Transacción de IVA F Type de mouvement de TVA - De Type de mouvement de TVA - De I Tipo transazione IVA - Da Tipo di transazione IVA - Da RU Тип транзакции НДС с Тип транзакции НДС с S Från momstransaktionstyp Från momstransaktionstyp TR KDV İşlem Tipi İlk KDV İşlem Tipi İlk US VAT Transaction Type From VAT Transaction Type From 6 50 :p_vat_trx_type_high LOV Oracle JGZZ_VAT_TRANS_TYPES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='ZX_JEBE_VAT_TRANS_TYPE' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description AR نوع حركة ضريبة القيمة المضافة إلى نوع حركة ضريبة القيمة المضافة إلى D Bis USt-Transaktionsart Bis USt-Transaktionsart E A Tipo de Transacción de IVA A Tipo de Transacción de IVA F Type de mouvement de TVA - A Type de mouvement de TVA - A I Tipo transazione IVA - A Tipo di transazione IVA - A RU Тип транзакции НДС по Тип транзакции НДС по S Till momstransaktionstyp Till momstransaktionstyp TR KDV İşlem Tipi Son KDV İşlem Tipi Son US VAT Transaction Type To VAT Transaction Type To 7 60 :p_report_format LOV Oracle JEAE_SRS_REPORT_FORMAT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JEAE_REPORT_FORMAT' order by value,description select meaning from fnd_lookup_values where lookup_type='JEBE_REPORT_FORMAT' and lookup_code ='D' and language=userenv('LANG') Y AR صيغة التقرير مؤشر التفاصيل/الإجمالي D Auswertungsformat Indikator Details/Übersicht E Formato de Informe Detalle/Resumen F Format de l'état Indicateur Détail/Synthèse I Formato rapporto Indicatore Dettaglio/Sintetico RU Формат отчета Подробный/сводный S Rapportformat Detalj-/översiktsindikator TR Rapor Formatı Detay/Özet Göstergesi US Report Format Detail/Summary Indicator 8 70 :p_source LOV Oracle JGZZ_VAT_SOURCES Y select lookup_code id, lookup_code value, meaning description from fnd_lookup_values where lookup_type='JGZZ_SOURCE' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and language=userenv('LANG') order by value,description 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 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period