1463: RETURN VARCHAR2
1464: IS
1465: CURSOR c_product_name IS
1466: SELECT padded_concatenated_segments
1467: FROM mtl_system_items_kfv
1468: WHERE inventory_item_id = p_prod_id
1469: AND organization_id = p_org_id;
1470:
1471: CURSOR c_product_name_all IS
1469: AND organization_id = p_org_id;
1470:
1471: CURSOR c_product_name_all IS
1472: SELECT DISTINCT padded_concatenated_segments
1473: FROM mtl_system_items_kfv
1474: WHERE inventory_item_id = p_prod_id;
1475:
1476: CURSOR c_category_name IS
1477: SELECT description