select decode(child_data.state_descriptor, 'Workflow Move', (select M.STATE_NAME from tri2gps_dev.MIG_REQUESTS_V M where M.MIGRATION_REQUEST_NUMBER = issue_number), state_name) state_name,parent_issue_number,user_name from (select ws.state_descriptor, state_name, issue_number, A.INSTANCE_ID,parent_issue_number,d.user_name from tri2gps_dev.issues a, t_gps_instances b, t_gps_workflow_states ws, t_project_task d where a.instance_id = b.instance_id and b.instance_present = 1 and d.instance_id=a.instance_id and d.state_id = b.current_state_id and b.current_state_id = ws.state_id and parent_issue_number is not null and a.issue_number is not null /* and a.parent_issue_number = 'INC00064'*/)child_data