ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706451A9E05362FB09050512Y 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 JEHRVITR_XMLP AR JE تقرير ضريبة فاتورة المورد في كرواتيا Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير ضريبة فاتورة المورد في كرواتيا Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG D JE Lieferantenrechnungen - Vorsteuer Imported from BI Publisher Application: Europäische Lokalisierungen Source: Kroatien: Lieferantenrechnungen - Vorsteuer Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG E JE Croacia - Impuesto de Factura de Proveedor Imported from BI Publisher Description: Croacia - Informe Impuesto de Factura de Proveedor Application: Localizaciones Europeas Source: Croacia - Impuesto de Factura de Proveedor Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG F JE Croatie - Etat des taxes sur facture fournisseur Imported from BI Publisher Application: European Localizations Source: Croatie - Etat des taxes sur facture fournisseur Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG I JE Croazia - rapporto Imposta fatture fornitori Imported from BI Publisher Application: European Localizations Source: Croazia - rapporto Imposta fatture fornitori Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG RU JE Налоговый отчет по счетам-фактурам поставщика (Хорватия) Imported from BI Publisher Application: Версии для Европы Source: Налоговый отчет по счетам-фактурам поставщика (Хорватия) Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG S JE Kroatisk skatterapport över leverantörsfaktura Imported from BI Publisher Application: European Localizations Source: Kroatisk skatterapport över leverantörsfaktura Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG TR JE Croatian Supplier Invoice Tax Imported from BI Publisher Description: Croatia Supplier Invoice Tax Report Application: Avrupa Yerelleştirmeleri Source: Croatian Supplier Invoice Tax Report Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG US JE Croatian Supplier Invoice Tax Imported from BI Publisher Description: Croatia Supplier Invoice Tax Report Application: European Localizations Source: Croatian Supplier Invoice Tax Report Short Name: JEHRVITR_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 JEHRVITR AR P_CALLING_REPORT طلب التقرير D P_CALLING_REPORT Aufrufende Auswertung E P_CALLING_REPORT Informe Que Solicita los Datos F P_CALLING_REPORT Etat appelant I P_CALLING_REPORT Rapporto chiamante RU P_CALLING_REPORT Отчет вызова S P_CALLING_REPORT Anropar rapport US P_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 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_inc_prepayments LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR تضمين الدفعات المقدمة تضمين الدفعات المقدمة D Mit Vorauszahlungen Mit Vorauszahlungen E Incluir Anticipos Incluir Anticipos F Inclure les acomptes Inclure les acomptes I Includi anticipi Includi anticipi RU Включить предоплату Включить предоплату S Inkludera förskott Inkludera förskott US Include Prepayments Include Prepayments