View: MRPBV_FORECAST_CONSUMPTIONS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_FORECAST_CONSUMPTIONS

View Text

SELECT FORUPD.SALES_ORDER_SCHEDULE_DATE
, FORUPD.SALES_ORDER_QUANTITY
, FORUPD.FORECAST_UPDATE_DATE
, FORUPD.UPDATE_QUANTITY
, FORUPD.DEMAND_CLASS
, FORUPD.TRANSACTION_ID
, SOLINE.LINE_ID
, FORUPD.LAST_UPDATE_DATE
, FORUPD.LAST_UPDATED_BY
, FORUPD.CREATION_DATE
, FORUPD.CREATED_BY
FROM SO_HEADERS_ALL SOHEADER
, SO_LINES_ALL SOLINE
, MTL_DEMAND_OMOE DEMAND
, MRP_FORECAST_UPDATES FORUPD
WHERE FORUPD.UPDATE_SEQ_NUM = DEMAND.DEMAND_ID(+)
AND FORUPD.LINE_NUM = DEMAND.USER_LINE_NUM(+)
AND DEMAND.DEMAND_SOURCE_LINE = SOLINE.LINE_ID(+)
AND SOLINE.HEADER_ID = SOHEADER.HEADER_ID(+)
AND '_SEC:FORUPD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns