View: PA_STRUCT_TASKS_LITE_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_STRUCT_TASKS_LITE_V

View Text

SELECT DECODE(PPE.TASK_STATUS
, NULL
, PPE.ELEMENT_NUMBER
, PPE.ELEMENT_NUMBER||' ('||(SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE='PA_CHG_TASK_STATUSES'
AND LOOKUP_CODE=PPE.TASK_STATUS)||')') ELEMENT_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, POR.OBJECT_ID_FROM1
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPV.DISPLAY_SEQUENCE
, PPV.FINANCIAL_TASK_FLAG
, PPV.WBS_NUMBER
, PPV.WBS_LEVEL
, PPV.TASK_UNPUB_VER_STATUS_CODE
, PTT.PROG_ENTRY_ENABLE_FLAG
, PPE.STATUS_CODE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_OBJECT_RELATIONSHIPS POR
, PA_TASK_TYPES PTT
WHERE PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPV.ELEMENT_VERSION_ID = POR.OBJECT_ID_TO1
AND POR.OBJECT_TYPE_TO = 'PA_TASKS'
AND PPE.OBJECT_TYPE = PPV.OBJECT_TYPE
AND PPE.OBJECT_TYPE = 'PA_TASKS'
AND POR.RELATIONSHIP_TYPE = 'S'
AND (PPE.LINK_TASK_FLAG <> 'Y' OR PPE.TASK_STATUS IS NOT NULL)
AND PPE.TYPE_ID = PTT.TASK_TYPE_ID
AND PTT.OBJECT_TYPE = 'PA_TASKS' UNION ALL SELECT PPE.ELEMENT_NUMBER
, PPV.ELEMENT_VERSION_ID
, PPE.OBJECT_TYPE
, TO_NUMBER(NULL) OBJECT_ID_FROM1
, PPE.PROJECT_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, PPE.PROJ_ELEMENT_ID
, PPE.NAME
, PPV.DISPLAY_SEQUENCE
, PPV.FINANCIAL_TASK_FLAG
, PPV.WBS_NUMBER
, PPV.WBS_LEVEL
, PPV.TASK_UNPUB_VER_STATUS_CODE
, 'Y'
, PPE.STATUS_CODE
FROM PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
WHERE PPE.PROJECT_ID = PPV.PROJECT_ID
AND PPE.PROJ_ELEMENT_ID = PPV.PROJ_ELEMENT_ID
AND PPE.OBJECT_TYPE = PPV.OBJECT_TYPE
AND PPE.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPV.OBJECT_TYPE = 'PA_STRUCTURES'
AND PPE.LINK_TASK_FLAG <> 'Y'

Columns