SELECT PT.TASK_ID || '-' || INS.INSTANCE_CODE , PT.LAST_UPDATE_DATE FROM PA_TASKS PT , PA_PROJECTS_ALL PA , EDW_LOCAL_INSTANCE INS WHERE PA.PROJECT_ID = PT.PROJECT_ID AND ( NOT EXISTS ( SELECT '*' FROM PA_TASKS WHERE PARENT_TASK_ID = PT.TASK_ID ) OR PT.PARENT_TASK_ID IS NULL ) UNION ALL SELECT PA.PROJECT_ID || '-' || INS.INSTANCE_CODE || '-PJ-PRJ' , PA.LAST_UPDATE_DATE FROM PA_PROJECTS_ALL PA , EDW_LOCAL_INSTANCE INS UNION ALL /* SEIBAN NUMBERS */ SELECT SB.PROJECT_ID || '-' || ELI.INSTANCE_CODE || '-PJ-PRJ' , SB.LAST_UPDATE_DATE FROM PJM_SEIBAN_NUMBERS SB , EDW_LOCAL_INSTANCE ELI