View: WSH_CARRIERS_V

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

View Text

SELECT WC.ROWID
, HP.PARTY_ID
, WC.SCAC_CODE
, WC.FREIGHT_CODE
, WC.MANIFESTING_ENABLED_FLAG
, WC.CURRENCY_CODE
, HP.PARTY_NAME
, DECODE(HPU.PARTY_ID
, NULL
, 'I'
, 'A')
, HPU.PARTY_USG_ASSIGNMENT_ID
, WC.ATTRIBUTE_CATEGORY
, WC.ATTRIBUTE1
, WC.ATTRIBUTE2
, WC.ATTRIBUTE3
, WC.ATTRIBUTE4
, WC.ATTRIBUTE5
, WC.ATTRIBUTE6
, WC.ATTRIBUTE7
, WC.ATTRIBUTE8
, WC.ATTRIBUTE9
, WC.ATTRIBUTE10
, WC.ATTRIBUTE11
, WC.ATTRIBUTE12
, WC.ATTRIBUTE13
, WC.ATTRIBUTE14
, WC.ATTRIBUTE15
, WC.CREATION_DATE
, WC.CREATED_BY
, WC.LAST_UPDATE_DATE
, WC.LAST_UPDATED_BY
, WC.LAST_UPDATE_LOGIN
, WC.MAX_NUM_STOPS_PERMITTED
, WC.MAX_TOTAL_DISTANCE
, WC.MAX_TOTAL_TIME
, WC.ALLOW_INTERSPERSE_LOAD
, WC.MAX_LAYOVER_TIME
, WC.MIN_LAYOVER_TIME
, WC.MAX_TOTAL_DISTANCE_IN_24HR
, WC.MAX_DRIVING_TIME_IN_24HR
, WC.MAX_DUTY_TIME_IN_24HR
, WC.ALLOW_CONTINUOUS_MOVE
, WC.MAX_CM_DISTANCE
, WC.MAX_CM_TIME
, WC.MAX_CM_DH_DISTANCE
, WC.MAX_CM_DH_TIME
, WC.MAX_SIZE_WIDTH
, WC.MAX_SIZE_HEIGHT
, WC.MAX_SIZE_LENGTH
, WC.MIN_SIZE_WIDTH
, WC.MIN_SIZE_HEIGHT
, WC.MIN_SIZE_LENGTH
, WC.TIME_UOM
, WC.DIMENSION_UOM
, WC.DISTANCE_UOM
, WC.MAX_OUT_OF_ROUTE
, WC.CM_FREE_DH_MILEAGE
, WC.MIN_CM_DISTANCE
, WC.CM_FIRST_LOAD_DISCOUNT
, WC.MIN_CM_TIME
, WC.UNIT_RATE_BASIS
, WC.WEIGHT_UOM
, WC.VOLUME_UOM
, WC.GENERIC_FLAG
, WC.FREIGHT_BILL_AUTO_APPROVAL
, WC.FREIGHT_AUDIT_LINE_LEVEL
, WC.SUPPLIER_ID
, WC.SUPPLIER_SITE_ID
, WC.CM_RATE_VARIANT
, WC.DISTANCE_CALCULATION_METHOD
, WC.ORIGIN_DSTN_SURCHARGE_LEVEL
, WC.DIM_DIMENSIONAL_FACTOR
, WC.DIM_WEIGHT_UOM
, WC.DIM_VOLUME_UOM
, WC.DIM_DIMENSION_UOM
, WC.DIM_MIN_PACK_VOL
FROM HZ_PARTIES HP
, WSH_CARRIERS WC
, HZ_PARTY_USG_ASSIGNMENTS HPU
WHERE WC.CARRIER_ID = HP.PARTY_ID
AND HP.PARTY_ID = HPU.PARTY_ID(+)
AND HPU.EFFECTIVE_END_DATE(+) = TO_DATE('31/12/4712'
, 'DD/MM/RRRR')
AND HPU.PARTY_USAGE_CODE(+) = 'TRANSPORTATION_PROVIDER'

Columns