[Home] [Help] [Dependency Information]
Object Name: | MST_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
This is the entity for storing global parameters for Transportation planning
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 | |
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 | ||
MINIMUM_LAY_TIME | NUMBER | Minimum layover time after continuous drive time is reached | ||
DAY_START_TIME | VARCHAR2 | (10) | HH4:MI:SS | |
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 | ||
COST_STOP_ALLOC_METHOD | NUMBER | DELIVERY, PICKUP | ||
SCHEDULE_WINDOW | NUMBER | Time points for scheduling, 15, 30, 45, 60 (minutes). | ||
VIEW_PLAN_FLAG | NUMBER | 1 all plans, 2 plans run, 3 plans not run, 4 currently running | ||
VIEW_PLAN_DURATION | NUMBER | View plans not older than this. | ||
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 | ||
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 | |
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_SEL | NUMBER | Width of a line for selected element on the UI | ||
LINE_THICK_UNSEL | NUMBER | Width of a line for unselected 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 | ||
SELECTED_LINE_COLOR | NUMBER | Color representing selected orders | ||
UNASSIGNED_LINE_COLOR | NUMBER | Color representing unassigned orders | ||
FONT_SIZE | NUMBER | Font Size in UI (for Spreadtable). Standard - 1, Small - 2. | ||
ADVANCED_NAVIGATION | NUMBER | 1 - Advanced navigation enabled, 2 - Advanced navigation not enabled. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated 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_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
, MAX_DRIVE_TIME
, MAX_DUTY_TIME
, MINIMUM_LAY_TIME
, DAY_START_TIME
, MAX_DRIVING_DISTANCE
, COST_CAPACITY_ALLOC_METHOD
, COST_DISTANCE_ALLOC_METHOD
, COST_STOP_ALLOC_METHOD
, SCHEDULE_WINDOW
, VIEW_PLAN_FLAG
, VIEW_PLAN_DURATION
, WORKBENCH_VIEW
, WINDOW_USAGE
, 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
, MAP_STYLE
, SHOW_ARROWHEAD
, LINE_THICK_SEL
, LINE_THICK_UNSEL
, TL_COLOR
, TL_CM_COLOR
, UL_COLOR
, LTL_COLOR
, PARCEL_COLOR
, SELECTED_LINE_COLOR
, UNASSIGNED_LINE_COLOR
, FONT_SIZE
, ADVANCED_NAVIGATION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM MST.MST_PARAMETERS;
MST.MST_PARAMETERS does not reference any database object
MST.MST_PARAMETERS is referenced by following:
|
|
|