JE Online VAT Response Status Report for Spain

➜ Back to Library
Description
Categories: BI Publisher
Application: European Localizations
Source: Online VAT Response Status Report for Spain
Short Name: JEESOVSR_XMLP
DB package:
Run JE Online VAT Response Status Report for Spain and other Oracle EBS reports with Blitz Report™ on our demo environment
                select  jeovt.trx_id               "TRX_ID"  
                       ,jeovt.trx_number           "TRX_NUMBER"
                       ,jeovt.invoice_payment_id   "INVOICE_PAYMENT_ID"
                       ,jeovt.payment_method       "PAYMENT_METHOD"
                       ,jeovt.iban_number          "PAYMENT_REF"
                       ,jeovt.response_error       "RESPONSE_ERROR"
                       ,DECODE(jeovt.response_err_code,0,null,jeovt.response_err_code)   "RESPONSE_ERR_CODE"
                       ,jeovt.response_error_desc  "RESPONSE_ERROR_DESC"    
                FROM je_es_online_vat_trx    jeovt
                WHERE jeovt.data_type = 'PFF'
                     and jeovt.REGISTER_TYPE = 'RIR_P' 
                     and jeovt.request_id  = :P_REQUEST_ID 
                     and jeovt.transaction_status IS NOT NULL
                     --and jeovt.transaction_status <> 'M'
                     and jeovt.trx_id is not null
                     ORDER BY jeovt.transaction_status, jeovt.response_err_code ,jeovt.trx_number
Parameter Name SQL text Validation
P_REQUEST_ID 
 
 Number
Download
Related Blitz Reports
JE Annual Online VAT Register Reporting for Spain JE Online VAT Register Reporting for Spain XXSJ Report VAT Register JG EMEA VAT: Turnover AR Non TRL Extract JE Italian Polyvalent Declaration - Audit Report (Obsolete) JE Italian Annual Customer Listing JE Invoice Electronic Listing File for Italy JE Portuguese Customers Recapitulative JE Italian Polyvalent Declaration - Electronic File (Obsolete)
Blitz Report™

Blitz Report™ provides multiple benefits: