[Home] [Help]
3054: ELSIF (p_item_number is not null) THEN
3055: BEGIN
3056: SELECT inventory_item_id
3057: INTO x_prod_attr_value
3058: FROM mtl_system_items_vl
3059: WHERE concatenated_segments = p_item_number
3060: AND organization_id = p_org_id;
3061: EXCEPTION
3062: WHEN NO_DATA_FOUND THEN