[Home] [Help]
View: 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
Name |
CUSTOMER_ID |
CUSTOMER_SITE_ID |
SUPPLIER_ID |
SUPPLIER_SITE_ID |
INVENTORY_ITEM_ID |