SELECT ISSUES.ISSUE_NUMBER, ISSUES.PARENT_ISSUE_NUMBER, STATE_TYPE, STATE_NAME, T_INSTANCE_DOCUMENTS.DOCUMENT || '/' || T_INSTANCE_CHILD_DOCS.DOCUMENT_NAME AS DOCUMENT, T_INSTANCE_CHILD_DOCS.STATE_ID FROM TRI2GPS_DEV.ISSUES ISSUES, STATEGPS.T_INSTANCE_DOCUMENTS T_INSTANCE_DOCUMENTS, TRI2GPS_DEV.ISSUES ISSUES1, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES RIGHT OUTER JOIN STATEGPS.T_INSTANCE_CHILD_DOCS T_INSTANCE_CHILD_DOCS ON T_INSTANCE_CHILD_DOCS.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID WHERE T_INSTANCE_DOCUMENTS.DOCUMENT_ID = T_INSTANCE_CHILD_DOCS.DOCUMENT_ID AND ((ISSUES.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID) OR (ISSUES1.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID)) AND ISSUES.PARENT_ISSUE_NUMBER = ISSUES1.ISSUE_NUMBER AND ISSUES.ISSUE_NUMBER IS NOT NULL