JE Italian Purchase VAT Register

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Italian Purchase VAT Register
Short Name: JEITAPPV_XMLP
DB package: jg_zz_journal_ap_pkg

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

   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
VAT Register ID 
 
 LOV Oracle
First Page Number 
 
 Number
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: