ASCP SUPPLY & DEMAND WORKBENCH SQL
ASCP SUPPLY DEMAND WORKBENCH with Supply, Excess Supply & Demand and PEGGING DETAILS mapped against the supply SET SQLBLANKLINES ON WITH params AS ( SELECT 123 AS plan_id, 101 AS organization_id, trunc(sysdate) AS from_date, trunc(sysdate)+30 AS to_date FROM dual ), item_categories AS ( SELECT mic.inventory_item_id, mic.organization_id, mic.sr_instance_id, MAX(CASE WHEN mcs.category_set_name = 'Planning Hierarchy' THEN mic.category_name END) AS planning_sub_family, MAX(CASE WHEN mcs.category_set_name = 'Product Hierarchy' THEN mic.category_name END) AS product_line...