DBA Data[Home] [Help]

APPS.MSC_X_PLANNING dependencies on MSC_SUP_DEM_ENTRIES

Line 109: FROM msc_sup_dem_entries sd

105: , p_supplier_site_id NUMBER
106: , p_horizon_end_date DATE
107: ) IS
108: SELECT SUM(sd.primary_quantity) total_demand
109: FROM msc_sup_dem_entries sd
110: WHERE sd.plan_id = p_plan_id
111: AND sd.inventory_item_id = p_inventory_item_id
112: AND sd.customer_site_id = p_organization_id
113: -- AND sd.sr_instance_id = p_sr_instance_id