APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2180: FROM mtl_item_sub_inventories

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