ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701C51A9E05362FB09050512Y SELECT MFR.FORECAST_RULE_ID RULE_ID, MFR.FORECAST_RULE_NAME RULE_NAME, MFR.DESCRIPTION RULE_DESC, MFR.FORECAST_TYPE FCST_TYPE_ID, ML1.MEANING FCST_TYPE_NAM, ML1.LOOKUP_CODE RULE_TYPE_CD, MFR.PERIOD_TYPE PERIOD_ID, ML2.MEANING BUCKET_NAME, ML2.LOOKUP_CODE PERIOD_CD, ML3.MEANING INCL_SORD_YN, ML4.MEANING INCL_IORG_YN, ML5.MEANING INCL_WIP_YN, ML6.MEANING INCL_MISC_YN, ML7.MEANING INCL_TREND_YN, ML8.MEANING INCL_SEASON_YN, MFR.MAXIMUM_PAST_PERIODS MAX_PAST_PDS, MFR.ALPHA_SMOOTHING_FACTOR ALPHA_SMOOTH, MFR.TREND_FACTOR TREND_FACTOR, MFR.SEASONALITY_FACTOR SEASON_FACTOR, MSI.PERIOD_NUM SEASON_PD_NUM, MSI.SEASONALITY_INDEX SEASON_INDEX, MSI.PERIOD_TYPE_CODE SEASON_PERIOD_TYPE_CD FROM MTL_FORECAST_RULES MFR, MFG_LOOKUPS ML1, MFG_LOOKUPS ML2, MFG_LOOKUPS ML3, MFG_LOOKUPS ML4, MFG_LOOKUPS ML5, MFG_LOOKUPS ML6, MFG_LOOKUPS ML7, MFG_LOOKUPS ML8, MTL_SEASONALITY_INDICES MSI WHERE MFR.FORECAST_TYPE = DECODE ( :P_FCST_TYPE_ID,'',MFR.FORECAST_TYPE, :P_FCST_TYPE_ID) AND MFR.PERIOD_TYPE = DECODE (:P_BUCKET_TYPE_ID,'',MFR.PERIOD_TYPE,:P_BUCKET_TYPE_ID) AND ( ( :P_FCST_RULE_NAME_LO IS NULL and :P_FCST_RULE_NAME_HI IS NULL ) OR ( :P_FCST_RULE_NAME_LO IS NOT NULL and :P_FCST_RULE_NAME_HI IS NULL and :P_FCST_RULE_NAME_LO = MFR.FORECAST_RULE_NAME ) OR ( :P_FCST_RULE_NAME_LO IS NOT NULL and :P_FCST_RULE_NAME_HI IS NOT NULL and MFR.FORECAST_RULE_NAME BETWEEN :P_FCST_RULE_NAME_LO AND :P_FCST_RULE_NAME_HI ) ) AND MFR.FORECAST_RULE_ID = MSI.FORECAST_RULE_ID (+) AND ML1.LOOKUP_TYPE = 'MTL_FORECAST' AND MFR.FORECAST_TYPE = ML1.LOOKUP_CODE (+) AND ML2.LOOKUP_TYPE = 'MRP_BUCKET_TYPE' AND MFR.PERIOD_TYPE = ML2.LOOKUP_CODE (+) AND ML3.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_SALES_ORDERS = ML3.LOOKUP_CODE (+) AND ML4.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_INTERORG_ISSUES = ML4.LOOKUP_CODE (+) AND ML5.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_WIP_ISSUES = ML5.LOOKUP_CODE (+) AND ML6.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_MISCELLANEOUS_ISSUES = ML6.LOOKUP_CODE (+) AND ML7.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_TREND_MODEL = ML7.LOOKUP_CODE (+) AND ML8.LOOKUP_TYPE = 'SYS_YES_NO' AND MFR.INCLUDE_SEASONALITY_MODEL = ML8.LOOKUP_CODE (+) ORDER BY MFR.FORECAST_RULE_NAME, MSI.PERIOD_NUM INV INVPRFRL_XML AR INV قائمة قواعد التقدير (بتنسيق XML) Imported from BI Publisher Description: قائمة قواعد التقدير Application: المخازن Source: قائمة قواعد التقدير (بتنسيق XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG D INV Forecast-Regeln Imported from BI Publisher Description: Forecast-Regeln Application: Lager Source: Forecast-Regeln (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG E INV Listado de Reglas de Previsión Imported from BI Publisher Description: Listado de Reglas de Previsión Application: Inventory Source: Listado de Reglas de Previsión (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG F INV Liste des règles de prévision Imported from BI Publisher Description: Liste des règles de prévision Application: Inventory Source: Liste des règles de prévision (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG I INV Elenco regole di previsione Imported from BI Publisher Description: Elenco regole di previsione Application: Inventory Source: Elenco regole di previsione (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG JA INV 需要予測ルール・リスト Imported from BI Publisher Description: 需要予測ルール・リスト Application: Inventory Source: 需要予測ルール・リスト(XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG KO INV 예측 규칙 목록 Imported from BI Publisher Description: 수요예측 규칙 목록 Application: Inventory Source: 예측 규칙 목록(XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG PTB INV Lista de regras de previsão Imported from BI Publisher Description: Lista de regras de previsão Application: Inventário Source: Lista de regras de previsão (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG RU INV Список правил прогноза Imported from BI Publisher Description: Список правил прогноза Application: Запасы Source: Список правил прогноза (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG S INV Prognosregel - lista Imported from BI Publisher Description: Prognosregel - lista Application: Inventory Source: Prognosregel - lista (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG TR INV Tahmin kuralı listeleme Imported from BI Publisher Description: Tahmin kuralı listeleme Application: Stok Yönetimi Source: Tahmin kuralı listeleme (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG US INV Forecast rule listing Imported from BI Publisher Description: Forecast rule listing Application: Inventory Source: Forecast rule listing (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG ZHS INV 预测规则列表 Imported from BI Publisher Description: 预测规则列表 Application: 库存管理系统 Source: 预测规则列表 (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG BI Publisher :p_bucket_type_id :p_conc_request_id :p_fcst_rule_name_hi :p_fcst_rule_name_lo :p_fcst_type_id :p_fcst_type_name :p_optimizer_code :p_org :p_trace_flag 1 -20 :p_org Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 10 :p_fcst_rule_name_lo LOV Oracle INV_SRS_FORECAST_RULES Y select forecast_rule_name id, forecast_rule_name value, description description from mtl_forecast_rules order by value,description AR قاعدة التقدير من قاعدة تقدير من D Von Forecast-Regel Von Forecast-Regel E De Regla de Previsión De Regla de Previsión F Règle prévision - De Règle de prévision - De I Regole di previsione da Regola previsione - Da JA 需要予測ルール:自 需要予測ルール:下位 KO 수요예측 규칙: 부터 수요예측 규칙 하한 PTB Regras de Previsão - De Regras de Previsão - Inferior RU Правила прогноза с Правило прогноза с S Prognosregler från Prognosregel från TR Tahmin Kuralları: İlk İlk Tahmin Kuralı US Forecast Rules From Forecast Rule Low ZHS 预测规则自 预测规则下限 3 20 :p_fcst_rule_name_hi LOV Oracle INV_SRS_FORECAST_RULES Y select forecast_rule_name id, forecast_rule_name value, description description from mtl_forecast_rules order by value,description AR إلى قاعدة تقدير إلى D Bis Bis Forecast-Regel E A A Regla de Previsión F A Règle de prévision - A I A Regola previsione - A JA 至 需要予測ルール:上位 KO 까지 수요예측 규칙 상한 PTB Até Regras de Previsão - Superior RU По Правило прогноза по S Till Prognosregel till TR Son Son Tahmin Kuralı US To Forecast Rule High ZHS 至 预测规则上限 4 30 :p_bucket_type_id LOV Oracle INV_SRS_FRL_BUCKET_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_BUCKET_TYPE' and enabled_flag= 'Y' order by lookup_code AR نوع الرزمة نوع الرزمة D Zeitraumart Zeitraumart E Tipo de Período Tipo de Período F Type de regroupement Type de regroupement I Tipo di periodo fisso Tipo di periodo fisso JA バケット・タイプ バケット・タイプ KO 버켓 유형 버켓 유형 PTB Tipo Período Tipo Período RU Тип интервала Тип интервала S Periodtyp Periodtyp TR Aralık Tipi Aralık Tipi US Bucket Type Bucket Type ZHS 时段类型 时段类型 5 40 :p_fcst_type_id LOV Oracle INV_SRS_FORECAST Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_FORECAST' and enabled_flag='Y' order by meaning AR نوع التقدير نوع التقدير D Forecast-Art Forecast-Art E T Previsión T Previsión F Type de prévision Type de prévision I Tipo previsione Tipo previsione JA 需要予測タイプ 需要予測タイプ KO 예측 유형 예측 유형 PTB Tipo de Previsão Tipo de Previsão RU Тип прогноза Тип прогноза S Prognostyp Prognostyp TR Tahmin Tipi Tahmin Tipi US Forecast Type Forecast Type ZHS 预测类型 预测类型