VIEW: APPS.MST_FTE_VEHICLE_TYPES_V

Source

View Text - Preformatted

SELECT veh.VEHICLE_TYPE_ID VEHICLE_TYPE_ID ,veh.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,veh.ORGANIZATION_ID ORGANIZATION_ID ,veh.VEHICLE_CLASS_CODE VEHICLE_CLASS_CODE ,veh.PALLET_FLOOR_SPACE PALLET_FLOOR_SPACE ,veh.PALLET_STACKING_HEIGHT PALLET_STACKING_HEIGHT ,veh.EF_VOLUME_CAP_DIRECT EF_VOLUME_CAP_DIRECT ,veh.EF_VOLUME_CAP_POOL EF_VOLUME_CAP_POOL ,veh.EF_VOLUME_CAP_ONE_STOP EF_VOLUME_CAP_ONE_STOP ,veh.EF_VOLUME_CAP_TWO_STOP EF_VOLUME_CAP_TWO_STOP ,veh.EF_VOLUME_CAP_TWO_POOL EF_VOLUME_CAP_TWO_POOL ,veh.EF_VOLUME_CAP_THREE_POOL EF_VOLUME_CAP_THREE_POOL ,veh.USABLE_LENGTH USABLE_LENGTH ,veh.USABLE_WIDTH USABLE_WIDTH ,veh.USABLE_HEIGHT USABLE_HEIGHT ,veh.SUSPENSION_TYPE_CODE SUSPENSION_TYPE_CODE ,veh.TEMPERATURE_CONTROL_CODE TEMPERATURE_CONTROL_CODE ,veh.NUMBER_OF_DOORS NUMBER_OF_DOORS ,veh.DOOR_HEIGHT DOOR_HEIGHT ,veh.DOOR_WIDTH DOOR_WIDTH ,veh.CREATION_DATE CREATION_DATE ,veh.CREATED_BY CREATED_BY ,veh.LAST_UPDATE_DATE LAST_UPDATE_DATE ,veh.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from fte_vehicle_types veh

View Text - HTML Formatted

SELECT VEH.VEHICLE_TYPE_ID VEHICLE_TYPE_ID
, VEH.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VEH.ORGANIZATION_ID ORGANIZATION_ID
, VEH.VEHICLE_CLASS_CODE VEHICLE_CLASS_CODE
, VEH.PALLET_FLOOR_SPACE PALLET_FLOOR_SPACE
, VEH.PALLET_STACKING_HEIGHT PALLET_STACKING_HEIGHT
, VEH.EF_VOLUME_CAP_DIRECT EF_VOLUME_CAP_DIRECT
, VEH.EF_VOLUME_CAP_POOL EF_VOLUME_CAP_POOL
, VEH.EF_VOLUME_CAP_ONE_STOP EF_VOLUME_CAP_ONE_STOP
, VEH.EF_VOLUME_CAP_TWO_STOP EF_VOLUME_CAP_TWO_STOP
, VEH.EF_VOLUME_CAP_TWO_POOL EF_VOLUME_CAP_TWO_POOL
, VEH.EF_VOLUME_CAP_THREE_POOL EF_VOLUME_CAP_THREE_POOL
, VEH.USABLE_LENGTH USABLE_LENGTH
, VEH.USABLE_WIDTH USABLE_WIDTH
, VEH.USABLE_HEIGHT USABLE_HEIGHT
, VEH.SUSPENSION_TYPE_CODE SUSPENSION_TYPE_CODE
, VEH.TEMPERATURE_CONTROL_CODE TEMPERATURE_CONTROL_CODE
, VEH.NUMBER_OF_DOORS NUMBER_OF_DOORS
, VEH.DOOR_HEIGHT DOOR_HEIGHT
, VEH.DOOR_WIDTH DOOR_WIDTH
, VEH.CREATION_DATE CREATION_DATE
, VEH.CREATED_BY CREATED_BY
, VEH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, VEH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM FTE_VEHICLE_TYPES VEH