APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2177: FROM mtl_item_sub_inventories

2173: FOR rsc IN d_wrhs_subinv_cur(esc.source_organization_id) LOOP
2174: BEGIN
2175: SELECT inventory_planning_code
2176: INTO l_sub_minmax_flag
2177: FROM mtl_item_sub_inventories
2178: WHERE organization_id = esc.source_organization_id
2179: AND secondary_inventory = rsc.secondary_inventory_name
2180: AND inventory_item_id = p_item_rec.inventory_item_id;
2181: EXCEPTION