DBA Data[Home] [Help]

VIEW: FTE.FTE_VEHICLE_TYPES#

Source

View Text - Preformatted

select VEHICLE_TYPE_ID VEHICLE_TYPE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, VEHICLE_CLASS_CODE VEHICLE_CLASS_CODE, PALLET_FLOOR_SPACE PALLET_FLOOR_SPACE, PALLET_STACKING_HEIGHT PALLET_STACKING_HEIGHT, EF_VOLUME_CAP_DIRECT EF_VOLUME_CAP_DIRECT, EF_VOLUME_CAP_POOL EF_VOLUME_CAP_POOL, EF_VOLUME_CAP_ONE_STOP EF_VOLUME_CAP_ONE_STOP, EF_VOLUME_CAP_TWO_STOP EF_VOLUME_CAP_TWO_STOP, EF_VOLUME_CAP_TWO_POOL EF_VOLUME_CAP_TWO_POOL, EF_VOLUME_CAP_THREE_POOL EF_VOLUME_CAP_THREE_POOL, USABLE_LENGTH USABLE_LENGTH, USABLE_WIDTH USABLE_WIDTH, USABLE_HEIGHT USABLE_HEIGHT, SUSPENSION_TYPE_CODE SUSPENSION_TYPE_CODE, TEMPERATURE_CONTROL_CODE TEMPERATURE_CONTROL_CODE, NUMBER_OF_DOORS NUMBER_OF_DOORS, DOOR_HEIGHT DOOR_HEIGHT, DOOR_WIDTH DOOR_WIDTH, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "FTE"."FTE_VEHICLE_TYPES"
View Text - HTML Formatted

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