<?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="ProductItemForCheckQuery">
|
<![CDATA[
|
|
SELECT
|
bbit_bbpr_id bbpr_id
|
FROM
|
bb_product_item a
|
LEFT JOIN bb_warehouse b ON a.bbit_bbwh_id = b.bbwh_id
|
WHERE
|
1 = 1
|
AND bbit_is_exit <> 'Y'
|
AND bbit_bbwh_id IS NOT NULL
|
<<AND bbit_bbpr_id=:bbprId>>
|
<<AND bbit_locationid=:locationid>>
|
<<AND bbwt_locationid=:locationid>>
|
<<AND bbwh_ids like concat('%', :bbwhId, '%')>>
|
GROUP BY
|
bbit_bbpr_id
|
HAVING
|
count(bbit_id) > 0
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
