VIEW: APPS.WSH_CARRIER_SERVICES_V

Source

View Text - Preformatted

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, WCS.DIM_DIMENSIONAL_FACTOR, WCS.DIM_WEIGHT_UOM, WCS.DIM_VOLUME_UOM, WCS.DIM_DIMENSION_UOM, WCS.DIM_MIN_PACK_VOL, WCS.DEFAULT_VEHICLE_TYPE_ID, WCS.UPDATE_MOT_SL 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

View Text - HTML Formatted

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
, WCS.DIM_DIMENSIONAL_FACTOR
, WCS.DIM_WEIGHT_UOM
, WCS.DIM_VOLUME_UOM
, WCS.DIM_DIMENSION_UOM
, WCS.DIM_MIN_PACK_VOL
, WCS.DEFAULT_VEHICLE_TYPE_ID
, WCS.UPDATE_MOT_SL
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