<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: FA Prorate Convention Listing - draft -->
 <REPORTS_ROW>
  <GUID>82288223F1E43869E053B46B63588994</GUID>
  <SQL_TEXT>SELECT
        CT.PRORATE_CONVENTION_CODE                              PR_CODE,
        CT.DESCRIPTION                                          DESCR,
        LU.MEANING                              DEPR_FLAG,
        CO.START_DATE                  CONV_START,
        CO.END_DATE                      CONV_END,
        CO.PRORATE_DATE                  PRO_DATE
FROM
        FA_CONVENTIONS          CO,
        FA_CONVENTION_TYPES     CT,
        FA_FISCAL_YEAR          FY,
        FA_LOOKUPS	        	LU
WHERE
        FY.FISCAL_YEAR                  = :P_FY_YEAR
AND     FY.FISCAL_YEAR_NAME             = :P_FY_YEAR_NAME
AND
        CO.START_DATE           BETWEEN FY.START_DATE AND FY.END_DATE   AND
        CO.PRORATE_CONVENTION_CODE      = CT.PRORATE_CONVENTION_CODE
AND
        LU.LOOKUP_TYPE = &apos;YESNO&apos;	AND
        LU.LOOKUP_CODE = CT.DEPR_WHEN_ACQUIRED_FLAG
ORDER BY
        CT.PRORATE_CONVENTION_CODE,
        CO.START_DATE
</SQL_TEXT>
  <DISABLED>Y</DISABLED>
  <XDO_APPLICATION_SHORT_NAME>OFA</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>FASLSPRC_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>FA تقرير قائمة اصطلاح التوزيع بالتناسب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل</REPORT_NAME>
    <DESCRIPTION>Application: الأصول
Source: تقرير قائمة اصطلاح التوزيع بالتناسب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>FA Liste Aktivierungsregeln- Nicht unterstützt: Reserviert für zukünftige Verwendung</REPORT_NAME>
    <DESCRIPTION>Application: Anlagen
Source: Liste Aktivierungsregeln (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>FA Liste des conventions de prorata- Non pris en charge : réservé pour une utilisation future</REPORT_NAME>
    <DESCRIPTION>Application: Assets
Source: Liste des conventions de prorata (XML) - Non pris en charge : réservé pour une utilisation future
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>FA Prorate Convention Listing - draft</REPORT_NAME>
    <DESCRIPTION>Application: Assets
Source: Prorate Convention Listing Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>FA 折旧惯例列表报表- 不支持：已保留供将来使用</REPORT_NAME>
    <DESCRIPTION>Application: 资产
Source: 折旧惯例列表报表 (XML) - 不支持：已保留供将来使用
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_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_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_fy_year</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_fy_year_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_company_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_data_found</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_end_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_report_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:rp_start_date</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_fy_year_name</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>FA_FISCAL_YEAR_NAME</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
description description
from
fa_lookups
where lookup_type=&apos;FISCAL YEAR&apos;
order by meaning</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>Bezeichnung Geschäftsjahr</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de l&apos;exercice</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Fiscal Year Name</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_fy_year</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>FA_FISCAL_YEAR_KNOWN_FYNAME</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fiscal_year id,
fiscal_year value,
null description
from
fa_fiscal_year
where fiscal_year_name=:$flex$.fa_fiscal_year_name
order by fiscal_year</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>Geschäftsjahr</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Exercice</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Fiscal Year</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>会计年度</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>
