PSC_COM_WORK_SCHEDULE_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name
SCHEDULE_ID AGENCY_ID VALID_FROM_DATE VALID_TO_DATE WORK_TIME_FROM WORK_TIME_TO BREAK_TIME_FROM BREAK_TIME_TO RECURRENCE BETW_RECUR_NUM SUN_FLAG MON_FLAG TUE_FLAG WED_FLAG THU_FLAG FRI_FLAG SAT_FLAG DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

select B.SCHEDULE_ID, B.AGENCY_ID, B.VALID_FROM_DATE, B.VALID_TO_DATE, B.WORK_TIME_FROM, B.WORK_TIME_TO, B.BREAK_TIME_FROM, B.BREAK_TIME_TO, B.RECURRENCE, B.BETW_RECUR_NUM, B.SUN_FLAG, B.MON_FLAG, B.TUE_FLAG, B.WED_FLAG, B.THU_FLAG, B.FRI_FLAG, B.SAT_FLAG, L.DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER from PSC_COM_WORK_SCHEDULE_B B,PSC_COM_WORK_SCHEDULE_TL L where B.SCHEDULE_ID = L.SCHEDULE_ID AND B.AGENCY_ID = L.AGENCY_ID AND L.LANGUAGE = USERENV('LANG')