select max(maxtc.case_id) case_id,bsm.replay_sequence,ins.application_id from t_instances ins, v_instance_props prop, tri2gps_dev.links links, tri2gps_dev.issues iss, tri2gps_dev.test_cases tc, tri2gps_dev.test_Cases maxtc, tri2gps_dev.bsm_main bsm, T_GPS_APPLICATIONS APP, T_GPS_APP_PROPERTIES APP_PROP where prop.INSTANCE_ID = ins.instance_id and links.reference_type like 'TC' and links.link_type = 'ISS' and iss.issue_id = links.entity_id and tc.case_id = links.reference_identifier and maxtc.bsm_number = tc.bsm_number and iss.issue_number = prop.IA_ISSUE_NUMBER and maxtc.bsm_number = bsm.bsm_number and ins.application_id = app.application_id AND (APP.VISIBLE_FLAG = 'true' OR APP.VISIBLE_FLAG IS NULL) AND APP_PROP.APPLICATION_ID = APP.APPLICATION_ID AND APP_PROP.PROPERTY_NAME = 'RT_EXECUTION_TYPE' AND APP_PROP.PROPERTY_VALUE ='PROJECT' group by bsm.replay_sequence,maxtc.bsm_number,ins.application_id