1. Tables and Views for Sales and Fusion Service
  2. SVC_WO_SCHEDULERS_VL

SVC_WO_SCHEDULERS_VL

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: VIEW

Columns

Name

SCHEDULER_ID

SCHEDULER_CD

CONNECTION_CD

SCHEDULER_ORDER

ACTIVE_FLAG

SCHEDULER_TYPE_CD

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

CALENDAR_VIEW_SOURCE_CD

RESOURCE_TYPE_CD

SHOW_RESOURCE_NAME_FLAG

ALLOW_ASSIGN_BUCKET_FLAG

CALENDAR_VIEW_DEFAULT_CD

ALLOW_MONTH_FLAG

ENFORCE_PREFERRED_TECH_FLAG

ALLOW_OVERRIDE_FLAG

WEEK_START_DAY_CD

AVAILABLE_SLOT_COLOR

BOOKED_SLOT_COLOR

UNAVAILABLE_SLOT_COLOR

WITHIN_SLA_SLOT_COLOR

WEEKEND_WARNING_FLAG

USE_ICON_BOOKED_FLAG

USE_ICON_UNAVAIL_FLAG

USE_ICON_WITHIN_SLA_FLAG

HIGH_QUOTA_CUTOFF

LOW_QUOTA_CUTOFF

CURRENT_DAY_BUFFER

SCHEDULER_NAME

DESCRIPTION

WEEK_HELP_TEXT

MONTH_HELP_TEXT

WEEKEND_WARNING_MSG

HOLIDAY_WARNING_MSG

Query

SQL_Statement

SELECT

b.SCHEDULER_ID SCHEDULER_ID,

b.SCHEDULER_CD SCHEDULER_CD,

b.CONNECTION_CD CONNECTION_CD,

b.SCHEDULER_ORDER SCHEDULER_ORDER,

b.ACTIVE_FLAG ACTIVE_FLAG,

b.SCHEDULER_TYPE_CD SCHEDULER_TYPE_CD,

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.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

b.CALENDAR_VIEW_SOURCE_CD CALENDAR_VIEW_SOURCE_CD,

b.RESOURCE_TYPE_CD RESOURCE_TYPE_CD,

b.SHOW_RESOURCE_NAME_FLAG SHOW_RESOURCE_NAME_FLAG,

b.ALLOW_ASSIGN_BUCKET_FLAG ALLOW_ASSIGN_BUCKET_FLAG,

b.CALENDAR_VIEW_DEFAULT_CD CALENDAR_VIEW_DEFAULT_CD,

b.ALLOW_MONTH_FLAG ALLOW_MONTH_FLAG,

b.ENFORCE_PREFERRED_TECH_FLAG ENFORCE_PREFERRED_TECH_FLAG,

b.ALLOW_OVERRIDE_FLAG ALLOW_OVERRIDE_FLAG,

b.WEEK_START_DAY_CD WEEK_START_DAY_CD,

b.AVAILABLE_SLOT_COLOR AVAILABLE_SLOT_COLOR,

b.BOOKED_SLOT_COLOR BOOKED_SLOT_COLOR,

b.UNAVAILABLE_SLOT_COLOR UNAVAILABLE_SLOT_COLOR,

b.WITHIN_SLA_SLOT_COLOR WITHIN_SLA_SLOT_COLOR,

b.WEEKEND_WARNING_FLAG WEEKEND_WARNING_FLAG,

b.USE_ICON_BOOKED_FLAG USE_ICON_BOOKED_FLAG,

b.USE_ICON_UNAVAIL_FLAG USE_ICON_UNAVAIL_FLAG,

b.USE_ICON_WITHIN_SLA_FLAG USE_ICON_WITHIN_SLA_FLAG,

b.HIGH_QUOTA_CUTOFF HIGH_QUOTA_CUTOFF,

b.LOW_QUOTA_CUTOFF LOW_QUOTA_CUTOFF,

b.CURRENT_DAY_BUFFER CURRENT_DAY_BUFFER,

tl.SCHEDULER_NAME SCHEDULER_NAME,

tl.DESCRIPTION DESCRIPTION,

tl.WEEK_HELP_TEXT WEEK_HELP_TEXT,

tl.MONTH_HELP_TEXT MONTH_HELP_TEXT ,

tl.WEEKEND_WARNING_MSG WEEKEND_WARNING_MSG ,

tl.HOLIDAY_WARNING_MSG HOLIDAY_WARNING_MSG

FROM

svc_wo_schedulers_b b,

svc_wo_schedulers_tl tl

WHERE

b.SCHEDULER_CD = tl.SCHEDULER_CD AND tl.LANGUAGE = USERENV('LANG')