eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_VEHICLE_PKG dependencies on FTE_VEHICLE_TYPES

Line 127: -- 1) Insert/Update FTE_VEHICLE_TYPES

123: END VALIDATE_VEHICLE_TYPE;
124:
125: -- Procecure : CREATE_UPDATE_VEHICLE_TYPE (public API)
126: -- Purpose : Create or update a Vehicle Type
127: -- 1) Insert/Update FTE_VEHICLE_TYPES
128: -- 2) Insert/Update/Delete FTE_VEHICLE_FEATURES
129: -- 3) Call INV_ITEM_GRP.CREATE_ITEM/UPDATE_ITEM
130: -- to create/update an inventory master item
131:

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 273: -- to avoid INDEX FULL SCAN on FTE_VEHICLE_TYPES_U1

269: AND item.inventory_item_id = veh.inventory_item_id
270: AND item.organization_id = veh.organization_id;
271:
272: -- This query is changed as follows
273: -- to avoid INDEX FULL SCAN on FTE_VEHICLE_TYPES_U1
274: */
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) =

Line 276: FROM fte_vehicle_types veh

272: -- This query is changed as follows
273: -- to avoid INDEX FULL SCAN on FTE_VEHICLE_TYPES_U1
274: */
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

Line 317: INSERT INTO FTE_VEHICLE_TYPES

313: END IF;
314:
315: if (x_return_status = 'S')
316: then
317: INSERT INTO FTE_VEHICLE_TYPES
318: (VEHICLE_TYPE_ID, INVENTORY_ITEM_ID,
319: ORGANIZATION_ID, VEHICLE_CLASS_CODE,
320: PALLET_FLOOR_SPACE, PALLET_STACKING_HEIGHT,
321: EF_VOLUME_CAP_DIRECT, EF_VOLUME_CAP_POOL,

Line 329: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, savedItem.INVENTORY_ITEM_ID,

325: SUSPENSION_TYPE_CODE, TEMPERATURE_CONTROL_CODE,
326: NUMBER_OF_DOORS, DOOR_HEIGHT, DOOR_WIDTH,
327: CREATION_DATE, CREATED_BY,
328: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
329: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, savedItem.INVENTORY_ITEM_ID,
330: newItem.ORGANIZATION_ID, p_vehicle_class_code,
331: p_pallet_floor_space, p_pallet_stacking_height,
332: p_ef_volume_cap_direct, p_ef_volume_cap_pool,
333: p_ef_volume_cap_one_stop, p_ef_volume_cap_two_stop,

Line 377: UPDATE FTE_VEHICLE_TYPES

373: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterUpdate-'||x_return_status);
374: END IF;
375: if (x_return_status = 'S')
376: then
377: UPDATE FTE_VEHICLE_TYPES
378: SET VEHICLE_CLASS_CODE = p_vehicle_class_code,
379: PALLET_FLOOR_SPACE = p_pallet_floor_space,
380: PALLET_STACKING_HEIGHT = p_pallet_stacking_height,
381: EF_VOLUME_CAP_DIRECT = p_ef_volume_cap_direct,

Line 463: FROM fte_vehicle_types);

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
463: FROM fte_vehicle_types);
464: BEGIN
465:
466: FOR item_cur_rec IN item_cur
467: LOOP

Line 468: INSERT INTO FTE_VEHICLE_TYPES

464: BEGIN
465:
466: FOR item_cur_rec IN item_cur
467: LOOP
468: INSERT INTO FTE_VEHICLE_TYPES
469: (VEHICLE_TYPE_ID, INVENTORY_ITEM_ID,
470: ORGANIZATION_ID, CREATION_DATE, CREATED_BY,
471: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
472: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, item_cur_rec.inventory_item_id,

Line 472: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, item_cur_rec.inventory_item_id,

468: INSERT INTO FTE_VEHICLE_TYPES
469: (VEHICLE_TYPE_ID, INVENTORY_ITEM_ID,
470: ORGANIZATION_ID, CREATION_DATE, CREATED_BY,
471: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
472: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, item_cur_rec.inventory_item_id,
473: item_cur_rec.organization_id, SYSDATE, FND_GLOBAL.USER_ID,
474: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
475: END LOOP;
476:

Line 490: FROM fte_vehicle_types

486: x_vehicle_type_id NUMBER;
487: BEGIN
488:
489: SELECT vehicle_type_id INTO x_vehicle_type_id
490: FROM fte_vehicle_types
491: WHERE inventory_item_id = p_inventory_item_id;
492:
493: return x_vehicle_type_id;
494:

Line 504: -- from fte_vehicle_types

500: END GET_VEHICLE_TYPE_ID;
501:
502: -- Function : get_vehicle_org_id
503: -- Purpose : Get the vehicle org id for a given inventory item id
504: -- from fte_vehicle_types
505:
506: FUNCTION GET_VEHICLE_ORG_ID
507: ( p_inventory_item_id IN NUMBER ) RETURN NUMBER
508: IS

Line 513: FROM fte_vehicle_types

509: x_vehicle_org_id NUMBER;
510:
511: CURSOR c_get_veh_org IS
512: SELECT organization_id
513: FROM fte_vehicle_types
514: WHERE inventory_item_id = p_inventory_item_id
515: AND rownum=1;
516:
517: BEGIN