[Home] [Help]
View: PA_DELIVERABLES_TASKS_V
Product: | PA - Projects |
Description: | PA_DELIVERABLES_TASKS_V selects all tasks and the deliverables associated to it. |
Implementation/DBA Data: |
APPS.PA_DELIVERABLES_TASKS_V
|
View Text
SELECT PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPE.ELEMENT_NUMBER
, PEV.WBS_NUMBER
, PPE.PROJECT_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, PPE.RECORD_VERSION_NUMBER
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PEV
WHERE PPE.OBJECT_TYPE='PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PEV.PROJECT_ID
Columns
Name |
TASK_ID |
TASK_NAME |
TASK_NUMBER |
OUTLINE_NUMBER |
PROJECT_ID |
PARENT_STRUCTURE_VERSION_ID |
RECORD_VERSION_NUMBER |