SELECT MCDS.CS_DEFINITION_ID , MCDS.CS_NAME FROM MSD_CS_DATA_HEADERS MCDS , MSD_CS_DEFINITIONS_VL MCD WHERE MCDS.CS_DEFINITION_ID = MCD.CS_DEFINITION_ID AND MCD.MULTIPLE_STREAM_FLAG = 'Y' AND MCD.ENABLE_FLAG = 'Y' AND MCD.VALID_FLAG = 'Y' GROUP BY MCDS.CS_DEFINITION_ID , MCDS.CS_NAME