<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: JG EMEA VAT: Audit AR Extract -->
 <REPORTS_ROW>
  <GUID>82288223F1403869E053B46B63588994</GUID>
  <SQL_TEXT>   SELECT jg_info_v1                           AR_DOC_SEQ_VALUE
         ,jg_info_v2                           AR_CUSTOMER_NAME
         ,jg_info_v3                           AR_ADDRESS1
         ,jg_info_v4                           AR_CUSTOMER_NUMBER
         ,jg_info_v5                           AR_POSTAL_CODE
         ,jg_info_v6                           AR_CITY
         ,jg_info_v7                           AR_CLASS
         ,jg_info_v8                           AR_DOC_NUMBER
         ,jg_info_v9                           AR_INVOICE_TYPE
         ,jg_info_v10                          AR_TAX_REFERENCE
         ,jg_info_v11                          AR_FUNCTIONAL_CURRENCY_CODE
         ,jg_info_v12                          AR_VAT_BOX
         ,jg_info_v13                          AR_VAT_BOX_DESC
         ,jg_info_v14                          AR_TRANSACTION_DESC
         ,jg_info_d1                           AR_DOCUMENT_DATE
         ,jg_info_d2                           AR_GL_DATE
         ,jg_info_d3                           AR_TAX_DATE
         ,jg_info_n1                           AR_TOTAL_AMOUNT
         ,jg_info_n2                           AR_TAXABLE_AMOUNT
         ,jg_info_n3                           AR_TAX_AMOUNT
   FROM jg_zz_vat_trx_gt
   WHERE (:p_report_name = &apos;AUDIT-AR&apos; OR :p_report_name IS NULL)
   AND    NVL(jg_info_v30,&apos;X&apos;) &lt;&gt; &apos;H&apos;
</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <XDO_APPLICATION_SHORT_NAME>JG</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>JGZZAUDITAR_XMLP</XDO_DATA_SOURCE_CODE>
  <ATTRIBUTE1>Y</ATTRIBUTE1>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>JG ضريبة القيمة المضافة لـ EMEA: استخراج بيانات تدقيق حساب المقبوضات</REPORT_NAME>
    <DESCRIPTION>Application: المحليات الأقليمية
Source: ضريبة القيمة المضافة لـ EMEA: استخراج بيانات تدقيق حساب المقبوضات
Short Name: JGZZAUDITAR_XMLP
DB package: jg_zz_audit_ar_pkg</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>JG EMEA USt: DE-Prüfprotokoll - Datenauszug</REPORT_NAME>
    <DESCRIPTION>Application: Regionale Lokalisierungen 
Source: EMEA USt: DE-Prüfprotokoll - Datenauszug
Short Name: JGZZAUDITAR_XMLP
DB package: jg_zz_audit_ar_pkg</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>JG EMEA - TVA : Audit - AR : Extraction</REPORT_NAME>
    <DESCRIPTION>Application: Regional Localizations
Source: EMEA - TVA : Audit - AR : Extraction
Short Name: JGZZAUDITAR_XMLP
DB package: jg_zz_audit_ar_pkg</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>JG EMEA VAT: Audit AR Extract</REPORT_NAME>
    <DESCRIPTION>Application: Regional Localizations
Source: EMEA VAT: Audit AR Extract
Short Name: JGZZAUDITAR_XMLP
DB package: jg_zz_audit_ar_pkg</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>JG EMEA 增值税：审计 AR 提取</REPORT_NAME>
    <DESCRIPTION>Application: 区域性本地化
Source: EMEA 增值税：审计 AR 提取
Short Name: JGZZAUDITAR_XMLP
DB package: jg_zz_audit_ar_pkg</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_customer_name_from</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_customer_name_to</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_detail_summary</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_min_trans_val</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_period</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_rec_count</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_report_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_tax_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_vat_rep_entity_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_year</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_vat_rep_entity_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>JGZZ_VAT_REPORTING_ENTITY_ID</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
vat_reporting_entity_id id,
entity_identifier value,
null description
from
jg_zz_vat_rep_entities
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>معرف إعداد التقرير</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Kennung Steuerpflichtiger</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Identifiant de reporting</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Reporting Identifier</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>申报标识</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_period</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>JGZZ_TAX_CALENDAR_PERIOD_ENTITY</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
rps.tax_calendar_period id,
rps.tax_calendar_period value,
null description
from
jg_zz_vat_rep_status rps
where rps.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id
and rps.rowid in (
select max(rps1.rowid)
from jg_zz_vat_rep_status rps1
where rps1.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id
group by rps1.tax_calendar_period)
order by period_start_date</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>فترة تقويم الضريبة</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Steuerkalenderperiode</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Période du calendrier fiscal</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Tax Calendar Period</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>纳税日历期间</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.jgzz_vat_reporting_entity_id</FLEX_BIND>
    <PARAMETER_NAME>Reporting Identifier</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Tax Calendar Period</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
