VIEW: WSH.WSH_CARRIER_SERVICES#

Source

View Text - Preformatted

select CARRIER_SERVICE_ID CARRIER_SERVICE_ID, CARRIER_ID CARRIER_ID, SERVICE_LEVEL SERVICE_LEVEL, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, SL_TIME_UOM SL_TIME_UOM, MIN_SL_TIME MIN_SL_TIME, MAX_SL_TIME MAX_SL_TIME, ENABLED_FLAG ENABLED_FLAG, WEB_ENABLED WEB_ENABLED, SHIP_METHOD_CODE SHIP_METHOD_CODE, SHIP_METHOD_MEANING SHIP_METHOD_MEANING, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, MAX_NUM_STOPS_PERMITTED MAX_NUM_STOPS_PERMITTED, MAX_TOTAL_TIME MAX_TOTAL_TIME, MAX_TOTAL_DISTANCE MAX_TOTAL_DISTANCE, ALLOW_INTERSPERSE_LOAD ALLOW_INTERSPERSE_LOAD, MIN_LAYOVER_TIME MIN_LAYOVER_TIME, MAX_LAYOVER_TIME MAX_LAYOVER_TIME, MAX_TOTAL_DISTANCE_IN_24HR MAX_TOTAL_DISTANCE_IN_24HR, MAX_DRIVING_TIME_IN_24HR MAX_DRIVING_TIME_IN_24HR, MAX_DUTY_TIME_IN_24HR MAX_DUTY_TIME_IN_24HR, ALLOW_CONTINUOUS_MOVE ALLOW_CONTINUOUS_MOVE, MAX_CM_DISTANCE MAX_CM_DISTANCE, MAX_CM_TIME MAX_CM_TIME, MAX_CM_DH_DISTANCE MAX_CM_DH_DISTANCE, MAX_CM_DH_TIME MAX_CM_DH_TIME, MIN_CM_DISTANCE MIN_CM_DISTANCE, MIN_CM_TIME MIN_CM_TIME, CM_FREE_DH_MILEAGE CM_FREE_DH_MILEAGE, CM_FIRST_LOAD_DISCOUNT CM_FIRST_LOAD_DISCOUNT, CM_RATE_VARIANT CM_RATE_VARIANT, MAX_SIZE_WIDTH MAX_SIZE_WIDTH, MAX_SIZE_HEIGHT MAX_SIZE_HEIGHT, MAX_SIZE_LENGTH MAX_SIZE_LENGTH, MIN_SIZE_WIDTH MIN_SIZE_WIDTH, MIN_SIZE_HEIGHT MIN_SIZE_HEIGHT, MIN_SIZE_LENGTH MIN_SIZE_LENGTH, MAX_OUT_OF_ROUTE MAX_OUT_OF_ROUTE, DISTANCE_CALCULATION_METHOD DISTANCE_CALCULATION_METHOD, ORIGIN_DSTN_SURCHARGE_LEVEL ORIGIN_DSTN_SURCHARGE_LEVEL, UNIT_RATE_BASIS UNIT_RATE_BASIS, DIM_DIMENSIONAL_FACTOR DIM_DIMENSIONAL_FACTOR, DIM_WEIGHT_UOM DIM_WEIGHT_UOM, DIM_VOLUME_UOM DIM_VOLUME_UOM, DIM_DIMENSION_UOM DIM_DIMENSION_UOM, DIM_MIN_PACK_VOL DIM_MIN_PACK_VOL, DEFAULT_VEHICLE_TYPE_ID DEFAULT_VEHICLE_TYPE_ID, UPDATE_MOT_SL UPDATE_MOT_SL from "WSH"."WSH_CARRIER_SERVICES"

View Text - HTML Formatted

SELECT CARRIER_SERVICE_ID CARRIER_SERVICE_ID
, CARRIER_ID CARRIER_ID
, SERVICE_LEVEL SERVICE_LEVEL
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, SL_TIME_UOM SL_TIME_UOM
, MIN_SL_TIME MIN_SL_TIME
, MAX_SL_TIME MAX_SL_TIME
, ENABLED_FLAG ENABLED_FLAG
, WEB_ENABLED WEB_ENABLED
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, SHIP_METHOD_MEANING SHIP_METHOD_MEANING
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, MAX_NUM_STOPS_PERMITTED MAX_NUM_STOPS_PERMITTED
, MAX_TOTAL_TIME MAX_TOTAL_TIME
, MAX_TOTAL_DISTANCE MAX_TOTAL_DISTANCE
, ALLOW_INTERSPERSE_LOAD ALLOW_INTERSPERSE_LOAD
, MIN_LAYOVER_TIME MIN_LAYOVER_TIME
, MAX_LAYOVER_TIME MAX_LAYOVER_TIME
, MAX_TOTAL_DISTANCE_IN_24HR MAX_TOTAL_DISTANCE_IN_24HR
, MAX_DRIVING_TIME_IN_24HR MAX_DRIVING_TIME_IN_24HR
, MAX_DUTY_TIME_IN_24HR MAX_DUTY_TIME_IN_24HR
, ALLOW_CONTINUOUS_MOVE ALLOW_CONTINUOUS_MOVE
, MAX_CM_DISTANCE MAX_CM_DISTANCE
, MAX_CM_TIME MAX_CM_TIME
, MAX_CM_DH_DISTANCE MAX_CM_DH_DISTANCE
, MAX_CM_DH_TIME MAX_CM_DH_TIME
, MIN_CM_DISTANCE MIN_CM_DISTANCE
, MIN_CM_TIME MIN_CM_TIME
, CM_FREE_DH_MILEAGE CM_FREE_DH_MILEAGE
, CM_FIRST_LOAD_DISCOUNT CM_FIRST_LOAD_DISCOUNT
, CM_RATE_VARIANT CM_RATE_VARIANT
, MAX_SIZE_WIDTH MAX_SIZE_WIDTH
, MAX_SIZE_HEIGHT MAX_SIZE_HEIGHT
, MAX_SIZE_LENGTH MAX_SIZE_LENGTH
, MIN_SIZE_WIDTH MIN_SIZE_WIDTH
, MIN_SIZE_HEIGHT MIN_SIZE_HEIGHT
, MIN_SIZE_LENGTH MIN_SIZE_LENGTH
, MAX_OUT_OF_ROUTE MAX_OUT_OF_ROUTE
, DISTANCE_CALCULATION_METHOD DISTANCE_CALCULATION_METHOD
, ORIGIN_DSTN_SURCHARGE_LEVEL ORIGIN_DSTN_SURCHARGE_LEVEL
, UNIT_RATE_BASIS UNIT_RATE_BASIS
, DIM_DIMENSIONAL_FACTOR DIM_DIMENSIONAL_FACTOR
, DIM_WEIGHT_UOM DIM_WEIGHT_UOM
, DIM_VOLUME_UOM DIM_VOLUME_UOM
, DIM_DIMENSION_UOM DIM_DIMENSION_UOM
, DIM_MIN_PACK_VOL DIM_MIN_PACK_VOL
, DEFAULT_VEHICLE_TYPE_ID DEFAULT_VEHICLE_TYPE_ID
, UPDATE_MOT_SL UPDATE_MOT_SL
FROM "WSH"."WSH_CARRIER_SERVICES"