[Home] [Help] [Dependency Information]
Object Name: | WSH_CARRIERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_CARRIERS_V |
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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CARRIER_ID | NUMBER | (15) | Yes | |
SCAC_CODE | VARCHAR2 | (4) | ||
FREIGHT_CODE | VARCHAR2 | (30) | Yes | |
MANIFESTING_ENABLED_FLAG | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CARRIER_NAME | VARCHAR2 | (360) | Yes | |
ACTIVE | VARCHAR2 | (1) | ||
PARTY_USG_ASSIGNMENT_ID | NUMBER | (15) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (38) | ||
MAX_NUM_STOPS_PERMITTED | NUMBER | |||
MAX_TOTAL_DISTANCE | NUMBER | |||
MAX_TOTAL_TIME | NUMBER | |||
ALLOW_INTERSPERSE_LOAD | VARCHAR2 | (1) | ||
MAX_LAYOVER_TIME | NUMBER | |||
MIN_LAYOVER_TIME | NUMBER | |||
MAX_TOTAL_DISTANCE_IN_24HR | NUMBER | |||
MAX_DRIVING_TIME_IN_24HR | NUMBER | |||
MAX_DUTY_TIME_IN_24HR | NUMBER | |||
ALLOW_CONTINUOUS_MOVE | VARCHAR2 | (1) | ||
MAX_CM_DISTANCE | NUMBER | |||
MAX_CM_TIME | NUMBER | |||
MAX_CM_DH_DISTANCE | NUMBER | |||
MAX_CM_DH_TIME | NUMBER | |||
MAX_SIZE_WIDTH | NUMBER | |||
MAX_SIZE_HEIGHT | NUMBER | |||
MAX_SIZE_LENGTH | NUMBER | |||
MIN_SIZE_WIDTH | NUMBER | |||
MIN_SIZE_HEIGHT | NUMBER | |||
MIN_SIZE_LENGTH | NUMBER | |||
TIME_UOM | VARCHAR2 | (10) | ||
DIMENSION_UOM | VARCHAR2 | (3) | ||
DISTANCE_UOM | VARCHAR2 | (3) | ||
MAX_OUT_OF_ROUTE | NUMBER | |||
CM_FREE_DH_MILEAGE | NUMBER | |||
MIN_CM_DISTANCE | NUMBER | |||
CM_FIRST_LOAD_DISCOUNT | VARCHAR2 | (1) | ||
MIN_CM_TIME | NUMBER | |||
UNIT_RATE_BASIS | VARCHAR2 | (30) | ||
WEIGHT_UOM | VARCHAR2 | (3) | ||
VOLUME_UOM | VARCHAR2 | (3) | ||
GENERIC_FLAG | VARCHAR2 | (1) | ||
FREIGHT_BILL_AUTO_APPROVAL | VARCHAR2 | (1) | ||
FREIGHT_AUDIT_LINE_LEVEL | VARCHAR2 | (1) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
CM_RATE_VARIANT | VARCHAR2 | (30) | ||
DISTANCE_CALCULATION_METHOD | VARCHAR2 | (30) | ||
ORIGIN_DSTN_SURCHARGE_LEVEL | VARCHAR2 | (30) | ||
DIM_DIMENSIONAL_FACTOR | NUMBER | |||
DIM_WEIGHT_UOM | VARCHAR2 | (3) | ||
DIM_VOLUME_UOM | VARCHAR2 | (3) | ||
DIM_DIMENSION_UOM | VARCHAR2 | (3) | ||
DIM_MIN_PACK_VOL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CARRIER_ID
, SCAC_CODE
, FREIGHT_CODE
, MANIFESTING_ENABLED_FLAG
, CURRENCY_CODE
, CARRIER_NAME
, ACTIVE
, PARTY_USG_ASSIGNMENT_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, MAX_NUM_STOPS_PERMITTED
, MAX_TOTAL_DISTANCE
, MAX_TOTAL_TIME
, ALLOW_INTERSPERSE_LOAD
, MAX_LAYOVER_TIME
, MIN_LAYOVER_TIME
, MAX_TOTAL_DISTANCE_IN_24HR
, MAX_DRIVING_TIME_IN_24HR
, MAX_DUTY_TIME_IN_24HR
, ALLOW_CONTINUOUS_MOVE
, MAX_CM_DISTANCE
, MAX_CM_TIME
, MAX_CM_DH_DISTANCE
, MAX_CM_DH_TIME
, MAX_SIZE_WIDTH
, MAX_SIZE_HEIGHT
, MAX_SIZE_LENGTH
, MIN_SIZE_WIDTH
, MIN_SIZE_HEIGHT
, MIN_SIZE_LENGTH
, TIME_UOM
, DIMENSION_UOM
, DISTANCE_UOM
, MAX_OUT_OF_ROUTE
, CM_FREE_DH_MILEAGE
, MIN_CM_DISTANCE
, CM_FIRST_LOAD_DISCOUNT
, MIN_CM_TIME
, UNIT_RATE_BASIS
, WEIGHT_UOM
, VOLUME_UOM
, GENERIC_FLAG
, FREIGHT_BILL_AUTO_APPROVAL
, FREIGHT_AUDIT_LINE_LEVEL
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, CM_RATE_VARIANT
, DISTANCE_CALCULATION_METHOD
, ORIGIN_DSTN_SURCHARGE_LEVEL
, DIM_DIMENSIONAL_FACTOR
, DIM_WEIGHT_UOM
, DIM_VOLUME_UOM
, DIM_DIMENSION_UOM
, DIM_MIN_PACK_VOL
FROM APPS.WSH_CARRIERS_V;
|
|
|