[Home] [Help]
View: PA_TASK_NAMES_V
Product: | PA - Projects |
Description: | PA_TASK_NAMES_V selects the important display information of a task. - For future use. |
Implementation/DBA Data: |
APPS.PA_TASK_NAMES_V
|
View Text
SELECT PPE.NAME
, PPE.ELEMENT_NUMBER
, PPV.DISPLAY_SEQUENCE
, PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPEVS.NAME
, PPV2.PROJ_ELEMENT_ID
, PPE.PROJECT_ID
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_PROJ_ELEM_VER_STRUCTURE PPEVS
WHERE PPE.OBJECT_TYPE = 'PA_TASKS'
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPV.PARENT_STRUCTURE_VERSION_ID = PPV2.ELEMENT_VERSION_ID
AND PPV.PROJECT_ID = PPV2.PROJECT_ID
AND PPV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
AND PPV.PROJECT_ID = PPEVS.PROJECT_ID
AND NVL(PPE.LINK_TASK_FLAG
, 'N') <> 'Y'
AND PPE.PROJECT_ID <> 0
Columns
Name |
TASK_NAME |
TASK_NUMBER |
DISPLAY_SEQUENCE |
ELEMENT_VERSION_ID |
STRUCTURE_VERSION_ID |
STRUCTURE_VERSION_NAME |
STRUCTURE_ID |
PROJECT_ID |