JE Belgian VAT Purchases Journal
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Belgian VAT Purchases Journal
Short Name: JEBEDV08_XMLP
DB package: jg_zz_journal_ap_pkg
Application: European Localizations
Source: Belgian VAT Purchases Journal
Short Name: JEBEDV08_XMLP
DB package: jg_zz_journal_ap_pkg
Run
JE Belgian VAT Purchases Journal and other Oracle EBS reports with Blitz Report™ on our demo environment
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 */ |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Reporting Identifier |
|
LOV Oracle | |
Tax Calendar Period |
|
LOV Oracle | |
Document Sequence Name From |
|
LOV Oracle | |
Document Sequence Name To |
|
LOV Oracle | |
Vendor Name From |
|
LOV Oracle | |
Vendor Name To |
|
LOV Oracle | |
Report Format |
|
LOV Oracle |