View: CSF_MAP_ACCESS_HOURS_VL

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

View Text

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

Columns