VIEW: APPS.MRPBV_FORECAST_ENTRIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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