[Home] [Help] [Dependency Information]
Object Name: | MST_FTE_VEHICLE_TYPES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VEHICLE_TYPE_ID | NUMBER | Yes | primary key | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item ID | |
ORGANIZATION_ID | NUMBER | Yes | item organization this vehicle type belongs to | |
VEHICLE_CLASS_CODE | VARCHAR2 | (30) | truck,tractor,chassis, trailer,shipment container | |
PALLET_FLOOR_SPACE | NUMBER | number of pallets comes in one layer | ||
PALLET_STACKING_HEIGHT | NUMBER | upto what height pallets can be stacked | ||
EF_VOLUME_CAP_DIRECT | NUMBER | direct move effective volume | ||
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 | usable interior length | ||
USABLE_WIDTH | NUMBER | usable interior width | ||
USABLE_HEIGHT | NUMBER | usable interior height | ||
SUSPENSION_TYPE_CODE | VARCHAR2 | (30) | suspension type code | |
TEMPERATURE_CONTROL_CODE | VARCHAR2 | (30) | freeze, chill, none, insulated | |
NUMBER_OF_DOORS | NUMBER | number of doors | ||
DOOR_HEIGHT | NUMBER | height of the door | ||
DOOR_WIDTH | NUMBER | width of the door | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
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_UPDATE_LOGIN
FROM APPS.MST_FTE_VEHICLE_TYPES_V;
APPS.MST_FTE_VEHICLE_TYPES_V is not referenced by any database object
|
|
|