SELECT (SELECT DRF.FEATURE_VALUE FROM IGS_DA_REQ_FTRS DRF WHERE DRF.FEATURE_CODE = 'RAY' AND DRF.BATCH_ID = DR.BATCH_ID) , (SELECT DRF.FEATURE_VALUE FROM IGS_DA_REQ_FTRS DRF WHERE DRF.FEATURE_CODE = 'REF' AND DRF.BATCH_ID = DR.BATCH_ID) , (SELECT DRF.FEATURE_VALUE FROM IGS_DA_REQ_FTRS DRF WHERE DRF.FEATURE_CODE = 'RAI' AND DRF.BATCH_ID = DR.BATCH_ID) , DR.BATCH_ID FROM IGS_DA_RQST DR