APPS.WSH_INBOUND_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 3180: FROM mtl_system_items

3176: --To get Primary UOM code for the given inventory item.
3177: CURSOR c_inventory_item_info(v_inventory_item_id number,
3178: v_organization_id number) is
3179: SELECT primary_uom_code
3180: FROM mtl_system_items
3181: WHERE inventory_item_id = v_inventory_item_id
3182: AND organization_id = v_organization_id;
3183:
3184: l_return_status VARCHAR2(1);

Line 3227: --If the primary UOM is not passed to this API.Then find it in mtl_system_items table.

3223: return;
3224: END IF;
3225: END IF;
3226:
3227: --If the primary UOM is not passed to this API.Then find it in mtl_system_items table.
3228: IF (p_inv_item_id IS NOT NULL ) AND (p_primary_uom_code IS NULL) THEN
3229: OPEN c_inventory_item_info(p_inv_item_id,p_organization_id);
3230: FETCH c_inventory_item_info INTO p_primary_uom_code;
3231: CLOSE c_inventory_item_info;