1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| <?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="ProcureListQuery">
| <![CDATA[
|
| SELECT
| cgpr_id,cgpr_sn,'' syde_name,cgpd_entry_size,cgpd_price*cgpd_entry_size cgpd_subtotal,cgpr_order_date,cgpd_finish_state
| FROM
| cg_procure
| LEFT JOIN cg_procure_detail ON cgpr_id = cgpd_cgpr_id
| left join bb_business_partner on cgpd_bbbp_id=bbbp_id
| WHERE
| 1 = 1
| and ##CONDITIONS##
|
| ]]>
| </sql-query>
| </hibernate-mapping>
|
|
