Criteria pq = session.createCriteria(Devices.class).createAlias("PrisProduct", "pp");
pq.add(Restrictions.eq(field, value.trim()));
Collection pc = pq.list();

        <property name="dieCode" type="com.st.wma.datalayer.hibernate.util.OracleCHAR">
            <column name="DIE_CODE" length="20" not-null="true" unique="true" />
        </property>
        <many-to-one name="PrisProduct" class="com.st.wma.datalayer.hibernate.model.PrisProduct" column="DIE_CODE" not-null="true" insert="false" update="false">
        </many-to-one>   

        <set name="devices" table="DEVICES">
            <key column="CAM_PRODUCT"/>               
            <one-to-many class="com.st.wma.datalayer.hibernate.model.Devices"/>               
        </set>

package com.st.wma.datalayer.hibernate.util;

import java.io.Serializable;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.jdbc.driver.OracleTypes;

import org.apache.commons.lang.StringUtils;
import org.hibernate.HibernateException;
import org.hibernate.usertype.UserType;

/**
* This class trim value of Oracle CHAR columns that causes problem of padding
* with spaces.
*/
public class OracleCHAR implements UserType {
    public OracleCHAR() {
        super();
    }

    public int[] sqlTypes() {
        return new int[]{OracleTypes.FIXED_CHAR};
    }

    public Class<String> returnedClass() {
        return String.class;
    }

    public boolean equals(Object x, Object y) throws HibernateException {
        return (x == y) || (x != null && y != null && (x.equals(y)));
    }

    public Object nullSafeGet(ResultSet rs, String[] names, Object owner)
            throws HibernateException, SQLException {
        String val = rs.getString(names[0]);
        if (null == val) {
            return null;
        }
        else {
            //String trimmed = StringUtils.stripEnd(val, " ");
            String trimmed = StringUtils.trim(val);
            if (trimmed.equals("")) {
                return null;
            }
            else {
                return trimmed;
            }
        }
    }

    public void nullSafeSet(PreparedStatement st, Object value, int index)
            throws HibernateException, SQLException {
        if (value == null) {
            st.setNull(index, OracleTypes.FIXED_CHAR);
        }
        else {
            st.setObject(index, value, OracleTypes.FIXED_CHAR);
        }
    }

    public Object deepCopy(Object value) throws HibernateException {
        if (value == null)
            return null;
        return new String((String) value);
    }

    public boolean isMutable() {
        return false;
    }

    public Object assemble(Serializable arg0, Object arg1)
            throws HibernateException {
        return null;
    }

    public Serializable disassemble(Object arg0) throws HibernateException {
        return null;
    }

    public int hashCode(Object arg0) throws HibernateException {
        return 0;
    }

    public Object replace(Object arg0, Object arg1, Object arg2)
            throws HibernateException {
        return null;
    }
}

    from
        MAPS this_
    inner join
        WAFERS w1_
            on this_.WAFER_ID=w1_.WAFER_ID
    inner join
        DEVICES d2_
            on this_.DIE_ID=d2_.DIE_ID
    inner join
        PRIS_PRODUCT PP3_
            on trim(d2_.DIE_CODE)=pp3_.CAM_PRODUCT
    left outer join
        ANALYSIS_RESULTS mapanalysi8_
            on this_.MAP_ID=mapanalysi8_.MAP_
ID
    WHERE
        THIS_.START_DATE_TIME>=TO_DATE('22-06-2010','DD-MM-YYYY')
        AND THIS_.START_DATE_TIME<=TO_DATE('01-07-2010','DD-MM-YYYY')
        and pp3_.CAM_PRODUCT_GROUP='10'