VIEW: APPS.CSF_MAP_ACCESS_HOURS_VL

Source

View Text - Preformatted

SELECT a.ROWID ROW_ID, a.access_hour_map_id, a.customer_id, a.customer_site_id, a.customer_location_id, a.accesshour_required, a.after_hours_flag, a.monday_first_start, a.monday_first_end, a.monday_second_start, a.monday_second_end, a.tuesday_first_start, a.tuesday_first_end, a.tuesday_second_start, a.tuesday_second_end, a.wednesday_first_start, a.wednesday_first_end, a.wednesday_second_start, a.wednesday_second_end, a.thursday_first_start, a.thursday_first_end, a.thursday_second_start, a.thursday_second_end, a.friday_first_start, a.friday_first_end, a.friday_second_start, a.friday_second_end, a.saturday_first_start, a.saturday_first_end, a.saturday_second_start, a.saturday_second_end, a.sunday_first_start, a.sunday_first_end, a.sunday_second_start, a.sunday_second_end, a.object_version_number, a.created_by, a.creation_date, a.last_updated_by, a.last_update_date, a.last_update_login, a.security_group_id, b.language, b.source_lang, b.description From csf_map_access_hours_b a, csf_map_access_hours_tl b WHERE a.access_hour_map_id = b.access_hour_map_id and b.language = USERENV('LANG')

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.ACCESS_HOUR_MAP_ID
, A.CUSTOMER_ID
, A.CUSTOMER_SITE_ID
, A.CUSTOMER_LOCATION_ID
, A.ACCESSHOUR_REQUIRED
, A.AFTER_HOURS_FLAG
, A.MONDAY_FIRST_START
, A.MONDAY_FIRST_END
, A.MONDAY_SECOND_START
, A.MONDAY_SECOND_END
, A.TUESDAY_FIRST_START
, A.TUESDAY_FIRST_END
, A.TUESDAY_SECOND_START
, A.TUESDAY_SECOND_END
, A.WEDNESDAY_FIRST_START
, A.WEDNESDAY_FIRST_END
, A.WEDNESDAY_SECOND_START
, A.WEDNESDAY_SECOND_END
, A.THURSDAY_FIRST_START
, A.THURSDAY_FIRST_END
, A.THURSDAY_SECOND_START
, A.THURSDAY_SECOND_END
, A.FRIDAY_FIRST_START
, A.FRIDAY_FIRST_END
, A.FRIDAY_SECOND_START
, A.FRIDAY_SECOND_END
, A.SATURDAY_FIRST_START
, A.SATURDAY_FIRST_END
, A.SATURDAY_SECOND_START
, A.SATURDAY_SECOND_END
, A.SUNDAY_FIRST_START
, A.SUNDAY_FIRST_END
, A.SUNDAY_SECOND_START
, A.SUNDAY_SECOND_END
, A.OBJECT_VERSION_NUMBER
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.SECURITY_GROUP_ID
, B.LANGUAGE
, B.SOURCE_LANG
, B.DESCRIPTION
FROM CSF_MAP_ACCESS_HOURS_B A
, CSF_MAP_ACCESS_HOURS_TL B
WHERE A.ACCESS_HOUR_MAP_ID = B.ACCESS_HOUR_MAP_ID
AND B.LANGUAGE = USERENV('LANG')