DBA Data[Home] [Help]

APPS.WMS_UT_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 2557: UPDATE mtl_secondary_inventories

2553: AND lot_number = l_obj
2554: AND inventory_item_id = l_item_id;
2555: ELSIF l_obj_type = 'SUB' THEN
2556: print_debug('Setting status of SUB ' || l_obj || ' to ' || p_params(3));
2557: UPDATE mtl_secondary_inventories
2558: SET status_id = l_status_id
2559: WHERE organization_id = p_org_id
2560: AND secondary_inventory_name = l_obj;
2561: ELSIF l_obj_type = 'LOC' THEN

Line 2563: UPDATE mtl_secondary_inventories

2559: WHERE organization_id = p_org_id
2560: AND secondary_inventory_name = l_obj;
2561: ELSIF l_obj_type = 'LOC' THEN
2562: print_debug('Setting status of SUB ' || l_obj || ' to ' || p_params(3));
2563: UPDATE mtl_secondary_inventories
2564: SET status_id = l_status_id
2565: WHERE organization_id = p_org_id
2566: AND secondary_inventory_name = l_obj;
2567: ELSIF l_obj_type = 'SER' THEN