View: WSH_CARRIER_SERVICES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_CARRIER_SERVICES_V

View Text

SELECT WCS.ROWID
, WCS.CARRIER_SERVICE_ID
, WCS.CARRIER_ID
, WCS.SERVICE_LEVEL
, WCS.MODE_OF_TRANSPORT
, WCS.SL_TIME_UOM
, WCS.MIN_SL_TIME
, WCS.MAX_SL_TIME
, WCS.ENABLED_FLAG
, WCS.WEB_ENABLED
, WCS.SHIP_METHOD_CODE
, FL.MEANING SHIP_METHOD_MEANING
, WCS.ATTRIBUTE_CATEGORY
, WCS.ATTRIBUTE1
, WCS.ATTRIBUTE2
, WCS.ATTRIBUTE3
, WCS.ATTRIBUTE4
, WCS.ATTRIBUTE5
, WCS.ATTRIBUTE6
, WCS.ATTRIBUTE7
, WCS.ATTRIBUTE8
, WCS.ATTRIBUTE9
, WCS.ATTRIBUTE10
, WCS.ATTRIBUTE11
, WCS.ATTRIBUTE12
, WCS.ATTRIBUTE13
, WCS.ATTRIBUTE14
, WCS.ATTRIBUTE15
, WCS.CREATION_DATE
, WCS.CREATED_BY
, WCS.LAST_UPDATE_DATE
, WCS.LAST_UPDATED_BY
, WCS.LAST_UPDATE_LOGIN
, WCS.PROGRAM_APPLICATION_ID
, WCS.PROGRAM_ID
, WCS.PROGRAM_UPDATE_DATE
, WCS.REQUEST_ID
, WCS.MAX_NUM_STOPS_PERMITTED
, WCS.MAX_TOTAL_DISTANCE
, WCS.MAX_TOTAL_TIME
, WCS.ALLOW_INTERSPERSE_LOAD
, WCS.MAX_LAYOVER_TIME
, WCS.MIN_LAYOVER_TIME
, WCS.MAX_TOTAL_DISTANCE_IN_24HR
, WCS.ALLOW_CONTINUOUS_MOVE
, WCS.MAX_CM_DISTANCE
, WCS.MAX_CM_TIME
, WCS.MAX_CM_DH_DISTANCE
, WCS.MAX_CM_DH_TIME
, WCS.MAX_SIZE_LENGTH
, WCS.MAX_SIZE_WIDTH
, WCS.MAX_SIZE_HEIGHT
, WCS.MIN_SIZE_LENGTH
, WCS.MIN_SIZE_WIDTH
, WCS.MIN_SIZE_HEIGHT
, WCS.MAX_OUT_OF_ROUTE
, WCS.CM_FREE_DH_MILEAGE
, WCS.MIN_CM_DISTANCE
, WCS.CM_FIRST_LOAD_DISCOUNT
, WCS.MIN_CM_TIME
, WCS.UNIT_RATE_BASIS
, WCS.CM_RATE_VARIANT
, WCS.DISTANCE_CALCULATION_METHOD
, WCS.ORIGIN_DSTN_SURCHARGE_LEVEL
, WCS.MAX_DRIVING_TIME_IN_24HR
, WCS.MAX_DUTY_TIME_IN_24HR
FROM WSH_CARRIER_SERVICES WCS
, FND_LOOKUP_VALUES_VL FL
WHERE FL.LOOKUP_TYPE = 'SHIP_METHOD'
AND FL. LOOKUP_CODE = WCS.SHIP_METHOD_CODE
AND FL.VIEW_APPLICATION_ID = 3

Columns