[Home] [Help]
View: PA_PTE_WBS_DOWNLOAD_V
| Product: | PA - Projects |
|---|
| Description: | View of Work Breakdown Structure data from PA - Retrofitted |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT V.PROJECT_ID
, V.PROJECT_NUMBER
, V.PROJECT_NAME
, V.PROJECT_TYPE
, TO_CHAR(V.START_DATE
, 'YYYYMMDD')
, TO_CHAR(V.COMPLETION_DATE
, 'YYYYMMDD')
, V.CARRYING_OUT_ORGANIZATION_ID
, V.TASK_ID
, V.TASK_NUMBER
, V.TASK_NAME
, PC.CUSTOMER_ID
, PP.PERSON_ID
, PP.PROJECT_ROLE_TYPE
FROM PA_PTE_DL_WBS_V V
, PA_PROJECT_PLAYERS PP
, PA_PROJECT_CUSTOMERS PC
WHERE V.PROJECT_ID = PC.PROJECT_ID (+)
AND V.PROJECT_ID = PP.PROJECT_ID (+)
Columns
| Name |
| PROJECT_ID |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PROJECT_TYPE |
| START_DATE |
| COMPLETION_DATE |
| CARRYING_OUT_ORGANIZATION_ID |
| TASK_ID |
| TASK_NUMBER |
| TASK_NAME |
| CUSTOMER_ID |
| PERSON_ID |
| PROJECT_ROLE_TYPE |