ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF503869E053B46B63588994 select BANK_ACCOUNT_NAME, BUDGET_NAME, BUDGET_TYPE_NAME,rtrim( DECODE(CF.CODE_COMBINATION_ID,NULL,NULL,&P_FLEXDATA ),'--') C_FLEXDATA, rtrim( DECODE(CF.CRITERIA_CATEGORY, NULL, NULL, &P_CRITERIA),'--') C_CRITERIA, bvl.meaning BUDGET_VER, CHANNEL_CODE, CF.CHART_OF_ACCOUNTS_ID, CF.CODE_COMBINATION_ID, CUSTOMER_PROFILE_CLASS_NAME, CF.DESCRIPTION, dol.meaning DISCOUNT_OPT, ENCUMBRANCE_TYPE, EXTERNAL_SOURCE_TYPE, FORECAST_HEADER_ID FORECAST_HEADER_ID3, fml.meaning FC_METHOD, DECODE(INCLUDE_DISPUTE_FLAG, 'Y','Y',NULL) INC_DISPUTE, DECODE(INCLUDE_HOLD_FLAG, 'Y','Y',NULL) INC_HOLD, DECODE(INCLUDE_NET_CASH_FLAG, 'Y','Y',NULL) INC_NET_CASH, DECODE(EXCLUDE_INDIC_EXP,'Y','Y',NULL) EX_INDIC_EXP, LEAD_TIME, odtl.meaning ORD_DATE_TYPE, DECODE(TRX_TYPE, 'OEO', oel.meaning, 'ASF', asl.meaning, 'POP',pol.meaning,'POR',pol.meaning, null) STATUS, DECODE(TRX_TYPE, 'XTR', COMPANY_CODE,ORG_NAME) ORG_NAME, PAYMENT_METHOD, PAYMENT_PRIORITY, PAYROLL_NAME, PAY_GROUP, RECEIPT_METHOD_NAME, ROLL_FORWARD_PERIOD, rftl.meaning ROLL_F_TYPE, ROW_NUMBER, SALES_STAGE_NAME, SET_OF_BOOKS_NAME, TRX_TYPE_DSP, TYPE_NAME TYP, VENDOR_TYPE, WIN_PROBABILITY from CE_FORECAST_ROWS_V CF, GL_CODE_COMBINATIONS GLCC, ce_lookups asl, ce_lookups oel, ce_lookups pol, ce_lookups dol, ce_lookups rftl, ce_lookups odtl, ce_lookups fml, ce_lookups bvl where GLCC.CHART_OF_ACCOUNTS_ID(+)= CF.CHART_OF_ACCOUNTS_ID and GLCC.code_combination_id(+) = CF.code_combination_id and asl.lookup_code(+) = CF.sales_forecast_status and asl.lookup_type(+) = 'SALES_FORECAST_STATUS' and oel.lookup_code(+) = CF.order_status and oel.lookup_type(+) = 'ORDER_STATUS' and pol.lookup_code(+) = CF.authorization_status and pol.lookup_type(+) = 'AUTHORIZATION STATUS' and dol.lookup_code(+) = DISCOUNT_OPTION and dol.lookup_type(+) = 'FORECAST_DISC_OPTION' and rftl.lookup_code(+) = ROLL_FORWARD_TYPE and rftl.lookup_type(+) = 'FORECAST_ROLL_FORWARD_TYPE' and odtl.lookup_code(+) = ORDER_DATE_TYPE and odtl.lookup_type(+) = 'FORECAST_ORDER_DATE_TYPE' and bvl.lookup_code(+) = BUDGET_VERSION and bvl.lookup_type(+) = 'FORECAST_PA_BUDGET_VSN' and fml.lookup_code(+) = FORECAST_METHOD and fml.lookup_type(+) = 'FORECAST_METHOD' and FORECAST_HEADER_ID=:fhid2 order by ROW_NUMBER Y CE CEFTMPLT_XML AR CE قائمة قوالب تقدير النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: إدارة النقدية Source: قائمة قوالب تقدير النقدية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEFTMPLT_XML DB package: CE_CEFTMPLT_XMLP_PKG D CE Cashflow-Forecast-Schemas- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Cash Management Source: Cashflow-Forecast-Schemas (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEFTMPLT_XML DB package: CE_CEFTMPLT_XMLP_PKG F CE Liste des modèles de prévision de trésorerie- Non pris en charge : réservé pour une utilisation future Application: Cash Management Source: Liste des modèles de prévision de trésorerie (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEFTMPLT_XML DB package: CE_CEFTMPLT_XMLP_PKG US CE Cash Forecast Template Listing - draft Application: Cash Management Source: Cash Forecast Template Listing (XML) - Not Supported: Reserved For Future Use Short Name: CEFTMPLT_XML DB package: CE_CEFTMPLT_XMLP_PKG ZHS CE 现金预测模板列表- 不支持：已保留供将来使用 Application: 现金管理系统 Source: 现金预测模板列表 (XML) - 不支持：已保留供将来使用 Short Name: CEFTMPLT_XML DB package: CE_CEFTMPLT_XMLP_PKG BI Publisher &p_criteria &p_flexdata :fhid2 :p_conc_request_id :p_criteria :p_flexdata :p_forecast_header_id 1 10 :p_forecast_header_id LOV Oracle CE_FC_TEMPLATE_LIST Y select forecast_header_id id, name value, description description from ce_forecast_headers where nvl(treasury_template,'N')='N' order by name AR اسم قالب التقدير D Forecast-Schema F Nom du modèle de prévision US Forecast Template name ZHS 预测模板名称