View: MSC_SUP_DEM_TRANSACTIONS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SUP_DEM_TRANSACTIONS_V

View Text

SELECT DISTINCT PUBLISHER_ID CUSTOMER_ID
, PUBLISHER_SITE_ID CUSTOMER_SITE_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, INVENTORY_ITEM_ID
FROM MSC_SUP_DEM_ENTRIES_UI_V
WHERE PLAN_ID = -1
AND PUBLISHER_ORDER_TYPE IN (9
, 13
, 16
, 19
, 20) UNION SELECT DISTINCT CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, PUBLISHER_ID SUPPLIER_ID
, PUBLISHER_SITE_ID SUPPLIER_SITE_ID
, INVENTORY_ITEM_ID
FROM MSC_SUP_DEM_ENTRIES_UI_V
WHERE PLAN_ID = -1
AND PUBLISHER_ORDER_TYPE IN (15)

Columns