View: PA_REP_ASMT_RES_V

Product:	PA - Projects
Description:	pa_rep_asmt_res_v is a view that shows all resources participating in assignments
Implementation/DBA Data:	APPS.PA_REP_ASMT_RES_V

View Text

SELECT DISTINCT RES.RESOURCE_ID
, RES.RESOURCE_NAME
FROM PA_RESOURCES_DENORM RES
, PA_PROJECT_ASSIGNMENTS ASMT
WHERE RES.RESOURCE_ID = ASMT.RESOURCE_ID
AND ASMT.START_DATE BETWEEN RES.RESOURCE_EFFECTIVE_START_DATE
AND RES.RESOURCE_EFFECTIVE_END_DATE
AND ASMT.ASSIGNMENT_TYPE <> 'OPEN_ASSIGNMENT'

Columns