[Home] [Help]
View: PA_PTE_DL_WBS_V
Product: | PA - Projects |
Description: | View of project and task data from Oracle Projects for Oracle Personal Time and Expense |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT P.PROJECT_ID
, P.PROJECT_NUMBER PROJECT_NUMBER
, P.PROJECT_NAME PROJECT_NAME
, P.PROJECT_DESCRIPTION
, P.PROJECT_TYPE
, P.START_DATE
, P.COMPLETION_DATE
, P.CARRYING_OUT_ORGANIZATION_ID
, T.TASK_ID
, T.TASK_NUMBER
, SUBSTR(LPAD(' '
, 2*(WBS_LEVEL-1))||T.TASK_NAME
, 1
, 200) TASK_NAME
, T.WBS_LEVEL
FROM PA_TASKS T
, PA_PROJECTS_EXPEND_V P
WHERE T.PROJECT_ID = P.PROJECT_ID
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
PROJECT_DESCRIPTION |
PROJECT_TYPE |
START_DATE |
COMPLETION_DATE |
CARRYING_OUT_ORGANIZATION_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
WBS_LEVEL |