public class ArrivalReportBean {

    private SessionFactory sf;
    private final String query = "SELECT h.dateTr,111, h.noTr, dt.pKey, SUM(dt.quantity) * -1, dt.unitPrice, " +
            "SUM(dt.quantity) * -1 * dt.unitPrice FROM detailTransaction dt, header h " +
            "WHERE h.noTr = dt.noTr AND h.dateTr >= '2009-1-10' AND h.dateTr <= '2009-7-15' " +
            "AND dt.NDC = 'J' GROUP BY h.dateTr,h.noTr, dt.pKey, dt.quantity, dt.unitPrice " +
            "ORDER BY h.noTr COMPUTE SUM((SUM(dt.quantity) * -1 * dt.unitPrice)) BY h.noTr " +
            "COMPUTE SUM((SUM(dt.quantity) * -1 * dt.unitPrice))";

    public ArrivalReportBean(SessionFactory sf){

        this.sf = sf;
    }

    public void test(){

        Session session = sf.openSession();
        Query q = session.createSQLQuery(query);

        q.list();
    }
}