IRC_IS_SCHEDULES_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name

SCHEDULE_ID SCHEDULE_CODE SCHEDULE_TITLE PRE_SCHEDULE_DETAILS POST_SCHEDULE_DETAILS REQUISITION_ID SCHEDULE_TYPE INTERVIEW_TYPE SCHEDULE_TEMPLATE_ID SCHEDULE_LOCATION_ID STATUS INCLUDE_ICS INCLUDE_JOB_POSTING_LINK INCLUDE_RESUME INTR_INVITED_MSG_ID INTR_SCHEDULED_MSG_ID INTR_CANCELLED_MSG_ID INTR_UPDATED_MSG_ID INTR_REMINDED_MSG_ID INTR_RESCHEDULED_MSG_ID IS_CANCELLABLE_FLAG IS_RESCHEDULABLE_FLAG ALLOW_SAME_DAY_SCHDLNG_FLAG HAS_VISIBILITY_RANGE_FLAG HAS_RESCHDLE_LIMIT_FLAG HAS_CHANGE_LOCK_FLAG LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER INTERVWS_VISIBILITY_RANGE_CODE INTERVW_RESCHDLE_LIMIT_CODE INTERVW_CHANGE_LOCK_CODE SCHEDULE_ALMOST_FULL_NOTIF SCHEDULE_ALMOST_FULL_THRESHOLD SCHEDULE_FULL_NOTIF SCHEDULE_REMINDER_SENT AUTO_O365_CALENDAR_SLOT_FLAG AUTO_COLLAB_RESP_TYPE_LIST AUTO_MEETING_PROVIDER AUTO_MEETING_HOST AUTO_SLOT_INTERVIEW_DURATION SCHEDULE_OWNER SEND_AVAILABILITY_REQUEST_FLAG

Query

SQL_Statement

SELECT IRC_IS_SCHEDULES_B.SCHEDULE_ID SCHEDULE_ID, IRC_IS_SCHEDULES_B.SCHEDULE_CODE SCHEDULE_CODE, IRC_IS_SCHEDULES_TL.SCHEDULE_TITLE SCHEDULE_TITLE, IRC_IS_SCHEDULES_TL.PRE_SCHEDULE_DETAILS PRE_SCHEDULE_DETAILS, IRC_IS_SCHEDULES_TL.POST_SCHEDULE_DETAILS POST_SCHEDULE_DETAILS, IRC_IS_SCHEDULES_B.REQUISITION_ID REQUISITION_ID, IRC_IS_SCHEDULES_B.SCHEDULE_TYPE SCHEDULE_TYPE, IRC_IS_SCHEDULES_B.INTERVIEW_TYPE INTERVIEW_TYPE, IRC_IS_SCHEDULES_B.SCHEDULE_TEMPLATE_ID SCHEDULE_TEMPLATE_ID, IRC_IS_SCHEDULES_B.SCHEDULE_LOCATION_ID SCHEDULE_LOCATION_ID, IRC_IS_SCHEDULES_B.STATUS STATUS, IRC_IS_SCHEDULES_B.INCLUDE_ICS INCLUDE_ICS, IRC_IS_SCHEDULES_B.INCLUDE_JOB_POSTING_LINK INCLUDE_JOB_POSTING_LINK, IRC_IS_SCHEDULES_B.INCLUDE_RESUME INCLUDE_RESUME, IRC_IS_SCHEDULES_B.INTR_INVITED_MSG_ID INTR_INVITED_MSG_ID, IRC_IS_SCHEDULES_B.INTR_SCHEDULED_MSG_ID INTR_SCHEDULED_MSG_ID, IRC_IS_SCHEDULES_B.INTR_CANCELLED_MSG_ID INTR_CANCELLED_MSG_ID, IRC_IS_SCHEDULES_B.INTR_UPDATED_MSG_ID INTR_UPDATED_MSG_ID, IRC_IS_SCHEDULES_B.INTR_REMINDED_MSG_ID INTR_REMINDED_MSG_ID, IRC_IS_SCHEDULES_B.INTR_RESCHEDULED_MSG_ID INTR_RESCHEDULED_MSG_ID, IRC_IS_SCHEDULES_B.IS_CANCELLABLE_FLAG IS_CANCELLABLE_FLAG, IRC_IS_SCHEDULES_B.IS_RESCHEDULABLE_FLAG IS_RESCHEDULABLE_FLAG, IRC_IS_SCHEDULES_B.ALLOW_SAME_DAY_SCHDLNG_FLAG ALLOW_SAME_DAY_SCHDLNG_FLAG, IRC_IS_SCHEDULES_B.HAS_VISIBILITY_RANGE_FLAG HAS_VISIBILITY_RANGE_FLAG, IRC_IS_SCHEDULES_B.HAS_RESCHDLE_LIMIT_FLAG HAS_RESCHDLE_LIMIT_FLAG, IRC_IS_SCHEDULES_B.HAS_CHANGE_LOCK_FLAG HAS_CHANGE_LOCK_FLAG, IRC_IS_SCHEDULES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IRC_IS_SCHEDULES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, IRC_IS_SCHEDULES_B.LAST_UPDATED_BY LAST_UPDATED_BY, IRC_IS_SCHEDULES_B.CREATION_DATE CREATION_DATE, IRC_IS_SCHEDULES_B.CREATED_BY CREATED_BY, IRC_IS_SCHEDULES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, IRC_IS_SCHEDULES_B.INTERVWS_VISIBILITY_RANGE_CODE INTERVWS_VISIBILITY_RANGE_CODE, IRC_IS_SCHEDULES_B.INTERVW_RESCHDLE_LIMIT_CODE INTERVW_RESCHDLE_LIMIT_CODE, IRC_IS_SCHEDULES_B.INTERVW_CHANGE_LOCK_CODE INTERVW_CHANGE_LOCK_CODE, IRC_IS_SCHEDULES_B.SCHEDULE_ALMOST_FULL_NOTIF SCHEDULE_ALMOST_FULL_NOTIF, IRC_IS_SCHEDULES_B.SCHEDULE_ALMOST_FULL_THRESHOLD SCHEDULE_ALMOST_FULL_THRESHOLD, IRC_IS_SCHEDULES_B.SCHEDULE_FULL_NOTIF SCHEDULE_FULL_NOTIF, IRC_IS_SCHEDULES_B.SCHEDULE_REMINDER_SENT SCHEDULE_REMINDER_SENT, IRC_IS_SCHEDULES_B.AUTO_O365_CALENDAR_SLOT_FLAG AUTO_O365_CALENDAR_SLOT_FLAG, IRC_IS_SCHEDULES_B.AUTO_COLLAB_RESP_TYPE_LIST AUTO_COLLAB_RESP_TYPE_LIST, IRC_IS_SCHEDULES_B.AUTO_MEETING_PROVIDER AUTO_MEETING_PROVIDER, IRC_IS_SCHEDULES_B.AUTO_MEETING_HOST AUTO_MEETING_HOST, IRC_IS_SCHEDULES_B.AUTO_SLOT_INTERVIEW_DURATION AUTO_SLOT_INTERVIEW_DURATION, IRC_IS_SCHEDULES_B.SCHEDULE_OWNER SCHEDULE_OWNER, IRC_IS_SCHEDULES_B.SEND_AVAILABILITY_REQUEST_FLAG FROM IRC_IS_SCHEDULES_B, IRC_IS_SCHEDULES_TL WHERE IRC_IS_SCHEDULES_B.SCHEDULE_ID = IRC_IS_SCHEDULES_TL.SCHEDULE_ID AND IRC_IS_SCHEDULES_TL.LANGUAGE = USERENV('LANG')