JE Spanish Inter-EU Invoices Journal

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Spanish Inter-EU Invoices Journal Report
Short Name: JEESRVAR_XMLP
DB package: jg_zz_journal_ap_pkg
Run JE Spanish Inter-EU Invoices 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 From 
 
 LOV Oracle
Tax Calendar Period To 
 
 LOV Oracle
Tax Reporting Type Code 
 
 LOV Oracle
Balancing Segment 
 
 Char
Start Invoice Sequence 
 
 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 JG EMEA VAT: Summary AP Extract JE Croatian Supplier Invoice Tax
Blitz Report™

Blitz Report™ provides multiple benefits: