[Home] [Help]
View: 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
Name |
SCHEDULE_DATE |
RELIEF_QUANTITY |
MDS_ENTRY_ID |
SALES_ORDER_LINE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |