[Home] [Help]
View: MSC_MONTHLY_SUPDEM_SUM_V
Product: | MSC - Advanced Supply Chain Planning |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SD.PLAN_ID
, SD.CUSTOMER_SITE_ID
, SD.SUPPLIER_SITE_ID
, SD.CUSTOMER_ITEM_ID
, SD.SUPPLIER_ITEM_ID
, SD.MONTHYEAR
, SUM(SD.QUANTITY) QUANTITY
FROM MSC_MONTHLY_SUPPLY_DEMAND_V SD GROUP BY SD.PLAN_ID
, SD.CUSTOMER_SITE_ID
, SD.SUPPLIER_SITE_ID
, SD.CUSTOMER_ITEM_ID
, SD.SUPPLIER_ITEM_ID
, SD.MONTHYEAR
Columns
Name |
PLAN_ID |
CUSTOMER_SITE_ID |
SUPPLIER_SITE_ID |
CUSTOMER_ITEM_ID |
SUPPLIER_ITEM_ID |
MONTHYEAR |
QUANTITY |