eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSC_NETTED_SUPPLY_DEMAND_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SD.PLAN_ID
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.PUBLISHER_ORG_ID
, 7
, SD.PUBLISHER_ORG_ID
, SD.SUBSCRIBER_ORG_ID) CUSTOMER
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.SUBSCRIBER_ORG_ID
, 7
, SD.SUBSCRIBER_ORG_ID
, SD.PUBLISHER_ORG_ID) SUPPLIER
, NVL(SD.EXCHANGE_ITEM_ID
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.INVENTORY_ITEM_ID
, 7
, SD.INVENTORY_ITEM_ID
, CS.REF_ITEM_ID)) ITEM
, SUM((DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.QUANTITY
, 7
, SD.QUANTITY
, 0))-(DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, 0
, 7
, 0
, SD.QUANTITY)))
, BU.BUCKET_INDEX
FROM MSC_SUP_DEM_ENTRIES SD
, MSC_PLAN_BUCKETS BU
, MSC_ITEM_CROSS_REFS_V CS
WHERE SD.PLAN_ID = BU.PLAN_ID
AND SD.START_DATE >= BU.BKT_START_DATE
AND SD.END_DATE <= NVL(BU.BKT_END_DATE
, BU.BKT_START_DATE + 1)
AND CS.ITEM_ID = SD.INVENTORY_ITEM_ID
AND CS.PARTY_ID = SD.PUBLISHER_ORG_ID
AND CS.REF_PARTY_ID = SD.SUBSCRIBER_ORG_ID
AND SD.SR_INSTANCE_ID = -1
AND SD.PUBLISHER_ORDER_TYPE IN (6
, 7
, 33
, 35
, 36
, 37
, 38
, 39
, 44) GROUP BY SD.PLAN_ID
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.PUBLISHER_ORG_ID
, 7
, SD.PUBLISHER_ORG_ID
, SD.SUBSCRIBER_ORG_ID)
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.SUBSCRIBER_ORG_ID
, 7
, SD.SUBSCRIBER_ORG_ID
, SD.PUBLISHER_ORG_ID)
, NVL(SD.EXCHANGE_ITEM_ID
, DECODE(SD.PUBLISHER_ORDER_TYPE
, 6
, SD.INVENTORY_ITEM_ID
, 7
, SD.INVENTORY_ITEM_ID
, CS.REF_ITEM_ID))
, BU.BUCKET_INDEX

Columns

Name
PLAN_ID
CUSTOMER_SITE_ID
SUPPLIER_SITE_ID
CUSTOMER_ITEM_ID
QUANTITY
BUCKET_NUMBER