[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 |
APPS.MSC_LATE_ORDERS_MV_V