[Home] [Help]
View: MSC_LATE_ORDERS_MV_V
View Text
SELECT MD.PLAN_ID
, MD.ORGANIZATION_ID
, MD.SR_INSTANCE_ID
, MD.INVENTORY_ITEM_ID
, MD.PROJECT_ID
, MD.TASK_ID
, MED.DATE1
, MD.DEMAND_ID
FROM MSC_DEMANDS MD
, MSC_EXCEPTION_DETAILS MED
WHERE MED.NUMBER1 = MD.DEMAND_ID
AND MED.PLAN_ID = MD.PLAN_ID
AND MED.EXCEPTION_TYPE IN (13
, 14
, 24
, 26)
Columns
Name |
PLAN_ID |
ORGANIZATION_ID |
SR_INSTANCE_ID |
INVENTORY_ITEM_ID |
PROJECT_ID |
TASK_ID |
DATE1 |
DEMAND_ID |