XinYu_RZMES/.svn/pristine/97/97813db4bf61c2b64e4c3badb0031b255a4908a8.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project A">
	<query id="DeliverGoodsResult.Select" desc="发货产品现况.-查询" fetchSize="10">
        <![CDATA[
SELECT B.ORD_NO, B.ORD_SEQ, B.CUST_CD, B.CUST_NM
     , B.COIL_NO, B.TOT_DEC_GRD, B.COIL_THK, B.COIL_WTH, B.COIL_LEN, B.ACT_WGT
     , B.SPEC_STL_GRD
     , B.SM_CFNM AS ORD_USE_NM
     , B.YARD_ENTRY_DTIME
     , DECODE(A.SHIP_DIR_DATE, NULL, NULL, SUBSTRB(A.SHIP_DIR_DATE,1,4)||'-'||SUBSTRB(A.SHIP_DIR_DATE,5,2)||'-'||SUBSTRB(A.SHIP_DIR_DATE,7,2)) AS SHIP_DIR_DATE
     , DECODE(A.SHIP_CFM_DATE, NULL, NULL, SUBSTRB(A.SHIP_CFM_DATE,1,4)||'-'||SUBSTRB(A.SHIP_CFM_DATE,5,2)||'-'||SUBSTRB(A.SHIP_CFM_DATE,7,2)) AS SHIP_CFM_DATE
FROM TBJ01_SHIP_DIR A
   ,(SELECT X.SHIP_DIRNO
          , X.ORD_NO, X.ORD_SEQ, X.CUST_CD, X.COIL_NO, X.TOT_DEC_GRD, X.COIL_THK, X.COIL_WTH, X.COIL_LEN, X.ACT_WGT, X.SPEC_STL_GRD, X.YARD_ENTRY_DTIME
          , Y.CUST_NM
          , Z.SM_CFNM
     FROM TBH02_COIL_COMM X
        , TBZ00_CUSTOMER Y
        ,(SELECT * FROM TBZ00_COMMCD WHERE LG_CD = 'A01007') Z
     WHERE 1 = 1
     AND X.CUST_CD = Y.CUST_CD(+)
     AND X.ORD_USE_CD = Z.SM_CD(+)
     AND X.SHIP_DIRNO BETWEEN :1 AND :2||'9999'
     AND X.SHIP_PROG_CD = :3
     AND NVL(X.PRODNM_CD   ,' ') LIKE :4
     AND NVL(X.SPEC_STL_GRD,' ') LIKE :5
     AND NVL(X.ORD_USE_CD  ,' ') LIKE :6) B
WHERE A.SHIP_DIRNO = B.SHIP_DIRNO
AND A.SHIP_DIRNO BETWEEN :7 AND :8||'9999'
ORDER BY B.SHIP_DIRNO, B.COIL_NO
        ]]>
    </query>
</queryMap>