OKC_CAL_EXCEP_AVAILABILITY_VL

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
ID EXCEP_AVAILABILITY_GUID NAME AVAIL_RANGE_START AVAIL_RANGE_END AVAIL_DATE_FORMAT AVAILABILITY EXCEPTION_ID AVAILABILITY_CODE START_HOUR START_MINUTE END_HOUR END_MINUTE ONE_TIME_FLAG DURATION OPTION_CODE WEEK_CODE MONTH_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ID, B.EXCEP_AVAILABILITY_GUID, TL.NAME, B.AVAIL_RANGE_START, B.AVAIL_RANGE_END, TL.AVAIL_DATE_FORMAT, TL.AVAILABILITY, B.EXCEPTION_ID, B.AVAILABILITY_CODE, B.START_HOUR, B.START_MINUTE, B.END_HOUR, B.END_MINUTE, B.ONE_TIME_FLAG, B.DURATION, B.OPTION_CODE, B.WEEK_CODE, B.MONTH_CODE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM OKC_CAL_EXCEP_AVAILABILITY_B B, OKC_CAL_EXCEP_AVAILABILITY_TL TL WHERE B.ID = TL.ID AND TL.LANGUAGE = USERENV('LANG')