JE Belgian VAT Purchases Journal

➜ Back to Library
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
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
Download
Related Blitz Reports
JE Portuguese Customers Recapitulative JG EMEA VAT: Turnover AR Non TRL Extract JE Italian Annual Customer Listing JG ECE Payables VAT Register JE Israeli VAT AP Detail Register JG EMEA VAT: Journal AP Extract JE Italian Annual Supplier Listing JE Spanish Inter-EU Invoices Journal JG EMEA VAT: Summary AP Extract JE Croatian Supplier Invoice Tax
Blitz Report™

Blitz Report™ provides multiple benefits: