<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[select t1.project_id, t1.project_number,--项目编号 t1.business_type, (select bt.description from hls_business_type bt where bt.business_type = t1.business_type) business_type_desc,--案件类型 to_char(t1.submit_date,'YYYY-MM-DD'),--申请日期 bm.bp_name bp_tenant,--承租人 (select scv.code_value_name from sys_code_values_v scv where scv.code='HLS211_BP_CLASS' and scv.code_value = bm.bp_class) bp_class_desc,--承租人分类 (select fc.company_short_name from fnd_companies_vl fc where fc.company_id = t1.lessor_id) company_name,--公司名称 (select hd.description from hls_division hd where hd.division = t1.division) division_desc,--产品线 (select lc.description from hls_lease_channel lc where lc.lease_channel = t1.lease_channel) channel_desc,--商业模式 t1.Ref_N01||'天', --报价有效期 (select ee.name from exp_employees ee where ee.employee_id = t1.employee_id) emp_name,--业务员 (select ee.phone from exp_employees ee where ee.employee_id = t1.employee_id) emp_phone,--业务员手机 t1.description, --业务部备注 (select to_char(cl.credit_line_amt,'FM999,999,999,990.00') from rsc_credit_line cl where cl.project_id = t1.project_id) credit_line_amt--授信额度 from prj_project t1,hls_bp_master bm #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:data-filters> <bm:data-filter enforceOperations="query" expression="t1.bp_id_tenant = bm.bp_id(+)"/> <bm:data-filter enforceOperations="query" expression="t1.project_id = (SELECT ip.parameter_value FROM zj_wfl_workflow_instance wi,zj_wfl_workflow ww,zj_wfl_workflow_type_parameter tp,zj_wfl_workflow_instance_para ip WHERE wi.workflow_id = ww.workflow_id AND ww.workflow_type_id = tp.workflow_type_id AND tp.parameter_code = 'PROJECT_ID' AND ip.workflow_type_para_id = tp.workflow_type_para_id AND wi.instance_id = ip.instance_id and wi.instance_id = ${/parameter/@instance_id} and rownum=1)"/> </bm:data-filters> </bm:model>