<?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="CgProcureDetailQuery">
|
<![CDATA[
|
|
select bbbp_id,bbbp_name,bbst_name,bbst_style,cgpd_bbst_id,cgpd_id,cgpd_did,cgpd_amount,cgpd_entry_amount,cgpd_flag,cgpd_remark
|
from cg_procure_detail cgpd
|
left join cg_procure cgp on cgpd.cgpd_cgpr_id=cgp.cgpr_id
|
left join bb_stuff bbs on cgpd.cgpd_bbst_id = bbs.bbst_id
|
left join bb_business_partner bbbp on cgp.cgpr_bbbp_id = bbbp.bbbp_id
|
where 1=1
|
<<and bbbp_name= :bbbpName>>
|
<<and bbst_name= :bbstName>>
|
<<and cgpd_flag= :cgpdFlag>>
|
<<and bbbp_id= :bbbpId>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
