<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: CE Cash Forecast Execution - draft -->
 <REPORTS_ROW>
  <GUID>82288223EF4E3869E053B46B63588994</GUID>
  <SQL_TEXT>SELECT       
	cfh.name					template_name,
	cf.name					forecast_name,
	cf.start_period				start_period,
	cf.start_date				start_date,
	cf.source_currency				src_currency,
	gdct.user_conversion_type			rate_type,
	cf.exchange_date				xchange_date,
	l3.meaning				curr_type_dsp,
	cfr.row_number				row_number,
	l2.meaning				aging_type_dsp,
	l2.lookup_code				aging_type,
	cfr.trx_type				trx_type,
	l1.meaning				trx_type_dsp ,
	cfe.message_name    			message_name,
	cfe.message_text				message_text,
	cf.forecast_currency	 			forecast_currency,
	NVL(cfe.application_short_name,&apos;CE&apos;)		application_short_name, 
	CE_CEFCERR_XMLP_PKG.c_prt_message_nameformula(NVL(cfe.application_short_name,&apos;CE&apos;), cfe.message_name) C_PRT_MESSAGE_NAME
FROM       ce_lookups				l1,
	ce_lookups				l2,
	ce_lookups				l3,
	ce_forecast_errors				cfe,
                  ce_forecast_headers			cfh,
                  ce_forecast_rows				cfr,
	ce_forecasts				cf,
	gl_daily_conversion_types			gdct
WHERE     gdct.conversion_type (+) = cf.exchange_rate_type
AND	l3.lookup_type = &apos;FORECAST_CURRENCY_TYPE&apos;
AND	l3.lookup_code = cf.currency_type
AND	l2.lookup_type = &apos;FORECAST_AGING_TYPE&apos;
AND 	l2.lookup_code = cfh.aging_type
AND	l1.lookup_type (+) = &apos;FORECAST_TRX_TYPE&apos;
AND	l1.lookup_code (+) = cfr.trx_type
AND          cfh.forecast_header_id = cf.forecast_header_id
AND          cfr.forecast_row_id (+) = cfe.forecast_row_id
AND          cf.forecast_id = cfe.forecast_id
AND	cfe.forecast_id = NVL(:P_FORECAST_ID,cfe.forecast_id)
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>CE</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>CEFCERR_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>CE تقرير تنفيذ تقدير النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل</REPORT_NAME>
    <DESCRIPTION>Application: إدارة النقدية
Source: تقرير تنفيذ تقدير النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>CE Cashflow-Forecast - Ergebnisse- Nicht unterstützt: Reserviert für zukünftige Verwendung</REPORT_NAME>
    <DESCRIPTION>Application: Cash Management
Source: Cashflow-Forecast - Ergebnisse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>CE Compte rendu d&apos;exécution des prévisions de trésorerie- Non pris en charge : réservé pour une utilisation future</REPORT_NAME>
    <DESCRIPTION>Application: Cash Management
Source: Compte rendu d&apos;exécution des prévisions de trésorerie (XML) - Non pris en charge : réservé pour une utilisation future
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>CE Cash Forecast Execution - draft</REPORT_NAME>
    <DESCRIPTION>Application: Cash Management
Source: Cash Forecast Execution Report (XML) - Not Supported: Reserved For Future Use
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>CE 现金预测执行报表- 不支持：已保留供将来使用</REPORT_NAME>
    <DESCRIPTION>Application: 现金管理系统
Source: 现金预测执行报表 (XML) - 不支持：已保留供将来使用
Short Name: CEFCERR_XML
DB package: CE_CEFCERR_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>:c_aging_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_aging_type_dsp</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_all_translation</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_forecast_currency</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_forecast_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_template_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:c_the_end</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_debug_mode</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_forecast_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_min_precision</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_sql_trace</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_forecast_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>CE_FC_ALL_RUNNAME</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
forecast_id id,
name value,
description description
from
ce_forecasts
order by name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>اسم التقدير</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Forecast-Bezeichnung</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de la prévision</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Forecast Name</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>
  <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>
