eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSH.WSH_GLOBAL_PARAMETERS

Object Details

Object Name:	WSH_GLOBAL_PARAMETERS
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_GLOBAL_PARAMETERS
Subobject Name:
Status:	VALID

WSH_GLOBAL_PARAMETERS has parameters impacting features of Oracle Shipping and Transportation across all inventory organizations.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
AUTO_RATE_TP_REL_TRIPS	VARCHAR2	(1)	Auto Rate Released Trips -'Y'-Yes, 'N'-No
TL_PRIN_COST_ALLOC_BASIS	VARCHAR2	(1)	Truck Load Cost Allocation - Principal Cost Allocation basis. 'W'-Weight, 'V'-Volume
TL_DISTANCE_ALLOC_BASIS	VARCHAR2	(1)	Truck Load Cost Allocation - Distance Allocation Basis. 'A'-Actual Distance, 'D'-Direct Route
TL_STOP_COST_ALLOC_BASIS	VARCHAR2	(1)	Truck Load Cost Allocation - Cost to be allocated only to Pick up stops - 'P', Drop-off stops - 'D'
AUTOFIRM_LOAD_TENDERED_TRIPS	VARCHAR2	(1)	Autofirm Load Tendered Trips - 'N'-No Action, 'Y'-Firm Routing, 'F'-Firm Content & Routing
CONSOLIDATE_BO_LINES	VARCHAR2	(1)	To consolidate Bacordered Lines. 'Y'-Yes, 'N'-No
GU_WEIGHT_CLASS	VARCHAR2	(10)	Global Weight UOM Class
GU_WEIGHT_UOM	VARCHAR2	(3)	Global Weight UOM
GU_VOLUME_CLASS	VARCHAR2	(10)	Global Volume UOM Class
GU_VOLUME_UOM	VARCHAR2	(3)	Global Volume UOM
GU_DISTANCE_CLASS	VARCHAR2	(10)	Global Distance UOM Class
GU_DISTANCE_UOM	VARCHAR2	(3)	Global Distance UOM
GU_DIMENSION_CLASS	VARCHAR2	(10)	Global Dimension UOM Class
GU_DIMENSION_UOM	VARCHAR2	(3)	Global Dimension UOM
GU_CURRENCY_COUNTRY	VARCHAR2	(2)	Global Country for which Currency UOM will be specified
GU_CURRENCY_UOM	VARCHAR2	(3)	Global Currency UOM
GU_TIME_CLASS	VARCHAR2	(10)	Global Time UOM Class
GU_TIME_UOM	VARCHAR2	(3)	Global Time UOM
DEF_MILE_CALC_ON_CUST_FAC	VARCHAR2	(1)	Indicates if Customer Facility is considered for Mileage Calculations
DEF_MILE_CALC_ON_SUPP_FAC	VARCHAR2	(1)	Indicates if Supplier Facility is considered for Mileage Calculations
DEF_MILE_CALC_ON_ORG_FAC	VARCHAR2	(1)	Indicates if Organization Facility is considered for Mileage Calculations
DEF_MILE_CALC_ON_CARR_FAC	VARCHAR2	(1)	Indicates if Carrier Facility is considered for Mileage Calculations
TL_HWAY_DIS_EMP_CONSTANT	NUMBER		Numeric constant used to adjust the Euclidean Distance to obtain the approximate highway distance between two locations
AVG_HWAY_SPEED	NUMBER		Average Highway Speed
DISTANCE_UOM	VARCHAR2	(3)	Distance UOM-For Average Highway Speed eg Miles.
TIME_UOM	VARCHAR2	(3)	Time UOM for Average Highway Speed eg Hours
ATTRIBUTE_CATEGORY	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield
CREATION_DATE	DATE		Standard Who Column
CREATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
ENFORCE_SHIP_METHOD	VARCHAR2	(1)	Enforce Ship method
ALLOW_FUTURE_SHIP_DATE	VARCHAR2	(1)	Allow Future Ship Date
DEFER_INTERFACE	VARCHAR2	(1)	Defer Interface
PALLET_ITEM_TYPE	VARCHAR2	(30)	Pallet Item Type
UOM_FOR_NUM_OF_UNITS	VARCHAR2	(3)	UOM for number of units
RATE_IB_DELS_FGT_TERM	VARCHAR2	(30)	Rate Inbound Deliveries with this Freight Term
SKIP_RATE_OB_DELS_FGT_TERM	VARCHAR2	(30)	Do not Rate Outbound Deliveries with this Freight Term.
DEL_DATE_CALC_METHOD	VARCHAR2	(1)	Delivery Date Calculation Method
RATE_DS_DELS_FGT_TERM_ID	VARCHAR2	(30)	To Rate Drop Ship Deliveries with Freight Term
RAISE_BUSINESS_EVENTS	VARCHAR2	(1)	Raise Business Events
ENABLE_TRACKING_WFS	VARCHAR2	(30)	Enable Tracking Workflows, Values - Trip,Delivery,Both,None
ENABLE_SC_WF	VARCHAR2	(1)	Enable Ship to Deliver Workflow
EXPAND_CARRIER_RANKINGS	VARCHAR2	(1)	Determines whether ship method in the ranked list should be expanded or not
DEFER_PLAN_SHIPMENT_INTERFACE	VARCHAR2	(1)	To indicate whether Planned Shipment Interface Concurrent program need to be deferred

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 does not reference any database object

WSH.WSH_GLOBAL_PARAMETERS is referenced by following:

APPS: WSH_GLOBAL_PARAMETERS