ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706C51A9E05362FB09050512 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 JEILR835_XMLP AR JE ملف ضريبة القيمة المضافة المرتبط بـ 835 في إسرائيل Imported from BI Publisher Application: المحليات الأوروبية Source: ملف ضريبة القيمة المضافة المرتبط بـ 835 في إسرائيل Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg D JE USt-Datei mit Bezug zu 835 Imported from BI Publisher Application: Europäische Lokalisierungen Source: Israel: USt-Datei mit Bezug zu 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg E JE Israel - Fichero de IVA Relacionado con 835 Imported from BI Publisher Application: Localizaciones Europeas Source: Israel - Fichero de IVA Relacionado con 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg F JE Israël - Fichier TVA lié à 835 Imported from BI Publisher Application: European Localizations Source: Israël - Fichier TVA lié à 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg I JE Israele - file IVA correlato a 835 Imported from BI Publisher Application: European Localizations Source: Israele - file IVA correlato a 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg RU JE Файл НДС, не связанный с 835 (Израиль)(1) Imported from BI Publisher Application: Версии для Европы Source: Файл НДС, не связанный с 835 (Израиль)(1) Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg S JE Israelisk momsfil som avser 835 Imported from BI Publisher Application: European Localizations Source: Israelisk momsfil som avser 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg TR JE Israeli VAT File Related to 835 Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Israeli VAT File Related to 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg US JE Israeli VAT File Related to 835 Imported from BI Publisher Application: European Localizations Source: Israeli VAT File Related to 835 Short Name: JEILR835_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 JEILR835 AR رمز التقرير اسم التقرير D Auswertungsschlüssel Auswertungsbezeichnung E Código de Informe Nombre del Informe F Code état Nom de l'état I Codice rapporto Nome rapporto RU Код отчета Имя отчета S Rapportkod Rapport US Report Code Report Name 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 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 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 calendario fiscale RU Налоговый календарный период Налоговый календарный период S Skattekalenderperiod Skattekalenderperiod US Tax Calendar Period Tax Calendar Period 4 30 :p_vat_trx_type 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 USt-Transaktionsart USt-Transaktionsart E Tipo de Transacción de IVA Tipo de Transacción de IVA F Type de mouvement de TVA Type de mouvement de TVA I Tipo di transazione IVA Tipo di transazione IVA RU Тип транзакции НДС Тип транзакции НДС S Momstransaktionstyp Momstransaktionstyp TR KDV İşlem Tipi KDV İşlem Tipi US VAT Transaction Type VAT Transaction Type 5 40 :p_operation_code LOV Oracle JE_IL_OPERATION_CODE Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='JEIL_OPERATION_CODE' and trunc(nvl(end_date_active,sysdate+1))>trunc(sysdate) order by lookup_code AR رمز العملية رمز العملية D Vorgangsschlüssel Vorgangsschlüssel E Código de Operación Código de Operación F Code opération Code opération I Codice operazione Codice dell'operazione RU Код операции Код операции S Åtgärdskod Åtgärdskod TR Operasyon Kodu Operasyon Kodu US Operation Code Operation Code 6 50 :p_ichud_oskim_num Number AR JEIL_ICHUD_OSKIM_NUM رقم تسجيل ضريبة القيمة المضافة بالتوليفة D JEIL_ICHUD_OSKIM_NUM Kombinierte USt-Registernummer E JEIL_ICHUD_OSKIM_NUM Número de registro de IVA combinado F JEIL_ICHUD_OSKIM_NUM Numéro de registre de la TVA combiné I JEIL_ICHUD_OSKIM_NUM Numero registro IVA combinato RU JEIL_ICHUD_OSKIM_NUM Номер в реестре НДС (комб.) S JEIL_ICHUD_OSKIM_NUM Kombinerat momsregistreringsnummer TR JEIL_ICHUD_OSKIM_NUM Birleşik KDV Kayıt Numarası US JEIL_ICHUD_OSKIM_NUM Combined VAT Register Number 7 60 :p_vat_rep_entity_id2 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description Y AR معرف إعداد التقرير 2 معرف إعداد التقرير 02 D Kennung Steuerpflichtiger 2 Kennung Steuerpflichtiger 02 E Identificador de Entidad Fiscal 2 Identificador de Entidad Fiscal 02 F Identifiant d'entité déclarante 2 Identifiant d'entité déclarante 02 I Identificativo soggetto fiscale 2 Identificativo soggetto fiscale 02 RU Идентификатор отчета 2 Идентификатор отчета 02 S Rapporterings-id 2 Rapporterings-id 02 TR Raporlama Tanımlayıcısı 2 Raporlama Tanımlayıcısı 02 US Reporting Identifier 2 Reporting Identifier 02 8 70 :p_vat_rep_entity_id3 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 3 معرف إعداد التقرير 03 D Kennung Steuerpflichtiger 3 Kennung Steuerpflichtiger 03 E Identificador de Entidad Fiscal 3 Identificador de Entidad Fiscal 03 F Identifiant d'entité déclarante 3 Identifiant d'entité déclarante 03 I Identificativo soggetto fiscale 3 Identificativo soggetto fiscale 03 RU Идентификатор отчета 3 Идентификатор отчета 03 S Rapporterings-id 3 Rapporterings-id 03 TR Raporlama Tanımlayıcısı 3 Raporlama Tanımlayıcısı 03 US Reporting Identifier 3 Reporting Identifier 03 9 80 :p_vat_rep_entity_id4 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 4 معرف إعداد التقرير 04 D Kennung Steuerpflichtiger 4 Kennung Steuerpflichtiger 04 E Identificador de Entidad Fiscal 4 Identificador de Entidad Fiscal 04 F Identifiant d'entité déclarante 4 Identifiant d'entité déclarante 04 I Identificativo soggetto fiscale 4 Identificativo soggetto fiscale 04 RU Идентификатор отчета 4 Идентификатор отчета 04 S Rapporterings-id 4 Rapporterings-id 04 TR Raporlama Tanımlayıcısı 4 Raporlama Tanımlayıcısı 04 US Reporting Identifier 4 Reporting Identifier 04 10 90 :p_vat_rep_entity_id5 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 5 معرف إعداد التقرير 05 D Kennung Steuerpflichtiger 5 Kennung Steuerpflichtiger 05 E Identificador de Entidad Fiscal 5 Identificador de Entidad Fiscal 05 F Identifiant d'entité déclarante 5 Identifiant d'entité déclarante 05 I Identificativo soggetto fiscale 5 Identificativo soggetto fiscale 05 RU Идентификатор отчета 5 Идентификатор отчета 05 S Rapporterings-id 5 Rapporterings-id 05 TR Raporlama Tanımlayıcısı 5 Raporlama Tanımlayıcısı 05 US Reporting Identifier 5 Reporting Identifier 05 11 100 :p_vat_rep_entity_id6 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 6 معرف إعداد التقرير 06 D Kennung Steuerpflichtiger 6 Kennung Steuerpflichtiger 06 E Identificador de Entidad Fiscal 6 Identificador de Entidad Fiscal 06 F Identifiant d'entité déclarante 6 Identifiant d'entité déclarante 06 I Identificativo soggetto fiscale 6 Identificativo soggetto fiscale 06 RU Идентификатор отчета 6 Идентификатор отчета 06 S Rapporterings-id 6 Rapporterings-id 06 TR Raporlama Tanımlayıcısı 6 Raporlama Tanımlayıcısı 06 US Reporting Identifier 6 Reporting Identifier 06 12 110 :p_vat_rep_entity_id7 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 7 معرف إعداد التقرير 07 D Kennung Steuerpflichtiger 7 Kennung Steuerpflichtiger 07 E Identificador de Entidad Fiscal 7 Identificador de Entidad Fiscal 07 F Identifiant d'entité déclarante 7 Identifiant d'entité déclarante 07 I Identificativo soggetto fiscale 7 Identificativo soggetto fiscale 07 RU Идентификатор отчета 7 Идентификатор отчета 07 S Rapporterings-id 7 Rapporterings-id 07 TR Raporlama Tanımlayıcısı 7 Raporlama Tanımlayıcısı 07 US Reporting Identifier 7 Reporting Identifier 07 13 120 :p_vat_rep_entity_id8 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 8 معرف إعداد التقرير 08 D Kennung Steuerpflichtiger 8 Kennung Steuerpflichtiger 08 E Identificador de Entidad Fiscal 8 Identificador de Entidad Fiscal 08 F Identifiant d'entité déclarante 8 Identifiant d'entité déclarante 08 I Identificativo soggetto fiscale 8 Identificativo soggetto fiscale 08 RU Идентификатор отчета 8 Идентификатор отчета 08 S Rapporterings-id 8 Rapporterings-id 08 TR Raporlama Tanımlayıcısı 8 Raporlama Tanımlayıcısı 08 US Reporting Identifier 8 Reporting Identifier 08 14 130 :p_vat_rep_entity_id9 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 9 معرف إعداد التقرير 09 D Kennung Steuerpflichtiger 9 Kennung Steuerpflichtiger 09 E Identificador de Entidad Fiscal 9 Identificador de Entidad Fiscal 09 F Identifiant d'entité déclarante 9 Identifiant d'entité déclarante 09 I Identificativo soggetto fiscale 9 Identificativo soggetto fiscale 09 RU Идентификатор отчета 9 Идентификатор отчета 09 S Rapporterings-id 9 Rapporterings-id 09 TR Raporlama Tanımlayıcısı 9 Raporlama Tanımlayıcısı 09 US Reporting Identifier 9 Reporting Identifier 09 15 140 :p_vat_rep_entity_id10 LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID2 Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities where :$flex$.jeil_ichud_oskim_num is not null and vat_reporting_entity_id!=:$flex$.jgzz_vat_reporting_entity_id order by value,description AR معرف إعداد التقرير 10 معرف إعداد التقرير 10 D Kennung Steuerpflichtiger 10 Kennung Steuerpflichtiger 10 E Identificador de Entidad Fiscal 10 Identificador de Entidad Fiscal 10 F Identifiant d'entité déclarante 10 Identifiant d'entité déclarante 10 I Identificativo soggetto fiscale 10 Identificativo soggetto fiscale 10 RU Идентификатор отчета 10 Идентификатор отчета 10 S Rapporterings-id 10 Rapporterings-id 10 TR Raporlama Tanımlayıcısı 10 Raporlama Tanımlayıcısı 10 US Reporting Identifier 10 Reporting Identifier 10 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 10 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 2 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 3 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 4 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 5 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 6 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 7 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 8 :$flex$.jeil_ichud_oskim_num JEIL_ICHUD_OSKIM_NUM Reporting Identifier 9 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 10 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 2 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 3 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 4 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 5 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 6 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 7 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 8 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Reporting Identifier 9 :$flex$.jgzz_vat_reporting_entity_id Reporting Identifier Tax Calendar Period