ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF4F3869E053B46B63588994 SELECT fc.name C_FORECAST_NAME, fch.name C_TEMPLATE_NAME, 'GL Periods' C_AGING_TYPE, null C_START_DATE, fc.start_period C_START_PERIOD FROM ce_forecasts fc, ce_forecast_headers fch WHERE fc.forecast_header_id = fch.forecast_header_id AND fc.forecast_header_id = nvl(:P_FORECAST_HEADER_ID, fc.forecast_header_id) AND :P_FORECAST_BY in ('D','B') AND fch.aging_type = 'D' AND trunc(fc.start_date) >= nvl(:P_FORECAST_START_DATE_1, trunc(fc.start_date)) and trunc(fc.start_date) <= nvl(:P_FORECAST_END_DATE_1, trunc(fc.start_date)) UNION ALL SELECT fc.name C_FORECAST_NAME, fch.name C_TEMPLATE_NAME, 'GL Periods' C_AGING_TYPE, null C_START_DATE, fc.start_period C_START_PERIOD FROM ce_forecasts fc, ce_forecast_headers fch WHERE fc.forecast_header_id = fch.forecast_header_id AND fc.forecast_header_id = nvl(:P_FORECAST_HEADER_ID, fc.forecast_header_id) AND :P_FORECAST_BY in ('A','B') AND fch.aging_type = 'A' AND fc.start_period in ( select glp.period_name from gl_periods glp where glp.period_set_name = fc.period_set_name and trunc(glp.start_date) >= nvl(:P_FORECAST_START_DATE_1,trunc(glp.start_date)) and trunc(glp.start_date) <= nvl(:P_FORECAST_END_DATE_1,trunc(glp.start_date))) ORDER BY C_FORECAST_NAME CE CEFPURGE_XML AR CE شطب تقديرات النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: شطب تقديرات النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEFPURGE_XML DB package: CE_CEFPURGE_XMLP_PKG D CE Cashflow-Forecasts löschen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Cashflow-Forecasts löschen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEFPURGE_XML DB package: CE_CEFPURGE_XMLP_PKG F CE Purger les prévisions de trésorerie- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Purger les prévisions de trésorerie (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEFPURGE_XML DB package: CE_CEFPURGE_XMLP_PKG US CE Purge Cash Forecasts - draft Application: Cash Management Source: Purge Cash Forecasts (XML) - Not Supported: Reserved For Future Use Short Name: CEFPURGE_XML DB package: CE_CEFPURGE_XMLP_PKG ZHS CE 清除现金预测- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 清除现金预测 (XML) - 不支持：已保留供将来使用 Short Name: CEFPURGE_XML DB package: CE_CEFPURGE_XMLP_PKG BI Publisher :c_count :c_purge_option :c_temp_name :p_conc_request_id :p_display_debug :p_forecast_by :p_forecast_end_date :p_forecast_end_date_1 :p_forecast_header_id :p_forecast_start_date :p_forecast_start_date_1 :p_sql_trace 1 10 :p_forecast_by LOV Oracle CE_FC_PURGE_OPTION Y select lookup_code id, meaning value, description description from ce_lookups where lookup_type='FC_PURGE_OPTION' order by value,description select meaning from ce_lookups where lookup_type = 'FC_PURGE_OPTION' and lookup_code = 'B' Y AR خيار الشطب D Löschoption F Option de purge US Purge Option ZHS 清除选项 2 20 :p_forecast_header_id LOV Oracle CE_FC_PURGE_TEMP_NAME Y select forecast_header_id id, name value, null description from ce_forecast_headers where aging_type=decode(:$flex$.ce_fc_purge_option,'D','D','A','A',aging_type) order by value,description AR قالب التقدير D Forecast-Schema F Modèle de prévision US Forecast Template ZHS 预测模板 3 30 :p_forecast_start_date Date select sysdate from dual AR تاريخ التقدير من D Forecast-Datum von F Date de prévision - Du US Forecast Date From ZHS 预测日期自 4 40 :p_forecast_end_date Date select sysdate from dual AR تاريخ التقدير إلى D Forecast-Datum bis F Date de prévision - Au US Forecast Date To ZHS 预测日期至 :$flex$.ce_fc_purge_option Purge Option Forecast Template