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]

VIEW: APPS.MST_GLOBAL_PREFS_V

Object Details

Object Name:	MST_GLOBAL_PREFS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER		Yes	PK. For global preferences user id should be populated with -9999
WEIGHT_UOM	VARCHAR2	(3)		UOM of weight
VOLUME_UOM	VARCHAR2	(3)		UOM of volume
DISTANCE_UOM	VARCHAR2	(3)		Distance UOM
DIMENSION_UOM	VARCHAR2	(3)		UOM of dimension
CURRENCY_UOM	VARCHAR2	(3)		UOM of currency
MINIMUM_LAY_TIME	NUMBER			Minimum layover time after continuous drive time is reached
MAX_DRIVE_TIME	NUMBER			Maximum drive time if the driver works for max_duty_time
MAX_DUTY_TIME	NUMBER			Maximum duty time in 24 hrs
MAX_DRIVING_DISTANCE	NUMBER			Maximum driving distance in 24 hrs
COST_CAPACITY_ALLOC_METHOD	NUMBER			Primary capacity of measure. Weight, volume etc.,
COST_DISTANCE_ALLOC_METHOD	NUMBER			Distance allocation basis. The actual distance, or the direct route distance travelled
DAY_START_TIME	VARCHAR2	(10)		HH4:MI:SS
SCHEDULE_WINDOW	NUMBER			Time points for scheduling, 15, 30, 45, 60 (minutes).
PALLETIZED_LOADING_RATE	NUMBER			Use for default facility creation
PALLETIZED_UNLOADING_RATE	NUMBER			Use for default facility creation
PALLETIZED_WEIGHT_UOM	VARCHAR2	(3)		Use for default facility creation
PALLETIZED_TIME_UNIT	VARCHAR2	(3)		Use for default facility creation
NON_PALLETIZED_LOADING_RATE	NUMBER			Use for default facility creation
NON_PALLETIZED_UNLOADING_RATE	NUMBER			Use for default facility creation
NON_PALLETIZED_WEIGHT_UOM	VARCHAR2	(3)		Use for default facility creation
NON_PALLETIZED_TIME_UNIT	VARCHAR2	(3)		Use for default facility creation
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT USER_ID
,      WEIGHT_UOM
,      VOLUME_UOM
,      DISTANCE_UOM
,      DIMENSION_UOM
,      CURRENCY_UOM
,      MINIMUM_LAY_TIME
,      MAX_DRIVE_TIME
,      MAX_DUTY_TIME
,      MAX_DRIVING_DISTANCE
,      COST_CAPACITY_ALLOC_METHOD
,      COST_DISTANCE_ALLOC_METHOD
,      DAY_START_TIME
,      SCHEDULE_WINDOW
,      PALLETIZED_LOADING_RATE
,      PALLETIZED_UNLOADING_RATE
,      PALLETIZED_WEIGHT_UOM
,      PALLETIZED_TIME_UNIT
,      NON_PALLETIZED_LOADING_RATE
,      NON_PALLETIZED_UNLOADING_RATE
,      NON_PALLETIZED_WEIGHT_UOM
,      NON_PALLETIZED_TIME_UNIT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.MST_GLOBAL_PREFS_V;

Dependencies

[top of page]

APPS.MST_GLOBAL_PREFS_V references the following:

APPS: MST_PARAMETERS

APPS.MST_GLOBAL_PREFS_V is not referenced by any database object