[Home] [Help] [Dependency Information]
Object Name: | FTE_VEHICLE_TYPES# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VEHICLE_TYPE_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
VEHICLE_CLASS_CODE | VARCHAR2 | (30) | ||
PALLET_FLOOR_SPACE | NUMBER | |||
PALLET_STACKING_HEIGHT | NUMBER | |||
EF_VOLUME_CAP_DIRECT | NUMBER | |||
EF_VOLUME_CAP_POOL | NUMBER | |||
EF_VOLUME_CAP_ONE_STOP | NUMBER | |||
EF_VOLUME_CAP_TWO_STOP | NUMBER | |||
EF_VOLUME_CAP_TWO_POOL | NUMBER | |||
EF_VOLUME_CAP_THREE_POOL | NUMBER | |||
USABLE_LENGTH | NUMBER | |||
USABLE_WIDTH | NUMBER | |||
USABLE_HEIGHT | NUMBER | |||
SUSPENSION_TYPE_CODE | VARCHAR2 | (30) | ||
TEMPERATURE_CONTROL_CODE | VARCHAR2 | (30) | ||
NUMBER_OF_DOORS | NUMBER | |||
DOOR_HEIGHT | NUMBER | |||
DOOR_WIDTH | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT VEHICLE_TYPE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, VEHICLE_CLASS_CODE
, PALLET_FLOOR_SPACE
, PALLET_STACKING_HEIGHT
, EF_VOLUME_CAP_DIRECT
, EF_VOLUME_CAP_POOL
, EF_VOLUME_CAP_ONE_STOP
, EF_VOLUME_CAP_TWO_STOP
, EF_VOLUME_CAP_TWO_POOL
, EF_VOLUME_CAP_THREE_POOL
, USABLE_LENGTH
, USABLE_WIDTH
, USABLE_HEIGHT
, SUSPENSION_TYPE_CODE
, TEMPERATURE_CONTROL_CODE
, NUMBER_OF_DOORS
, DOOR_HEIGHT
, DOOR_WIDTH
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FTE.FTE_VEHICLE_TYPES#;
|
|
|