HWR_VLTR_ACTIVITY_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
ACTIVITY_ID PROJECT_ID PROJECT_NAME START_DATE END_DATE NO_OF_HOURS STATE ACTIVITY_TITLE ACTIVITY_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY VOLUNTEER_JOB_ID HCM_PERSON_ID ABSENCE_ID VOL_ABS_STATUS VOL_ABS_ERROR ABSENCE_TYPE_ID CT_POINTS_STATUS CT_POINTS_ERROR

Query

SQL_Statement

SELECT A.ACTIVITY_ID ACTIVITY_ID, A.PROJECT_ID PROJECT_ID, C.PROJECT_NAME PROJECT_NAME, A.START_DATE START_DATE, A.END_DATE END_DATE, A.NO_OF_HOURS NO_OF_HOURS, A.STATE STATE, B.ACTIVITY_TITLE ACTIVITY_TITLE, B.ACTIVITY_DESCRIPTION ACTIVITY_DESCRIPTION, A.CREATED_BY CREATED_BY, A.CREATION_DATE CREATION_DATE, A.LAST_UPDATE_DATE LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.LAST_UPDATED_BY LAST_UPDATED_BY, A.VOLUNTEER_JOB_ID , A.HCM_PERSON_ID, A.ABSENCE_ID, A.VOL_ABS_STATUS, B.VOL_ABS_ERROR, C.ABSENCE_TYPE_ID, A.CT_POINTS_STATUS, A.CT_POINTS_ERROR FROM HWR_VLTR_ACTIVITY_B A, HWR_VLTR_ACTIVITY_TL B, HHR_VLTR_PRJ_PROJECT_VL C WHERE A.ACTIVITY_ID = B.ACTIVITY_ID AND B.LANGUAGE = USERENV('LANG') AND A.PROJECT_ID = C.PROJECT_ID