VIEW: APPS.PA_TIMELINE_RESOURCE_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))