<?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="ToGetOutExitInfoQuery">
|
<![CDATA[
|
|
select o.ouex_exit_date AS lifedate,o.ouex_exit_type,o.creator from out_exit_item
|
left join out_exit_detail on oued_id = ouei_oued_id
|
left join out_exit o on o.ouex_id = oued_ouex_id
|
where 1=1
|
<<and ouei_locationid=:locationid>>
|
<<and ouei_bbit_id =:bbitId>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
