VIEW: APPS.CSF_ACCESS_HOURS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')