HWR_VLTR_VOL_JOB_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name

ENTITY_ID ENTITY_TYPE VOLUNTEER_JOB_ID JOB_TYPE TITLE DESCRIPTION STATUS NOTIFY_VOLUNTEERS START_DATE END_DATE START_TIME END_TIME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN IS_SAME_SCH_SELECTED_DAYS MON_START_TIME MON_END_TIME TUE_START_TIME TUE_END_TIME WED_START_TIME WED_END_TIME THU_START_TIME THU_END_TIME FRI_START_TIME FRI_END_TIME SAT_START_TIME SAT_END_TIME SUN_START_TIME SUN_END_TIME

Query

SQL_Statement

SELECT A.ENTITY_ID, A.ENTITY_TYPE, A.VOLUNTEER_JOB_ID, A.JOB_TYPE, B.TITLE, B.DESCRIPTION, A.STATUS, A.NOTIFY_VOLUNTEERS, A.START_DATE START_DATE, A.END_DATE END_DATE, A.START_TIME, A.END_TIME, A.CREATED_BY CREATED_BY, A.CREATION_DATE CREATION_DATE, A.LAST_UPDATED_BY LAST_UPDATED_BY, A.LAST_UPDATE_DATE LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.IS_SAME_SCH_SELECTED_DAYS, A.MON_START_TIME, A.MON_END_TIME, A.TUE_START_TIME, A.TUE_END_TIME, A.WED_START_TIME, A.WED_END_TIME, A.THU_START_TIME, A.THU_END_TIME, A.FRI_START_TIME, A.FRI_END_TIME, A.SAT_START_TIME, A.SAT_END_TIME, A.SUN_START_TIME, A.SUN_END_TIME FROM HWR_VLTR_VOL_JOB_B A, HWR_VLTR_VOL_JOB_TL B WHERE A.VOLUNTEER_JOB_ID = B.VOLUNTEER_JOB_ID AND B.LANGUAGE = USERENV('LANG')