DBA Data[Home] [Help]

APPS.FTE_ESTIMATE_FREIGHT_RATE dependencies on MTL_SYSTEM_ITEMS_VL

Line 64: FROM mtl_system_items_vl m

60: -- Here vehicle type id considered as inv item id
61: -- This is used to get the Vehicle type as INPUT parameter only
62: cursor c_get_vehicle_name(p_vehicle_type_id number) is
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;