APPS.FTE_ESTIMATE_FREIGHT_RATE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 74: from mtl_system_items_kfv mtl, fte_vehicle_types veh

70: -- Here vehicle type id considered as vehicle type id itself
71: -- This is used to get the Vehicle type as OUTPUT parameter only
72: cursor c_get_vehicle_type_name(l_vehicle_type_id number) is
73: select mtl.concatenated_segments VehicleName
74: from mtl_system_items_kfv mtl, fte_vehicle_types veh
75: where mtl.vehicle_item_flag = 'Y'
76: and mtl.inventory_item_id = veh.inventory_item_id
77: and veh.vehicle_type_id = l_vehicle_type_id
78: and rownum=1;