APPS.MST_WB_UTIL dependencies on FTE_VEHICLE_TYPES

Line 854: FTE_VEHICLE_TYPES FVT

850: CURSOR CUR_VEH_WT_CAPACITY(pp_plan_id IN NUMBER,
851: pp_vehicle_type_id IN NUMBER) IS
852: SELECT MSI.Maximum_Load_Weight
853: FROM MTL_SYSTEM_ITEMS MSI,
854: FTE_VEHICLE_TYPES FVT
855: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
856: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
857: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
858:

Line 865: FTE_VEHICLE_TYPES FVT

861: SELECT (FVT.USABLE_LENGTH *
862: FVT.USABLE_WIDTH *
863: FVT.USABLE_HEIGHT) USABLE_VOLUME
864: FROM MTL_SYSTEM_ITEMS MSI,
865: FTE_VEHICLE_TYPES FVT
866: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
867: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
868: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
869:

Line 875: FTE_VEHICLE_TYPES FVT

871: pp_vehicle_type_id IN NUMBER) IS
872: SELECT (FVT.PALLET_FLOOR_SPACE *
873: FVT.PALLET_STACKING_HEIGHT ) Pallets
874: FROM MTL_SYSTEM_ITEMS MSI,
875: FTE_VEHICLE_TYPES FVT
876: WHERE FVT.VEHICLE_TYPE_ID = pp_vehicle_type_id
877: AND MSI.INVENTORY_ITEM_ID = FVT.INVENTORY_ITEM_ID
878: AND MSI.ORGANIZATION_ID = FVT.ORGANIZATION_ID;
879:

Line 1563: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt

1559: fnd_message.set_token('ITEM_DESCRIPTION', l_temp1);
1560: -- vehicle_type
1561: SELECT msikfv.concatenated_segments
1562: into l_temp
1563: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
1564: WHERE fvt.vehicle_type_id = l_id2
1565: AND fvt.organization_id = msikfv.organization_id
1566: AND fvt.inventory_item_id = msikfv.inventory_item_id;
1567: fnd_message.set_token('VEHICLE_TYPE', l_temp);

Line 2169: fte_vehicle_types fvt

2165: msikfv.organization_id,
2166: msikfv.inventory_item_id)
2167: INTO l_id1
2168: FROM mtl_system_items_kfv msikfv,
2169: fte_vehicle_types fvt
2170: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
2171: AND msikfv.organization_id = fvt.organization_id
2172: AND fvt.vehicle_type_id = l_id8;
2173:

Line 4448: fte_vehicle_types fvt

4444:
4445: CURSOR l_vehicle_cur (p_vehicle_type_id IN NUMBER) IS
4446: SELECT msikfv.concatenated_segments
4447: FROM mtl_system_items_kfv msikfv,
4448: fte_vehicle_types fvt
4449: WHERE fvt.vehicle_type_id = p_vehicle_type_id
4450: AND fvt.organization_id = msikfv.organization_id
4451: AND fvt.inventory_item_id = msikfv.inventory_item_id;
4452: l_uom l_uom_cur%ROWTYPE;

Line 5233: fte_vehicle_types fvt

5229: msikfv.organization_id,
5230: msikfv.inventory_item_id)
5231: INTO l_id9
5232: FROM mtl_system_items_kfv msikfv,
5233: fte_vehicle_types fvt
5234: WHERE msikfv.inventory_item_id = fvt.inventory_item_id
5235: AND msikfv.organization_id = fvt.organization_id
5236: AND fvt.vehicle_type_id = l_id8;
5237:

Line 5370: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt

5366: fnd_message.set_token('ITEM_DESCRIPTION', l_str1);
5367:
5368: SELECT msikfv.concatenated_segments
5369: into l_str2
5370: FROM mtl_system_items_kfv msikfv, fte_vehicle_types fvt
5371: WHERE fvt.vehicle_type_id = l_id3
5372: AND fvt.organization_id = msikfv.organization_id
5373: AND fvt.inventory_item_id = msikfv.inventory_item_id;
5374: fnd_message.set_token('VEHICLE_TYPE', l_str2);