[Home] [Help]
63: SELECT m.concatenated_segments
64: FROM mtl_system_items_vl m
65: WHERE m.inventory_item_id = p_vehicle_type_id
66: AND m.organization_id in ( select p.master_organization_id
67: from mtl_parameters p)
68: AND rownum = 1;
69:
70: -- Here vehicle type id considered as vehicle type id itself
71: -- This is used to get the Vehicle type as OUTPUT parameter only