SELECT u.user_name, created_issues.application_name, 'Non Promised Issues' property, COUNT(issues2.issue_id) value FROM STATEGPS.T_ISSUES_CREATED_BY_ME_V created_issues, t_gps_user_applications ua, t_gps_user_menuconfig um, t_gps_users u, tri2gps_dev.issues issues2 WHERE created_issues.STATE_NAME <> 'Issue Closed' AND created_issues.ACTIVE = 'Active' AND created_issues.application_id = ua.application_id AND ua.user_app_id = um.user_app_id AND um.menu_name = 'Build' AND ua.user_id = u.user_id --AND u.user_name = 'lchinta' --and created_issues.application_name = 'Triniti Products' AND IA_ISSUE_NUMBER IS NOT NULL AND issues2.DUE_DATE IS NULL AND issues2.ISSUE_NUMBER = created_issues.IA_ISSUE_NUMBER group by u.user_name,created_issues.application_name union SELECT u.user_name,created_issues.application_name, 'Backlog Issues' property, COUNT(issues2.issue_id) value FROM STATEGPS.T_ISSUES_CREATED_BY_ME_V created_issues, t_gps_user_applications ua, t_gps_user_menuconfig um, t_gps_users u, tri2gps_dev.issues issues2 WHERE created_issues.STATE_NAME <> 'Issue Closed' AND created_issues.ACTIVE = 'Active' AND created_issues.application_id = ua.application_id AND ua.user_app_id = um.user_app_id AND um.menu_name = 'Build' AND ua.user_id = u.user_id AND u.user_name = 'lchinta' --and created_issues.application_name = 'Triniti Products' AND IA_ISSUE_NUMBER IS NOT NULL AND TRUNC(issues2.DUE_DATE) < SYSDATE AND issues2.ISSUE_NUMBER = created_issues.IA_ISSUE_NUMBER GROUP BY u.user_name,created_issues.application_name