SELECT PPE.NAME , PPE.ELEMENT_NUMBER , PPE.PROJ_ELEMENT_ID , PPEVS.PROJECT_ID , PPST.STRUCTURE_TYPE_ID , PST.STRUCTURE_TYPE_CLASS_CODE , PL.MEANING FROM PA_PROJ_ELEMENTS PPE , PA_PROJ_ELEMENT_VERSIONS PPEV , PA_PROJ_ELEM_VER_STRUCTURE PPEVS , PA_PROJ_STRUCTURE_TYPES PPST , PA_STRUCTURE_TYPES PST , PA_LOOKUPS PL , PA_PROJECT_STATUSES PPS WHERE PPEVS.LATEST_EFF_PUBLISHED_FLAG = 'Y' AND PPEVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID AND PPST.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 2) AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID AND PST.STRUCTURE_TYPE_CLASS_CODE = 'WORKPLAN' AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID AND PPEV.PROJECT_ID = PPEVS.PROJECT_ID AND PPEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID AND PPEV.PROJECT_ID = PPE.PROJECT_ID AND PPE.OBJECT_TYPE = 'PA_TASKS' AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS' AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE AND PPS.PROJECT_SYSTEM_STATUS_CODE <> 'CANCELLED' AND PPE.LINK_TASK_FLAG <> 'Y' UNION SELECT PPE.NAME , PPE.ELEMENT_NUMBER , PPE.PROJ_ELEMENT_ID , PPEVS.PROJECT_ID , PPST.STRUCTURE_TYPE_ID , PST.STRUCTURE_TYPE_CLASS_CODE , PL.MEANING FROM PA_PROJ_ELEMENTS PPE , PA_PROJ_ELEMENT_VERSIONS PPEV , PA_PROJ_ELEM_VER_STRUCTURE PPEVS , PA_PROJ_STRUCTURE_TYPES PPST , PA_STRUCTURE_TYPES PST , PA_LOOKUPS PL , PA_PROJECT_STATUSES PPS WHERE PPEVS.LATEST_EFF_PUBLISHED_FLAG = 'Y' AND PPEVS.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID AND PPST.PROJ_ELEMENT_ID IN ( SELECT PROJ_ELEMENT_ID FROM PA_PROJ_STRUCTURE_TYPES GROUP BY PROJ_ELEMENT_ID HAVING COUNT(PROJ_ELEMENT_ID) = 1) AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID AND PPEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID AND PPEV.PROJECT_ID = PPEVS.PROJECT_ID AND PPEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID AND PPEV.PROJECT_ID = PPE.PROJECT_ID AND PPE.OBJECT_TYPE = 'PA_TASKS' AND PL.LOOKUP_TYPE = 'PA_STRUCTURE_TYPE_CLASS' AND PL.LOOKUP_CODE = PST.STRUCTURE_TYPE AND PPE.STATUS_CODE = PPS.PROJECT_STATUS_CODE AND PPS.PROJECT_SYSTEM_STATUS_CODE <> 'CANCELLED' AND PPE.LINK_TASK_FLAG <> 'Y'