APPS.FTE_VEHICLE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 267: FROM mtl_system_items_b_kfv item, fte_vehicle_types veh

263: -- Begin : Check whether the given Name already exists
264: BEGIN
265: /*
266: SELECT item.inventory_item_id INTO l_inventory_item_id
267: FROM mtl_system_items_b_kfv item, fte_vehicle_types veh
268: WHERE item.concatenated_segments = p_vehicle_type_name
269: AND item.inventory_item_id = veh.inventory_item_id
270: AND item.organization_id = veh.organization_id;
271:

Line 279: FROM mtl_system_items_b_kfv item

275: SELECT veh.inventory_item_id INTO l_inventory_item_id
276: FROM fte_vehicle_types veh
277: WHERE (veh.inventory_item_id, veh.organization_id) =
278: (SELECT item.inventory_item_id, item.organization_id
279: FROM mtl_system_items_b_kfv item
280: WHERE item.concatenated_segments = p_vehicle_type_name
281: AND rownum < 2);
282:
283: i := i+1;

Line 458: FROM mtl_system_items

454: IS
455:
456: CURSOR item_cur IS
457: SELECT inventory_item_id, organization_id
458: FROM mtl_system_items
459: WHERE organization_id in (SELECT distinct master_organization_id
460: FROM mtl_parameters)
461: AND vehicle_item_flag = 'Y'
462: AND inventory_item_id not in (SELECT inventory_item_id