View: PA_REP_RESOURCES_V

Product:	PA - Projects
Description:	PA_REP_RESOURCES_V is a secured view that lists resources
Implementation/DBA Data:	APPS.PA_REP_RESOURCES_V

View Text

SELECT RES.PERSON_ID
, RES.RESOURCE_ID
, RES.RESOURCE_NAME
, RES.MANAGER_ID
, RES.MANAGER_NAME
FROM PA_RESOURCES_DENORM RES
WHERE RES.RESOURCE_EFFECTIVE_START_DATE = (SELECT MIN (RES1.RESOURCE_EFFECTIVE_START_DATE)
FROM PA_RESOURCES_DENORM RES1
WHERE RES1.RESOURCE_ID = RES.RESOURCE_ID
AND RES1.RESOURCE_EFFECTIVE_END_DATE >= SYSDATE)
AND RES.PERSON_ID = (SELECT PER.PERSON_ID
FROM PER_PEOPLE_F PER
WHERE RES.PERSON_ID = PER.PERSON_ID
AND ROWNUM = 1)
AND RES.UTILIZATION_FLAG = 'Y'

Columns