ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1473869E053B46B63588994Y SELECT jg_info_v1 SEQ_NAME ,TO_CHAR(jg_info_d2,'DD-Mon-RRRR') ACCOUNTING_DATE ,jg_info_n2 DOC_SEQUENCE_VALUE /* jg_info_v25. Bug#8278481*/ ,jg_info_v7 INVOICE_NUM ,TO_CHAR(jg_info_d1,'DD-Mon-RRRR') INVOICE_DATE ,jg_info_v2 VENDOR_NAME ,jg_info_v8 INVOICE_CURRENCY_CODE ,jg_info_v20 FUNC_CURRENCY_CODE ,jg_info_v3 VAT_NUM ,jg_info_v4 VAT_NAME ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,jg_info_n20,jg_info_n13), 2)) TAXABLE_REC_AMT ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,jg_info_n21,jg_info_n14), 2)) TAXABLE_NREC_AMT ,SUM(ROUND(decode(jg_info_v20, jg_info_v8,decode(jg_info_v29,'Y',nvl(jg_info_n22,0)+nvl(jg_info_n23,0),jg_info_n22), decode(jg_info_v29,'Y',nvl(jg_info_n15,0)+nvl(jg_info_n16,0),jg_info_n15)) , 2)) TAX_REC_AMT ,SUM(ROUND(decode(jg_info_v29,'Y',0,decode(jg_info_v20, jg_info_v8,jg_info_n23,jg_info_n16)), 2)) TAX_NREC_AMT /* Bug 16395602 ,SUM(ROUND(DECODE(jg_info_v21,'', DECODE(jg_info_v20, jg_info_v8, DECODE(nvl(jg_info_v9,'N'),'N',jg_info_n3,0), DECODE(nvl(jg_info_v9,'N'),'N',jg_info_n4,0)), NVL(jg_info_n7,0) + DECODE(nvl(jg_info_v9,'N'),'N',nvl(jg_info_n4,0),0)) + decode(jg_info_v20, jg_info_v8, jg_info_n5, jg_info_n6), 2)) TOTAL_AMT */ ,SUM(ROUND(DECODE(jg_info_v20, jg_info_v8, nvl(jg_info_n20,0)+nvl(jg_info_n21,0),nvl(jg_info_n13,0)+nvl(jg_info_n14,0)) + decode(jg_info_v20, jg_info_v8, nvl(jg_info_n22,0)+nvl(jg_info_n23,0), nvl(jg_info_n15,0)+nvl(jg_info_n16,0)), 2)) TOTAL_AMT --Bug 16395602 ,SUM(decode(jg_info_v20, jg_info_v8, 0, decode(jg_info_v39,'N',decode(jg_info_v21,'OFFSET', NVL(jg_info_n20,0) + NVL(jg_info_n21,0), NVL(jg_info_n22,0) + NVL(jg_info_n23,0) + NVL(jg_info_n20,0) + NVL(jg_info_n21,0)), NVL(jg_info_n20,0) + NVL(jg_info_n21,0)))) FOREIGN_AMT ,TO_CHAR(jg_info_d2,'DD-Mon-RRRR') C_ACCOUNTING_DATE ,TO_CHAR(jg_info_d1,'DD-Mon-RRRR') C_INVOICE_DATE FROM jg_zz_vat_trx_gt WHERE :P_REPORT_NAME = 'JEITAPSR' AND jg_info_v30 = 'JEITAPSR' GROUP BY jg_info_v1 /* SEQ_NAME */ ,jg_info_d2 /* ACCOUNTING_DATE */ ,jg_info_n2 /* DOC_SEQUENCE_VALUE */ /* jg_info_v25 Bug#8278481 */ ,jg_info_v7 /* INVOICE_NUM */ ,jg_info_d1 /* INVOICE_DATE */ ,jg_info_v2 /* VENDOR_NAME */ ,jg_info_v3 /* VAT_NUM */ ,jg_info_v4 /* VAT_NAME */ ,jg_info_v8 /* INVOICE_CURRENCY_CODE */ ,jg_info_v20 /* FUNC_CURRENCY_CODE */ ORDER BY jg_info_v1 /* SEQ_NAME */ ,jg_info_n2 /* DOC_SEQUENCE_VALUE */ /* jg_info_v25 Bug#8278481 */ ,jg_info_d2 /* ACCOUNTING_DATE */ ,jg_info_v7 /* INVOICE_NUM */ ,jg_info_d1 /* INVOICE_DATE */ ,jg_info_v2 /* VENDOR_NAME */ ,jg_info_v4 /* VAT_NAME */ ,jg_info_v8 /* INVOICE_CURRENCY_CODE */ JG JGZZJOURNALAP_XMLP AR JG ضريبة القيمة المضافة لـ EMEA: استخراج بيانات يومية حساب المدفوعات Application: المحليات الأقليمية Source: ضريبة القيمة المضافة لـ EMEA: استخراج بيانات يومية حساب المدفوعات Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg D JG EMEA USt: KR-Buchungen - Datenauszug Application: Regionale Lokalisierungen Source: EMEA USt: KR-Buchungen - Datenauszug Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg F JG EMEA - TVA : Pièce - AP : Extraction Application: Regional Localizations Source: EMEA - TVA : Pièce - AP : Extraction Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg US JG EMEA VAT: Journal AP Extract Application: Regional Localizations Source: EMEA VAT: Journal AP Extract Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg ZHS JG EMEA 增值税：日记帐 AP 提取 Application: 区域性本地化 Source: EMEA 增值税：日记帐 AP 提取 Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg BI Publisher :g_precision :l_err_msg :l_rec_count :p_balancing_segment :p_debug_flag :p_detail_summary :p_document_sequence_name_from :p_document_sequence_name_to :p_first_page_num :p_period :p_period_to :p_register_type :p_report_name :p_start_inv_sequence :p_tax_type :p_vat_register_id :p_vat_rep_entity_id :p_vendor_name_from :p_vendor_name_to 1 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 F Identifiant de reporting US Reporting Identifier ZHS 申报标识 2 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 Steuerperiode F Période fiscale US Tax Period ZHS 纳税期间