ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706851A9E05362FB09050512Y SELECT GLP.period_name period_name ,GLP.period_num period_num ,GLP.period_year period_year ,JG_INFO_V22 doc_sequence_value ,TO_CHAR(jg_info_d1,'DD-Mon-RRRR') tax_date ,TO_CHAR(jg_info_d3,'DD-Mon-RRRR') accounting_date ,TO_CHAR(jg_info_d2,'DD-Mon-RRRR') invoice_date ,jg_info_v1 invoice_num ,jg_info_v2 vendor_name ,jg_info_n3 tax_rate ,jg_info_v3 name ,jg_info_n5 invoice_id ,jg_info_v4 invoice_type ,jg_info_v5 currency ,jg_info_v6 tax_code_desc ,SUM(jg_info_n2) taxable_amount ,SUM(jg_info_n4) tax ,SUM(jg_info_n6) rec_tax ,SUM(jg_info_n7) non_rec_tax ,SUM(jg_info_n8) functional_amount ,SUM(jg_info_n10) Transaction_amount ,SUM(jg_info_n13) Taxable_entered_amount ,jg_info_n9 acct_flexfield ,jg_info_v7 tax_code_vat_trx_type ,jg_info_v8 merchant_number ,jg_info_v10 doc_seq_name ,jg_info_v11 tax_reg_num ,jg_info_v13 tax_code_vat_trx_type_meaning ,jg_info_v12 tax_code_vat_trx_type_desc ,jg_info_v14 tax_code /* UT TESTING ,jg_info_n11 . No value is getting populated into this field */ ,decode(jg_info_v15, 'OFFSET','XOFFSET','VAT') tax_code_type_code1 ,JG_ZZ_SUMMARY_AP_PKG.CF_Tax_Code_Type_Code(decode(jg_info_v15, 'OFFSET','XOFFSET','VAT')) Tax_Code_Type_Cod_Is_Offset ,decode(jg_info_v15, 'OFFSET','XOFFSET','VAT') tax_code_type_code2 ,jg_info_n14 non_rec_unpaid_amt ,jg_info_v17 offset_flag ,jg_info_v18 offset_tax_rate_code ,SUM(DECODE(jg_info_v17,'Y', jg_info_n13 , DECODE(jg_info_v15, 'OFFSET', jg_info_n13, DECODE(jg_info_n15,-9999,jg_info_n13,jg_info_n10) ))) CF_trans_VAT_or_Offset ,SUM(DECODE(jg_info_v17,'Y',jg_info_n2, DECODE(jg_info_v15, 'OFFSET',jg_info_n2, DECODE(jg_info_n15,-9999,jg_info_n2,jg_info_n8) ))) CF_func_VAT_or_Offset FROM JG_ZZ_VAT_TRX_GT ,GL_PERIODS GLP ,jg_zz_vat_rep_status JZVRS WHERE jg_info_v9 = 'M' AND JZVRS.vat_reporting_entity_id = :P_VAT_REPORTING_ENTITY_ID AND jzvrs.tax_calendar_period = :P_TAX_CALENDAR_PERIOD AND jg_info_v16 = jzvrs.tax_calendar_period AND GLP.period_set_name = jzvrs.tax_calendar_name AND GLP.adjustment_period_flag = 'N' /* Added for bug 5915657 */ AND jg_info_d1 between glp.start_date and glp.end_date AND jzvrs.source = 'AP' AND ((:P_CALLING_REPORT = 'JGZZAPVR' ) OR :P_CALLING_REPORT = 'JEHRVITR') /* UT TEST */ AND NVL(jg_info_v30,'#') <> 'H' GROUP BY decode(jg_info_v15, 'OFFSET','XOFFSET','VAT') /* tax_code_type_code1 */ ,period_num ,period_year ,period_name ,jg_info_v12 /*tax_code_vat_trx_type_desc*/ ,jg_info_v13 /*tax_code_vat_trx_type_meaning*/ ,jg_info_v14 /* tax_code */ ,jg_info_v6 /* tax_code_desc */ ,jg_info_v10 /* doc_seq_name */ ,JG_INFO_V22 /* doc sequence value */ ,jg_info_v4 /* invoice type */ ,jg_info_n5 /* invoice id */ ,jg_info_v5 /* currency */ ,jg_info_d1 /* tax date */ ,jg_info_d3 /*accounting date */ ,jg_info_d2 /* invoice date */ ,jg_info_v1 /* invoice num */ ,jg_info_v2 /* vendor name */ ,jg_info_n3 /* tax rate */ ,jg_info_v3 /* name */ -- commented for bug 6884757,jg_info_n2 /* taxable_amount */ ,jg_info_n9 /*acct_flexfield*/ ,jg_info_v7 /*tax_code_vat_trx_type */ ,jg_info_v8 /*merchant_number*/ /* UT Bug#5258868 ,jg_info_n11 */ ,jg_info_v11 /*tax_reg_num */ /* UT Bug#5258868 ,jg_info_n11 */ ,jg_info_n14 /* non_rec_unpaid_amt */ ,JG_ZZ_SUMMARY_AP_PKG.CF_Tax_Code_Type_Code(decode(jg_info_v15, 'OFFSET','XOFFSET','VAT')) ,decode(jg_info_v15, 'OFFSET','XOFFSET','VAT') ,jg_info_v17 /* offset_flag */ ,jg_info_v18 /*offset_tax_rate_code*/ ORDER BY tax_code_type_code1 ,Tax_Code_Type_Cod_Is_Offset ,period_year desc ,period_num desc ,jg_info_v7 ,tax_code_vat_trx_type_meaning ,tax_code_vat_trx_type_desc ,tax_code_desc ,tax_code ,tax_date ,doc_sequence_value ,invoice_num JE JEILAPVR_XMLP AR JE تقرير سجل تفاصيل المدفوعات لضريبة القيمة المضافة في إسرائيل Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير سجل تفاصيل المدفوعات لضريبة القيمة المضافة في إسرائيل Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG D JE KR USt-Register - Details Imported from BI Publisher Application: Europäische Lokalisierungen Source: Israel: KR USt-Register - Details Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG E JE Israel - Registro de Detalle de IVA de Cuentas a Pagar Imported from BI Publisher Application: Localizaciones Europeas Source: Israel - Registro de Detalle de IVA de Cuentas a Pagar Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG F JE Israël - Etat de l'enregistrement détaillé de la TVA AP Imported from BI Publisher Application: European Localizations Source: Israël - Etat de l'enregistrement détaillé de la TVA AP Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG I JE Israele - rapporto Registro dettagli AP IVA Imported from BI Publisher Application: European Localizations Source: Israele - rapporto Registro dettagli AP IVA Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG RU JE Подробный отчет КР по реестру НДС (Израиль) Imported from BI Publisher Application: Версии для Европы Source: Подробный отчет КР по реестру НДС (Израиль) Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG S JE Israelisk momsregisterrapport över detaljer i AP Imported from BI Publisher Application: European Localizations Source: Israelisk momsregisterrapport över detaljer i AP Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG TR JE Israeli VAT AP Detail Register Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Israeli VAT AP Detail Register Report Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG US JE Israeli VAT AP Detail Register Imported from BI Publisher Application: European Localizations Source: Israeli VAT AP Detail Register Report Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG BI Publisher :g_company_name :g_ex_vat_trx_type_desc :g_ex_vat_trx_type_meaning :g_functional_currency :g_inc_prepayments :g_precision :g_seq_no :g_vat_trx_type_desc :g_vat_trx_type_meaning :p_calling_report :p_ex_vat_trx_type :p_inc_prepayments :p_tax_calendar_period :p_vat_reporting_entity_id :p_vat_trx_type :p_where_clause 1 -10 :p_calling_report Char JEILAPVR 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 chiamante RU Отчет вызова Отчет вызова S Anropar rapport Anropar rapport US Calling Report Calling Report 2 10 :p_vat_reporting_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_tax_calendar_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 Steuertransaktionsart Steuertransaktionsart E Tipo de Transacción Fiscal Tipo de Transacción Fiscal F Type de mouvement de taxe Type de mouvement de taxe I Tipo di transazione imposta Tipo di transazione imposta RU Тип транзакции по налогу Тип транзакции по налогу S Skattetransaktionstyp Skattetransaktionstyp US Tax Transaction Type Tax Transaction Type