View: PA_TIMELINE_RESOURCE_V

Product:	PA - Projects
Description:	View will be used to select resources (LOV) for rebuilding the timeline records using a concurrent program
Implementation/DBA Data:	APPS.PA_TIMELINE_RESOURCE_V

View Text

SELECT RES.RESOURCE_ID RESOURCE_ID
, RES.RESOURCE_NAME RESOURCE_NAME
, PER.EMPLOYEE_NUMBER
FROM PER_PEOPLE_F PER
, PA_RESOURCES_DENORM RES
WHERE PER.PERSON_ID = RES.PERSON_ID
AND ((PER.CURRENT_EMPLOYEE_FLAG = 'Y'
AND PER.EMPLOYEE_NUMBER IS NOT NULL) OR (PER.CURRENT_NPW_FLAG = 'Y'
AND PER.NPW_NUMBER IS NOT NULL))
AND RES.JOB_ID IS NOT NULL
AND RES.RESOURCE_EFFECTIVE_START_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND NVL(PER.EFFECTIVE_END_DATE
, RES.RESOURCE_EFFECTIVE_START_DATE)
AND RES.RESOURCE_EFFECTIVE_START_DATE = (SELECT MIN(RES1.RESOURCE_EFFECTIVE_START_DATE)
FROM PA_RESOURCES_DENORM RES1
WHERE RES.RESOURCE_ID = RES1.RESOURCE_ID
AND NVL(RES1.RESOURCE_EFFECTIVE_END_DATE
, TRUNC(SYSDATE)) >= TRUNC(SYSDATE))

Columns