VIEW: APPS.PA_PROJ_WBS_VIEW

Source

View Text - Preformatted

SELECT p.project_id ,p.segment1 ,p.name ,t.task_id ,t.task_number ,t.task_name ,lpad(' ',2 * (wbs_level - 1))||t.task_number ,lpad(' ',2 * (wbs_level - 1))||t.task_name ,t.parent_task_id ,t.description ,t.wbs_level ,t.start_date ,t.completion_date ,t.task_manager_person_id ,per.full_name FROM pa_projects p, pa_tasks t, per_people_f per WHERE p.project_id = t.project_id AND t.task_manager_person_id = per.person_id (+) AND trunc(sysdate) BETWEEN per.effective_start_date (+) AND per.effective_end_date (+)

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, LPAD(' '
, 2 * (WBS_LEVEL - 1))||T.TASK_NUMBER
, LPAD(' '
, 2 * (WBS_LEVEL - 1))||T.TASK_NAME
, T.PARENT_TASK_ID
, T.DESCRIPTION
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.TASK_MANAGER_PERSON_ID
, PER.FULL_NAME
FROM PA_PROJECTS P
, PA_TASKS T
, PER_PEOPLE_F PER
WHERE P.PROJECT_ID = T.PROJECT_ID
AND T.TASK_MANAGER_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+)