VIEW: APPS.MSC_SUP_DEM_TRANSACTIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)