[Home] [Help]
View: MSC_DEMANDS_MV_V
| Product: | MSC - Advanced Supply Chain Planning |
| Description: | |
| Implementation/DBA Data: |
APPS.MSC_DEMANDS_MV_V
|
View Text
SELECT DEMAND_ID
, PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, ASSEMBLY_DEMAND_COMP_DATE
, NVL(ASSEMBLY_DEMAND_COMP_DATE
, USING_ASSEMBLY_DEMAND_DATE)
, INVENTORY_ITEM_ID
, PROJECT_ID
, TASK_ID
FROM MSC_DEMANDS
WHERE ORIGINATION_TYPE IN (6
, 7
, 8
, 9
, 10
, 11
, 12
, 15
, 22
, 24
, 27
, 29
, 30)
Columns
| Name |
| DEMAND_ID |
| PLAN_ID |
| ORGANIZATION_ID |
| SR_INSTANCE_ID |
| ASSEMBLY_DEMAND_COMP_DATE |
| USING_ASSEMBLY_DEMAND_DATE |
| INVENTORY_ITEM_ID |
| PROJECT_ID |
| TASK_ID |