View: MRPBV_MDS_CONSUMPTIONS

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

View Text

SELECT DISTINCT MRSC.SCHEDULE_DATE
, MRSC.RELIEF_QUANTITY
, MRSC.TRANSACTION_ID
, TO_NUMBER(DEMAND.DEMAND_SOURCE_LINE)
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
FROM SO_LINES_ALL SOLINE
, MTL_DEMAND_OMOE DEMAND
, MRP_SCHEDULE_DATES MRSD
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID
AND MRSC.RELIEF_TYPE = 1
AND DEMAND.DEMAND_SOURCE_HEADER_ID = MRSC.DISPOSITION_ID
AND DEMAND.USER_LINE_NUM = MRSC.LINE_NUM
AND SOLINE.LINE_ID = DEMAND.DEMAND_SOURCE_LINE
AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns