VIEW: APPS.MST_USER_PREFS_V

Source

View Text - Preformatted

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 mst_parameters WHERE user_id <> -9999

View Text - HTML Formatted

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 MST_PARAMETERS
WHERE USER_ID <> -9999