VIEW: APPS.MRPBV_FORECAST_RULES

Source

View Text - Preformatted

SELECT FO.FORECAST_RULE_NAME , FO.DESCRIPTION , '_LA:fo.PERIOD_TYPE:MFG_LOOKUPS:MTL_PERIOD_TYPES:MEANING' , '_LA:fo.INCLUDE_SALES_ORDERS:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:fo.INCLUDE_WIP_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:fo.INCLUDE_MISCELLANEOUS_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:fo.INCLUDE_INTERORG_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:fo.FORECAST_TYPE:MFG_LOOKUPS:MTL_FORECAST:MEANING' , FO.MAXIMUM_PAST_PERIODS , FO.ALPHA_SMOOTHING_FACTOR , '_LA:fo.INCLUDE_TREND_MODEL:MFG_LOOKUPS:SYS_YES_NO:MEANING' , FO.TREND_FACTOR , '_LA:fo.INCLUDE_SEASONALITY_MODEL:MFG_LOOKUPS:SYS_YES_NO:MEANING' , FO.SEASONALITY_FACTOR , FO.FORECAST_RULE_ID , FO.LAST_UPDATE_DATE , FO.LAST_UPDATED_BY , FO.CREATION_DATE , FO.CREATED_BY FROM MTL_FORECAST_RULES FO WITH READ ONLY

View Text - HTML Formatted

SELECT FO.FORECAST_RULE_NAME
, FO.DESCRIPTION
, '_LA:FO.PERIOD_TYPE:MFG_LOOKUPS:MTL_PERIOD_TYPES:MEANING'
, '_LA:FO.INCLUDE_SALES_ORDERS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:FO.INCLUDE_WIP_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:FO.INCLUDE_MISCELLANEOUS_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:FO.INCLUDE_INTERORG_ISSUES:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:FO.FORECAST_TYPE:MFG_LOOKUPS:MTL_FORECAST:MEANING'
, FO.MAXIMUM_PAST_PERIODS
, FO.ALPHA_SMOOTHING_FACTOR
, '_LA:FO.INCLUDE_TREND_MODEL:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, FO.TREND_FACTOR
, '_LA:FO.INCLUDE_SEASONALITY_MODEL:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, FO.SEASONALITY_FACTOR
, FO.FORECAST_RULE_ID
, FO.LAST_UPDATE_DATE
, FO.LAST_UPDATED_BY
, FO.CREATION_DATE
, FO.CREATED_BY
FROM MTL_FORECAST_RULES FO WITH READ ONLY