View: PA_STRUCT_PUB_TASK_VERS_V

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

View Text

SELECT PEV.PROJECT_ID
, PEV.PROJ_ELEMENT_ID
, PEV.PARENT_STRUCTURE_VERSION_ID
, STRUCT.NAME
, SCHED.ELEMENT_VERSION_ID
, STRUCT.PUBLISHED_DATE
, SCHED.SCHEDULED_START_DATE
, SCHED.SCHEDULED_FINISH_DATE
, SCHED.CRITICAL_FLAG
, SCHED.MILESTONE_FLAG
, SCHED.PLANNED_EFFORT
, STRUCT.STATUS_CODE
FROM PA_PROJ_ELEMENT_VERSIONS PEV
, PA_PROJ_ELEM_VER_SCHEDULE SCHED
, PA_PROJ_ELEM_VER_STRUCTURE STRUCT
WHERE PEV.PROJECT_ID = STRUCT.PROJECT_ID
AND PEV.PARENT_STRUCTURE_VERSION_ID = STRUCT.ELEMENT_VERSION_ID
AND STRUCT.STATUS_CODE = 'STRUCTURE_PUBLISHED'
AND PEV.PROJ_ELEMENT_ID = SCHED.PROJ_ELEMENT_ID
AND PEV.PROJECT_ID = SCHED.PROJECT_ID
AND PEV.ELEMENT_VERSION_ID = SCHED.ELEMENT_VERSION_ID

Columns