= T3.ORD_THK AND T1.WTH_MIN <= T3.ORD_WTH AND T1.WTH_MAX >= T3.ORD_WTH AND T1.SIZE_SPEC_CD = T2.SIZE_SPEC_CD AND DECODE(T2.SIZE_CD ,'THK' , T2.C_THK_MIN , T3.ORD_THK) <= T3.ORD_THK AND DECODE(T2.SIZE_CD ,'THK' , T2.C_THK_MAX , T3.ORD_THK) >= T3.ORD_THK AND DECODE(T2.SIZE_CD ,'WTH' , T2.C_WTH_MIN , T3.ORD_WTH) <= T3.ORD_WTH AND DECODE(T2.SIZE_CD ,'WTH' , T2.C_WTH_MAX , T3.ORD_WTH) >= T3.ORD_WTH GROUP BY T3.ORD_NO,T3.ORD_SEQ )F WHERE A.ORD_NO = B.ORD_NO AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) AND B.RCVORD_TP = D.SM_CD(+) AND A.ORD_NO = F.ORD_NO(+) AND A.ORD_SEQ = F.ORD_SEQ(+) AND B.CUST_CD = C.CUST_CD AND B.RCVORD_TP <> 'M' AND A.ORD_SEQ_PROG_CD = '1' AND B.ORD_NO NOT LIKE '42%' AND B.ORD_NO NOT LIKE '47%' AND A.ORD_NO LIKE :1 || '%' AND A.ORD_SEQ LIKE :2 || '%' AND NVL(A.ORD_WTH,0) BETWEEN NVL(:3, 0) AND NVL(:4, 99999999) AND (:5 IS NULL or D.SM_CSNM IN(SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(:6) AS TABSTR_T)))) AND A.SPEC_STL_GRD LIKE '%' || :7 || '%' AND C.CUST_NM LIKE '%' || :8 || '%' AND A.ORD_REG_DTIME BETWEEN NVL(:9, '00000000') AND NVL(:10, '99999999') AND A.DLIV_TP LIKE NVL(:11,'%') AND INSTR(NVL(:12 , B.PRDNM_CD) , B.PRDNM_CD) > 0 AND NVL(a.ORD_PLAN_DATA,'00000000') BETWEEN :13 AND :14 AND DECODE(A.PROD_LINE , 'L' , 'C' , A.PROD_LINE)LIKE :15||'%' AND A.ORD_THK LIKE :16||'%' ORDER BY A.ORD_NO,A.ORD_SEQ ]]> 'M') AS NEED_WGT, (SELECT SUM(B.PREV_CHARGE_WGT) FROM TBF01_SPEC_CHARGE B WHERE B.STATUS_CD IN ('A', 'B')) AS CHARGE_WGT, (SELECT SUM(C.SLAB_WGT) --库存量 FROM TBG02_SLAB_COMM C, TBG02_SLAB_COMM_D D WHERE C.ORD_FL = '1' AND C.SUB_SLAB_NO = D.SLAB_NO AND C.ORD_FL = D.ORD_FL AND C.SLAB_STAT = '2') AS KC_WGT, ((SELECT SUM(A.NEED_WGT) FROM TBD01_SLABDN_OBJ A, TBA01_ORD_COMM F WHERE A.ORD_NO = F.ORD_NO AND A.ORD_NO NOT LIKE '42%' AND A.ORD_NO NOT LIKE '47%' AND A.ORD_NO NOT LIKE 'TSH%' AND F.RCVORD_TP <> 'M') + (SELECT SUM(B.PREV_CHARGE_WGT) FROM TBF01_SPEC_CHARGE B WHERE B.STATUS_CD IN ('A', 'B')) + (SELECT SUM(C.SLAB_WGT) --库存量 FROM TBG02_SLAB_COMM C, TBG02_SLAB_COMM_D D WHERE C.ORD_FL = '1' AND C.SUB_SLAB_NO = D.SLAB_NO AND C.ORD_FL = D.ORD_FL AND C.SLAB_STAT = '2')) AS ALLWGT FROM DUAL ]]>