DBA Data[Home] [Help]

VIEW: APPS.MST_GLOBAL_PREFS_V

Source

View Text - Preformatted

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 MST_PARAMETERS WHERE user_id = -9999
View Text - HTML Formatted

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