eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_PROJ_WBS_VIEW

Product:	PA - Projects
Description:	Project work breakdown structure
Implementation/DBA Data:	APPS.PA_PROJ_WBS_VIEW

View Text

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

Columns

Name
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
TASK_ID
TASK_NUMBER
TASK_NAME
INDENTED_TASK_NUMBER
INDENTED_TASK_NAME
PARENT_TASK_ID
DESCRIPTION
WBS_LEVEL
TASK_START_DATE
TASK_COMPLETION_DATE
TASK_MANAGER_PERSON_ID
TASK_MANAGER_NAME