VIEW: APPS.WSH_CARRIERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'