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 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 = 1039 group by bsm.replay_sequence,maxtc.bsm_number,ins.application_id