[Home] [Help] [Dependency Information]
Object Name: | FTE_VEHICLE_TYPES |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_VEHICLE_TYPES |
Subobject Name: | |
Status: | VALID |
stores the attributes of Vehicle Type. Inventory Item related attributes are saved in MTL_SYSTEM_ITEMS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_VEHICLE_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | VEHICLE_TYPE_ID |
FTE_VEHICLE_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VEHICLE_TYPE_ID | NUMBER | Yes | Primary key of the table created from the sequence FTE_VEHICLE_TYPES_S | |
INVENTORY_ITEM_ID | NUMBER | Yes | ID of the corresponding inventory item(MTL_SYSTEM_ITEMS) | |
ORGANIZATION_ID | NUMBER | Yes | Organization ID of the corresponding inventory item(MTL_SYSTEM_ITEMS) | |
VEHICLE_CLASS_CODE | VARCHAR2 | (30) | Classification of the Vehicle Type | |
PALLET_FLOOR_SPACE | NUMBER | Number of Pallets that can be placed on the Vehicle Floor | ||
PALLET_STACKING_HEIGHT | NUMBER | Number of Pallets that can be stacked vertically in the Vehicle | ||
EF_VOLUME_CAP_DIRECT | NUMBER | Effective Volume Capacity(Direct Move) | ||
EF_VOLUME_CAP_POOL | NUMBER | Effective Volume Capacity(Pool Move) | ||
EF_VOLUME_CAP_ONE_STOP | NUMBER | Effective Volume Capacity(One-Stop Move) | ||
EF_VOLUME_CAP_TWO_STOP | NUMBER | Effective Volume Capacity(Two-Stop Move) | ||
EF_VOLUME_CAP_TWO_POOL | NUMBER | Effective Volume Capacity(Two-Pool Move) | ||
EF_VOLUME_CAP_THREE_POOL | NUMBER | Effective Volume Capacity(Three-Pool Move) | ||
USABLE_LENGTH | NUMBER | Interior(Usable) Length | ||
USABLE_WIDTH | NUMBER | Interior(Usable) Width | ||
USABLE_HEIGHT | NUMBER | Interior(Usable) Height | ||
SUSPENSION_TYPE_CODE | VARCHAR2 | (30) | Suspension Type | |
TEMPERATURE_CONTROL_CODE | VARCHAR2 | (30) | Temperature Control | |
NUMBER_OF_DOORS | NUMBER | Total Number of Doors | ||
DOOR_HEIGHT | NUMBER | Height of the Largest Door | ||
DOOR_WIDTH | NUMBER | Width of the Largest Door | ||
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | User Id who created the vehicle type | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | User Id who updated the vehicle type | |
LAST_UPDATE_LOGIN | NUMBER | Login Id who updated the vehicle type |
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;
FTE.FTE_VEHICLE_TYPES does not reference any database object
FTE.FTE_VEHICLE_TYPES is referenced by following:
|
|
|