VIEW: APPS.PA_STRUCT_PUB_TASK_VERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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