<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: JE Online VAT Response Status Report for Spain -->
 <REPORTS_ROW>
  <GUID>82288223F0F33869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>                select  jeovt.trx_id               &quot;TRX_ID&quot;  
                       ,jeovt.trx_number           &quot;TRX_NUMBER&quot;
                       ,jeovt.invoice_payment_id   &quot;INVOICE_PAYMENT_ID&quot;
                       ,jeovt.payment_method       &quot;PAYMENT_METHOD&quot;
                       ,jeovt.iban_number          &quot;PAYMENT_REF&quot;
                       ,jeovt.response_error       &quot;RESPONSE_ERROR&quot;
                       ,DECODE(jeovt.response_err_code,0,null,jeovt.response_err_code)   &quot;RESPONSE_ERR_CODE&quot;
                       ,jeovt.response_error_desc  &quot;RESPONSE_ERROR_DESC&quot;    
                FROM je_es_online_vat_trx    jeovt
                WHERE jeovt.data_type = &apos;PFF&apos;
                     and jeovt.REGISTER_TYPE = &apos;RIR_P&apos; 
                     and jeovt.request_id  = :P_REQUEST_ID 
                     and jeovt.transaction_status IS NOT NULL
                     --and jeovt.transaction_status &lt;&gt; &apos;M&apos;
                     and jeovt.trx_id is not null
                     ORDER BY jeovt.transaction_status, jeovt.response_err_code ,jeovt.trx_number          
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>JE</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>JEESOVSR_XMLP</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>JE تقرير موقف استجابة ضريبة القيمة المضافة المباشرة لإسبانيا</REPORT_NAME>
    <DESCRIPTION>Application: المحليات الأوروبية
Source: تقرير موقف استجابة ضريبة القيمة المضافة المباشرة لإسبانيا
Short Name: JEESOVSR_XMLP
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>JE Online-Umsatzsteuer-Antwortstatus - Spanien</REPORT_NAME>
    <DESCRIPTION>Application: Europäische Lokalisierungen
Source: Online-Umsatzsteuer-Antwortstatus - Spanien
Short Name: JEESOVSR_XMLP
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>JE Etat de statut de la réponse de TVA en ligne pour l&apos;Espagne</REPORT_NAME>
    <DESCRIPTION>Application: European Localizations
Source: Etat de statut de la réponse de TVA en ligne pour l&apos;Espagne
Short Name: JEESOVSR_XMLP
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>JE Online VAT Response Status Report for Spain</REPORT_NAME>
    <DESCRIPTION>Application: European Localizations
Source: Online VAT Response Status Report for Spain
Short Name: JEESOVSR_XMLP
DB package: </DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_request_id</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_request_id</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>P_REQUEST_ID</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
