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