[Home] [Help] [Dependency Information]
Object Name: | MST_USER_PREFS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 | |
VIEW_PLAN_FLAG | NUMBER | 1 all plans, 2 plans run, 3 plans not run, 4 currently running | ||
WORKBENCH_VIEW | NUMBER | 1 load, 2 orders, 3 carriers, 4 supplier, 5 customers, 6 facilities | ||
WINDOW_USAGE | NUMBER | 1 Reuse, 2 always open new, 3 open based on pin | ||
COST_STOP_ALLOC_METHOD | NUMBER | DELIVERY, PICKUP | ||
VIEW_PLAN_DURATION | NUMBER | View plans not older than this. | ||
FONT_SIZE | NUMBER | Font Size in UI (for Spreadtable). Standard - 1, Small - 2. | ||
MAP_STYLE | NUMBER | Map styles. Posiible values are NATIONAL_BOUNDARY, STATE_PROVINCIAL, CITY_IN_PLAN, LARGE_CITY | ||
SHOW_ARROWHEAD | NUMBER | 1 Yes, 2 No | ||
LINE_THICK_UNSEL | NUMBER | Width of a line for unselected element on the UI | ||
LINE_THICK_SEL | NUMBER | Width of a line for selected element on the UI | ||
TL_COLOR | NUMBER | Color representing truckload | ||
TL_CM_COLOR | NUMBER | Color representing truckload in continuous moves | ||
UL_COLOR | NUMBER | Color representing under utilized truckload | ||
LTL_COLOR | NUMBER | Color representing less than truckload | ||
PARCEL_COLOR | NUMBER | Color representing parcels | ||
UNASSIGNED_LINE_COLOR | NUMBER | Color representing unassigned orders | ||
SELECTED_LINE_COLOR | NUMBER | Color representing selected orders | ||
ADVANCED_NAVIGATION | NUMBER | 1 - Advanced navigation enabled, 2 - Advanced navigation not enabled. | ||
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). |
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, WEIGHT_UOM
, VOLUME_UOM
, DISTANCE_UOM
, DIMENSION_UOM
, CURRENCY_UOM
, VIEW_PLAN_FLAG
, WORKBENCH_VIEW
, WINDOW_USAGE
, COST_STOP_ALLOC_METHOD
, VIEW_PLAN_DURATION
, FONT_SIZE
, MAP_STYLE
, SHOW_ARROWHEAD
, LINE_THICK_UNSEL
, LINE_THICK_SEL
, TL_COLOR
, TL_CM_COLOR
, UL_COLOR
, LTL_COLOR
, PARCEL_COLOR
, UNASSIGNED_LINE_COLOR
, SELECTED_LINE_COLOR
, ADVANCED_NAVIGATION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.MST_USER_PREFS_V;
APPS.MST_USER_PREFS_V is not referenced by any database object
|
|
|