FND Design Data [Home] [Help]

View: MRPBV_FORECAST_ENTRIES

Product: MRP - Master Scheduling/MRP
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.MRPBV_FORECAST_ENTRIES
View Text

SELECT FO.FORECAST_DESIGNATOR
, '_LA:FO.BUCKET_TYPE:MFG_LOOKUPS:MRP_BUCKET_TYPE:MEANING'
, FO.FORECAST_DATE
, FO.RATE_END_DATE
, FO.CURRENT_FORECAST_QUANTITY
, FO.ORIGINAL_FORECAST_QUANTITY
, FO.CONFIDENCE_PERCENTAGE
, FO.COMMENTS COMMENTS
, '_LA:FO.ORIGINATION_TYPE:MFG_LOOKUPS:MRP_FORECAST_ORIG:MEANING'
, FO.DEMAND_CLASS
, FO.END_PLANNING_BOM_PERCENT
, FO.TRANSACTION_ID
, FO.ORGANIZATION_ID
, FO.INVENTORY_ITEM_ID
, FO.SOURCE_ORGANIZATION_ID
, FO.SOURCE_FORECAST_DESIGNATOR
, FO.END_ITEM_ID
, FO.FORECAST_RULE_ID
, FO.PROJECT_ID
, FO.TASK_ID
, FO.LINE_ID
, FO.LAST_UPDATE_DATE
, FO.LAST_UPDATED_BY
, FO.CREATION_DATE
, FO.CREATED_BY
FROM MRP_FORECAST_DATES FO WITH READ ONLY

Columns

Name
FORECAST_NAME
"_LA:BUCKET_TYPE"
FORECAST_DATE
END_DATE
CURRENT_FORECAST_QUANTITY
ORIGINAL_FORECAST_QUANTITY
CONFIDENCE_PERCENT
COMMENTS
"_LA:ORIGINATION_TYPE"
DEMAND_CLASS
END_PLANNING_BOM_PERCENT
FORECAST_ENTRY_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
SOURCE_ORGANIZATION_ID
SOURCE_FORECAST_NAME
END_ITEM_ID
FORECAST_RULE_ID
PROJECT_ID
TASK_ID
LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY