### 业务关联工作流查询 这里举一个定价单的分页查询作为说明 <select id="selectPage" resultMap="CustomerPricingList1"> SELECT * FROM ( SELECT T1.PLN_ID AS PLN_ID, T1.BUS_TYPE AS BUS_TYPE, T1.IS_LCL_CURR AS IS_LCL_CURR, T1.CUST_TYPE AS CUST_TYPE, T1.CUST_NO AS CUST_NO, T1.CUST_NAME AS CUST_NAME, T1.ORG_NO AS ORG_NO, T1.BRANCH AS BRANCH, T1.CUST_IMPLVL AS CUST_IMPLVL, T6.CUSTLVL_NAME, T1.CUST_CREDIT AS CUST_CREDIT, T1.ET_TYPE AS ET_TYPE, T1.INDUSTRY AS INDUSTRY, T1.CUST_SIZE AS CUST_SIZE, T1.IDENT_TYPE AS IDENT_TYPE, T1.IDENT_NO AS IDENT_NO, T1.COMPANY AS COMPANY, T1.COMPANY_TYPE AS COMPANY_TYPE, T1.DUTY AS DUTY, T1.PROFESSIONAL AS PROFESSIONAL, T1.EDU_BACKGROUD AS EDU_BACKGROUD, T1.DEGREE AS DEGREE, T1.MARRIAGE AS MARRIAGE, T1.INCOME_MONTH AS INCOME_MONTH, T1.INCOME_MONTH_FAMILY AS INCOME_MONTH_FAMILY, T1.PRODUCT_COMM AS PRODUCT_COMM, T1.PRODUCT AS PRODUCT, T4.PRODUCT_NAME AS PRODUCT_NAME, T1.CURRENCY AS CURRENCY, T1.TERM AS TERM, T1.TERM_UNIT AS TERM_UNIT, T1.TERM_DAY AS TERM_DAY, T1.RATE_TYPE AS RATE_TYPE, T1.RPYM_TYPE AS RPYM_TYPE, T1.REPRICE_FREQ AS REPRICE_FREQ, T1.RPYM_INTEREST_FREQ AS RPYM_INTEREST_FREQ, T1.RPYM_CAPITAL_FREQ AS RPYM_CAPITAL_FREQ, T1.AMOUNT AS AMOUNT, T1.CREATE_TIME AS CREATE_TIME, T1.TAG_RATE AS TAG_RATE, T1.BASE_RATE AS BASE_RATE, T1.NOMINAL_RATE AS NOMINAL_RATE, T1.INT_RATE AS INT_RATE, NVL(T3.C_STATE, '0') AS STATUS, T1.RES_CHR1 AS RES_CHR1, T1.RES_CHR2 AS RES_CHR2, T1.RES_CHR3 AS RES_CHR3, T1.RES_NUM1 AS RES_NUM1, T1.RES_NUM2 AS RES_NUM2, T1.RES_NUM3 AS RES_NUM3, NVL(T2.C_NODEDESC, '未提交') AS NODE_NAME, T1.FLOW_ID AS FLOW_ID, T2.L_WORKITEMID AS L_WORKITEMID, T2.C_APPLYMAN AS C_APPLYMAN, T5.C_OBJECTID AS C_OBJECTID, T5.C_OBJECTNAME AS C_OBJECTNAME FROM CPM_PRI_CUST_PRICING T1 LEFT JOIN WF_FLOW T3 ON T3.L_FLOWID = T1.FLOW_ID LEFT JOIN CPM_DIM_PRODUCT T4 ON T4.PRODUCT_NO = T1.PRODUCT LEFT JOIN WF_TRANSLIST T5 ON T5.L_FLOWID = T1.FLOW_ID LEFT JOIN CPM_LVL_CUSTLVL T6 ON T1.CUST_IMPLVL=T6.CUSTLVL_ID LEFT JOIN (SELECT 0 L_WORKITEMID, '流程结束' C_NODEDESC, FLOW.L_FLOWID L_FLOWID,NULL AS C_APPLYMAN FROM WF_FLOW FLOW WHERE FLOW.C_STATE IN ('4', '5') UNION ALL SELECT ITEM.L_WORKITEMID L_WORKITEMID, ITEM.C_NODEDESC C_NODEDESC, ITEM.L_FLOWID L_FLOWID, ITEM.C_APPLYMAN C_APPLYMAN FROM WF_WORKITEM ITEM WHERE ITEM.C_STATE NOT IN ('6','0','8')) T2 ON T2.L_FLOWID=T1.FLOW_ID ) <if test="ew.sqlSegment!=null"> ${ew.sqlSegment} </if> </select> 页面展示如下：