DBA Data[Home] [Help] [Dependency Information]

VIEW: WSH.WSH_GLOBAL_PARAMETERS#

Object Details
Object Name: WSH_GLOBAL_PARAMETERS#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUTO_RATE_TP_REL_TRIPS VARCHAR2 (1)
TL_PRIN_COST_ALLOC_BASIS VARCHAR2 (1)
TL_DISTANCE_ALLOC_BASIS VARCHAR2 (1)
TL_STOP_COST_ALLOC_BASIS VARCHAR2 (1)
AUTOFIRM_LOAD_TENDERED_TRIPS VARCHAR2 (1)
CONSOLIDATE_BO_LINES VARCHAR2 (1)
GU_WEIGHT_CLASS VARCHAR2 (10)
GU_WEIGHT_UOM VARCHAR2 (3)
GU_VOLUME_CLASS VARCHAR2 (10)
GU_VOLUME_UOM VARCHAR2 (3)
GU_DISTANCE_CLASS VARCHAR2 (10)
GU_DISTANCE_UOM VARCHAR2 (3)
GU_DIMENSION_CLASS VARCHAR2 (10)
GU_DIMENSION_UOM VARCHAR2 (3)
GU_CURRENCY_COUNTRY VARCHAR2 (2)
GU_CURRENCY_UOM VARCHAR2 (3)
GU_TIME_CLASS VARCHAR2 (10)
GU_TIME_UOM VARCHAR2 (3)
DEF_MILE_CALC_ON_CUST_FAC VARCHAR2 (1)
DEF_MILE_CALC_ON_SUPP_FAC VARCHAR2 (1)
DEF_MILE_CALC_ON_ORG_FAC VARCHAR2 (1)
DEF_MILE_CALC_ON_CARR_FAC VARCHAR2 (1)
TL_HWAY_DIS_EMP_CONSTANT NUMBER

AVG_HWAY_SPEED NUMBER

DISTANCE_UOM VARCHAR2 (3)
TIME_UOM VARCHAR2 (3)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

ENFORCE_SHIP_METHOD VARCHAR2 (1)
ALLOW_FUTURE_SHIP_DATE VARCHAR2 (1)
DEFER_INTERFACE VARCHAR2 (1)
PALLET_ITEM_TYPE VARCHAR2 (30)
UOM_FOR_NUM_OF_UNITS VARCHAR2 (3)
RATE_IB_DELS_FGT_TERM VARCHAR2 (30)
SKIP_RATE_OB_DELS_FGT_TERM VARCHAR2 (30)
DEL_DATE_CALC_METHOD VARCHAR2 (1)
RATE_DS_DELS_FGT_TERM_ID VARCHAR2 (30)
RAISE_BUSINESS_EVENTS VARCHAR2 (1)
ENABLE_TRACKING_WFS VARCHAR2 (30)
ENABLE_SC_WF VARCHAR2 (1)
EXPAND_CARRIER_RANKINGS VARCHAR2 (1)
DEFER_PLAN_SHIPMENT_INTERFACE VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUTO_RATE_TP_REL_TRIPS
,      TL_PRIN_COST_ALLOC_BASIS
,      TL_DISTANCE_ALLOC_BASIS
,      TL_STOP_COST_ALLOC_BASIS
,      AUTOFIRM_LOAD_TENDERED_TRIPS
,      CONSOLIDATE_BO_LINES
,      GU_WEIGHT_CLASS
,      GU_WEIGHT_UOM
,      GU_VOLUME_CLASS
,      GU_VOLUME_UOM
,      GU_DISTANCE_CLASS
,      GU_DISTANCE_UOM
,      GU_DIMENSION_CLASS
,      GU_DIMENSION_UOM
,      GU_CURRENCY_COUNTRY
,      GU_CURRENCY_UOM
,      GU_TIME_CLASS
,      GU_TIME_UOM
,      DEF_MILE_CALC_ON_CUST_FAC
,      DEF_MILE_CALC_ON_SUPP_FAC
,      DEF_MILE_CALC_ON_ORG_FAC
,      DEF_MILE_CALC_ON_CARR_FAC
,      TL_HWAY_DIS_EMP_CONSTANT
,      AVG_HWAY_SPEED
,      DISTANCE_UOM
,      TIME_UOM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENFORCE_SHIP_METHOD
,      ALLOW_FUTURE_SHIP_DATE
,      DEFER_INTERFACE
,      PALLET_ITEM_TYPE
,      UOM_FOR_NUM_OF_UNITS
,      RATE_IB_DELS_FGT_TERM
,      SKIP_RATE_OB_DELS_FGT_TERM
,      DEL_DATE_CALC_METHOD
,      RATE_DS_DELS_FGT_TERM_ID
,      RAISE_BUSINESS_EVENTS
,      ENABLE_TRACKING_WFS
,      ENABLE_SC_WF
,      EXPAND_CARRIER_RANKINGS
,      DEFER_PLAN_SHIPMENT_INTERFACE
FROM WSH.WSH_GLOBAL_PARAMETERS#;

Dependencies

[top of page]

WSH.WSH_GLOBAL_PARAMETERS# references the following:

SchemaWSH
TableWSH_GLOBAL_PARAMETERS
WSH.WSH_GLOBAL_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymWSH_GLOBAL_PARAMETERS