HHR_VLTR_PROJ_VOL_INFO

Details

Schema: FUSION
Object owner: HHR
Object type: VIEW

Columns

Name
ID PROJECT_ID HCM_PERSON_ID GUEST_COUNT NO_OF_HOURS

Name

ID

PROJECT_ID

HCM_PERSON_ID

GUEST_COUNT

NO_OF_HOURS

Query

SQL_Statement
SELECT VOL_PROJ_REL.ID, VOL_PROJ_REL.PROJECT_ID, VOL_PROJ_REL.HCM_PERSON_ID, NVL(PROJ_GUEST.GUEST_COUNT, 0) GUEST_COUNT, NVL(VOL_HOURS.NO_OF_HOURS, 0.0) NO_OF_HOURS FROM HWR_VLTR_VOL_PROJ_REL_B VOL_PROJ_REL, HWR_VLTR_ACTIVITY_B VOL_HOURS, (SELECT PROJECT_ID, HCM_PERSON_ID, COUNT(GUEST_ID) GUEST_COUNT FROM HHR_VLTR_PROJECT_GUEST_B GROUP BY PROJECT_ID, HCM_PERSON_ID) PROJ_GUEST WHERE VOL_PROJ_REL.STATUS = 'VOLUNTEERED' AND VOL_PROJ_REL.HCM_PERSON_ID = VOL_HOURS.HCM_PERSON_ID(+) AND VOL_PROJ_REL.PROJECT_ID = VOL_HOURS.PROJECT_ID(+) AND VOL_PROJ_REL.HCM_PERSON_ID = PROJ_GUEST.HCM_PERSON_ID(+) AND VOL_PROJ_REL.PROJECT_ID = PROJ_GUEST.PROJECT_ID(+)

SQL_Statement

SELECT VOL_PROJ_REL.ID, VOL_PROJ_REL.PROJECT_ID, VOL_PROJ_REL.HCM_PERSON_ID, NVL(PROJ_GUEST.GUEST_COUNT, 0) GUEST_COUNT, NVL(VOL_HOURS.NO_OF_HOURS, 0.0) NO_OF_HOURS

FROM HWR_VLTR_VOL_PROJ_REL_B VOL_PROJ_REL, HWR_VLTR_ACTIVITY_B VOL_HOURS,

(SELECT PROJECT_ID, HCM_PERSON_ID, COUNT(GUEST_ID) GUEST_COUNT FROM HHR_VLTR_PROJECT_GUEST_B GROUP BY PROJECT_ID, HCM_PERSON_ID) PROJ_GUEST

WHERE VOL_PROJ_REL.STATUS = 'VOLUNTEERED'

AND VOL_PROJ_REL.HCM_PERSON_ID = VOL_HOURS.HCM_PERSON_ID(+)

AND VOL_PROJ_REL.PROJECT_ID = VOL_HOURS.PROJECT_ID(+)

AND VOL_PROJ_REL.HCM_PERSON_ID = PROJ_GUEST.HCM_PERSON_ID(+)

AND VOL_PROJ_REL.PROJECT_ID = PROJ_GUEST.PROJECT_ID(+)