<?xml version="1.0"?>
|
<!DOCTYPE hibernate-mapping PUBLIC
|
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
|
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
|
<hibernate-mapping>
|
<sql-query name="SumOccSizeToRefOrderProductEntryQuery">
|
<![CDATA[
|
|
select IFNULL(sum(reop_size),0) as occSize
|
from ref_order_product_entry
|
left join pr_product_entry_detail on reop_prpd_id=prpd_id
|
where 1=1
|
<<and reop_prod_id=:reopProdId>>
|
<<and reop_prpd_id=:reopPrpdId>>
|
<<and reop_iodd_id=:reopIoddId>>
|
<<and prpd_bbpr_id=:prpdBbprId>>
|
<<and reop_flag=:reopFlag>>
|
<<and reop_prod_id!=:reopProdId2>>
|
<<and reop_remark!=:reopRemark>>
|
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
