VIEW: WSH.WSH_GLOBAL_PARAMETERS#

Source

View Text - Preformatted

select AUTO_RATE_TP_REL_TRIPS AUTO_RATE_TP_REL_TRIPS, TL_PRIN_COST_ALLOC_BASIS TL_PRIN_COST_ALLOC_BASIS, TL_DISTANCE_ALLOC_BASIS TL_DISTANCE_ALLOC_BASIS, TL_STOP_COST_ALLOC_BASIS TL_STOP_COST_ALLOC_BASIS, AUTOFIRM_LOAD_TENDERED_TRIPS AUTOFIRM_LOAD_TENDERED_TRIPS, CONSOLIDATE_BO_LINES CONSOLIDATE_BO_LINES, GU_WEIGHT_CLASS GU_WEIGHT_CLASS, GU_WEIGHT_UOM GU_WEIGHT_UOM, GU_VOLUME_CLASS GU_VOLUME_CLASS, GU_VOLUME_UOM GU_VOLUME_UOM, GU_DISTANCE_CLASS GU_DISTANCE_CLASS, GU_DISTANCE_UOM GU_DISTANCE_UOM, GU_DIMENSION_CLASS GU_DIMENSION_CLASS, GU_DIMENSION_UOM GU_DIMENSION_UOM, GU_CURRENCY_COUNTRY GU_CURRENCY_COUNTRY, GU_CURRENCY_UOM GU_CURRENCY_UOM, GU_TIME_CLASS GU_TIME_CLASS, GU_TIME_UOM GU_TIME_UOM, DEF_MILE_CALC_ON_CUST_FAC DEF_MILE_CALC_ON_CUST_FAC, DEF_MILE_CALC_ON_SUPP_FAC DEF_MILE_CALC_ON_SUPP_FAC, DEF_MILE_CALC_ON_ORG_FAC DEF_MILE_CALC_ON_ORG_FAC, DEF_MILE_CALC_ON_CARR_FAC DEF_MILE_CALC_ON_CARR_FAC, TL_HWAY_DIS_EMP_CONSTANT TL_HWAY_DIS_EMP_CONSTANT, AVG_HWAY_SPEED AVG_HWAY_SPEED, DISTANCE_UOM DISTANCE_UOM, TIME_UOM TIME_UOM, 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, ENFORCE_SHIP_METHOD ENFORCE_SHIP_METHOD, ALLOW_FUTURE_SHIP_DATE ALLOW_FUTURE_SHIP_DATE, DEFER_INTERFACE DEFER_INTERFACE, PALLET_ITEM_TYPE PALLET_ITEM_TYPE, UOM_FOR_NUM_OF_UNITS UOM_FOR_NUM_OF_UNITS, RATE_IB_DELS_FGT_TERM RATE_IB_DELS_FGT_TERM, SKIP_RATE_OB_DELS_FGT_TERM SKIP_RATE_OB_DELS_FGT_TERM, DEL_DATE_CALC_METHOD DEL_DATE_CALC_METHOD, RATE_DS_DELS_FGT_TERM_ID RATE_DS_DELS_FGT_TERM_ID, RAISE_BUSINESS_EVENTS RAISE_BUSINESS_EVENTS, ENABLE_TRACKING_WFS ENABLE_TRACKING_WFS, ENABLE_SC_WF ENABLE_SC_WF, EXPAND_CARRIER_RANKINGS EXPAND_CARRIER_RANKINGS, DEFER_PLAN_SHIPMENT_INTERFACE DEFER_PLAN_SHIPMENT_INTERFACE from "WSH"."WSH_GLOBAL_PARAMETERS"

View Text - HTML Formatted

SELECT AUTO_RATE_TP_REL_TRIPS AUTO_RATE_TP_REL_TRIPS
, TL_PRIN_COST_ALLOC_BASIS TL_PRIN_COST_ALLOC_BASIS
, TL_DISTANCE_ALLOC_BASIS TL_DISTANCE_ALLOC_BASIS
, TL_STOP_COST_ALLOC_BASIS TL_STOP_COST_ALLOC_BASIS
, AUTOFIRM_LOAD_TENDERED_TRIPS AUTOFIRM_LOAD_TENDERED_TRIPS
, CONSOLIDATE_BO_LINES CONSOLIDATE_BO_LINES
, GU_WEIGHT_CLASS GU_WEIGHT_CLASS
, GU_WEIGHT_UOM GU_WEIGHT_UOM
, GU_VOLUME_CLASS GU_VOLUME_CLASS
, GU_VOLUME_UOM GU_VOLUME_UOM
, GU_DISTANCE_CLASS GU_DISTANCE_CLASS
, GU_DISTANCE_UOM GU_DISTANCE_UOM
, GU_DIMENSION_CLASS GU_DIMENSION_CLASS
, GU_DIMENSION_UOM GU_DIMENSION_UOM
, GU_CURRENCY_COUNTRY GU_CURRENCY_COUNTRY
, GU_CURRENCY_UOM GU_CURRENCY_UOM
, GU_TIME_CLASS GU_TIME_CLASS
, GU_TIME_UOM GU_TIME_UOM
, DEF_MILE_CALC_ON_CUST_FAC DEF_MILE_CALC_ON_CUST_FAC
, DEF_MILE_CALC_ON_SUPP_FAC DEF_MILE_CALC_ON_SUPP_FAC
, DEF_MILE_CALC_ON_ORG_FAC DEF_MILE_CALC_ON_ORG_FAC
, DEF_MILE_CALC_ON_CARR_FAC DEF_MILE_CALC_ON_CARR_FAC
, TL_HWAY_DIS_EMP_CONSTANT TL_HWAY_DIS_EMP_CONSTANT
, AVG_HWAY_SPEED AVG_HWAY_SPEED
, DISTANCE_UOM DISTANCE_UOM
, TIME_UOM TIME_UOM
, 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
, ENFORCE_SHIP_METHOD ENFORCE_SHIP_METHOD
, ALLOW_FUTURE_SHIP_DATE ALLOW_FUTURE_SHIP_DATE
, DEFER_INTERFACE DEFER_INTERFACE
, PALLET_ITEM_TYPE PALLET_ITEM_TYPE
, UOM_FOR_NUM_OF_UNITS UOM_FOR_NUM_OF_UNITS
, RATE_IB_DELS_FGT_TERM RATE_IB_DELS_FGT_TERM
, SKIP_RATE_OB_DELS_FGT_TERM SKIP_RATE_OB_DELS_FGT_TERM
, DEL_DATE_CALC_METHOD DEL_DATE_CALC_METHOD
, RATE_DS_DELS_FGT_TERM_ID RATE_DS_DELS_FGT_TERM_ID
, RAISE_BUSINESS_EVENTS RAISE_BUSINESS_EVENTS
, ENABLE_TRACKING_WFS ENABLE_TRACKING_WFS
, ENABLE_SC_WF ENABLE_SC_WF
, EXPAND_CARRIER_RANKINGS EXPAND_CARRIER_RANKINGS
, DEFER_PLAN_SHIPMENT_INTERFACE DEFER_PLAN_SHIPMENT_INTERFACE
FROM "WSH"."WSH_GLOBAL_PARAMETERS"