FFS_RESOURCE_TYPE_VL

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name

TYPE_ID LABEL STATUS FEATURES ROLE ICONS LOAD_DETERMINATION_METHOD UNDERLOAD_THRESHOLD OVERLOAD_THRESHOLD WORKING_HOURS_COST TRAVEL_COST OVERTIME_SOFT_COST OVERTIME_LIMIT OVERTIME_HARD_COST GPS_TRACK_INACTIVE GPS_HIGH_PRECISION GPS_FREQUENCY_WORKING GPS_FREQUENCY_IDLE USE_PERSONAL_PROFILE_FOR_CALC DURATION_AFFECTS_AVG SKIP_DAYS_FOR_STATS UNPAID_START_TRAVEL UNPAID_FINAL_TRAVEL NAME DELETED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN SHIFT_START_METHOD SHIFT_START_PLUGIN_ID SHIFT_START_FORM_ID

Query

SQL_Statement

SELECT b.TYPE_ID TYPE_ID, b.LABEL LABEL, b.STATUS STATUS, b.FEATURES FEATURES, b.ROLE ROLE, b.ICONS ICONS, b.LOAD_DETERMINATION_METHOD LOAD_DETERMINATION_METHOD, b.UNDERLOAD_THRESHOLD UNDERLOAD_THRESHOLD, b.OVERLOAD_THRESHOLD OVERLOAD_THRESHOLD, b.WORKING_HOURS_COST WORKING_HOURS_COST, b.TRAVEL_COST TRAVEL_COST, b.OVERTIME_SOFT_COST OVERTIME_SOFT_COST, b.OVERTIME_LIMIT OVERTIME_LIMIT, b.OVERTIME_HARD_COST OVERTIME_HARD_COST, b.GPS_TRACK_INACTIVE GPS_TRACK_INACTIVE, b.GPS_HIGH_PRECISION GPS_HIGH_PRECISION, b.GPS_FREQUENCY_WORKING GPS_FREQUENCY_WORKING, b.GPS_FREQUENCY_IDLE GPS_FREQUENCY_IDLE, b.USE_PERSONAL_PROFILE_FOR_CALC USE_PERSONAL_PROFILE_FOR_CALC, b.DURATION_AFFECTS_AVG DURATION_AFFECTS_AVG, b.SKIP_DAYS_FOR_STATS SKIP_DAYS_FOR_STATS, b.UNPAID_START_TRAVEL UNPAID_START_TRAVEL, b.UNPAID_FINAL_TRAVEL UNPAID_FINAL_TRAVEL, nvl (tl.NAME, b.LABEL) NAME, b.DELETED_FLAG DELETED_FLAG, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.SHIFT_START_METHOD SHIFT_START_METHOD, b.SHIFT_START_PLUGIN_ID SHIFT_START_PLUGIN_ID, b.SHIFT_START_FORM_ID SHIFT_START_FORM_ID from ffs_resource_type b left join ffs_resource_type_tl tl on b.TYPE_ID = tl.TYPE_ID and tl.LANGUAGE = USERENV('LANG')