JE Online VAT Response Status Report for Spain

Description
Categories: BI Publisher
Columns: Trx Id, Trx Number, Invoice Payment Id, Payment Method, Payment Ref, Response Error, Response Err Code, Response Error Desc ...
Application: European Localizations
Source: Online VAT Response Status Report for Spain
Short Name: JEESOVSR_XMLP
DB package:
                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