DBA Data[Home] [Help]

APPS.FTE_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 407: FROM mtl_system_items_kfv mtl, fte_vehicle_types veh

403:
404: BEGIN
405: SELECT veh.vehicle_type_id
406: INTO l_veh_id
407: FROM mtl_system_items_kfv mtl, fte_vehicle_types veh
408: WHERE mtl.concatenated_segments = p_vehicle_type
409: AND mtl.inventory_item_id = veh.inventory_item_id
410: AND mtl.vehicle_item_flag = 'Y'
411: AND rownum = 1;

Line 418: FROM mtl_system_items_kfv mtl, fte_vehicle_types veh

414: WHEN NO_DATA_FOUND THEN
415: BEGIN
416: SELECT veh.vehicle_type_id
417: INTO l_veh_id
418: FROM mtl_system_items_kfv mtl, fte_vehicle_types veh
419: WHERE to_char(veh.vehicle_type_id) = p_vehicle_type
420: AND mtl.inventory_item_id = veh.inventory_item_id
421: AND mtl.vehicle_item_flag = 'Y'
422: AND rownum = 1;