View: CSF_ACCESS_HOURS_VL

Product:	CSF - Field Service
Description:
Implementation/DBA Data:	APPS.CSF_ACCESS_HOURS_VL

View Text

SELECT B.ROWID
, B.ACCESS_HOUR_ID
, B.TASK_ID
, B.ACCESSHOUR_REQUIRED
, B.AFTER_HOURS_FLAG
, B.MONDAY_FIRST_START
, B.MONDAY_FIRST_END
, B.MONDAY_SECOND_START
, B.MONDAY_SECOND_END
, B.TUESDAY_FIRST_START
, B.TUESDAY_FIRST_END
, B.TUESDAY_SECOND_START
, B.TUESDAY_SECOND_END
, B.WEDNESDAY_FIRST_START
, B.WEDNESDAY_FIRST_END
, B.WEDNESDAY_SECOND_START
, B.WEDNESDAY_SECOND_END
, B.THURSDAY_FIRST_START
, B.THURSDAY_FIRST_END
, B.THURSDAY_SECOND_START
, B.THURSDAY_SECOND_END
, B.FRIDAY_FIRST_START
, B.FRIDAY_FIRST_END
, B.FRIDAY_SECOND_START
, B.FRIDAY_SECOND_END
, B.SATURDAY_FIRST_START
, B.SATURDAY_FIRST_END
, B.SATURDAY_SECOND_START
, B.SATURDAY_SECOND_END
, B.SUNDAY_FIRST_START
, B.SUNDAY_FIRST_END
, B.SUNDAY_SECOND_START
, B.SUNDAY_SECOND_END
, T.DESCRIPTION
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM CSF_ACCESS_HOURS_TL T
, CSF_ACCESS_HOURS_B B
WHERE B.ACCESS_HOUR_ID=T.ACCESS_HOUR_ID
AND T.LANGUAGE=USERENV('LANG')

Columns