XinYu_RZMES/.svn/pristine/28/28aa126e4b63b5df621a46ce900c56e625c53500.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SHIPPING">
    <query id="UIJ010080_01.select" desc="  " fetchSize="10">
        <![CDATA[
			--出库计划表
			SELECT (SELECT TBZ00_COMMCD.CD_DESC
					  FROM TBZ00_COMMCD
					 WHERE TBZ00_COMMCD.SM_CD = A.DEST_PCD
					   AND ROWNUM = 1) YWD,  --运往地
				   SUBSTR(A.ORDERNO, 1, LENGTH(A.ORDERNO) - 3) PACTNO, --合同号
				   ORDERNO, --计划号
				   A.ISOUT,  --是否出口
				   A.DLIV_DIR_DATE PLANDATE, --计划时间
				   '热轧线' PL,  --产线
				   B.SHIP_DIR_DTIME REALSENDTIME, --实际发货时间
				   B.TRANS_CAR_NO,  --车牌号
				   A.DLIV_DIRNO,  --出库指示号
				   
				   (SELECT CUST_NM
					  FROM TBZ00_CUSTOMER
					 WHERE CUST_CD = A.CUST_CD
					   AND ROWNUM = 1) BUYERCODE, --客户名称
				   '承运' TRANSTYPE,   --合同性质
				   (SELECT CUST_NM
					  FROM TBZ00_CUSTOMER
					 WHERE CUST_CD = ORD_CUST_CD
					   AND ROWNUM = 1) INCEPTCORPCODE, --收货单位,
				   
				   (SELECT SM_CFNM FROM TBZ00_COMMCD WHERE SM_CD = A.CATEGORY)STL_GRD, --钢种,
				   B.SPEC_STL_GRD, --牌号,
				   B.ACT_WGT,--重量
				   '热轧厂' LOADPOSITION,--装车点
				   
				   (SELECT TBZ00_COMMCD.SM_CFNM
					  FROM TBZ00_COMMCD
					 WHERE TBZ00_COMMCD.SM_CD = A.TRAIN_DLIVNO
					   AND ROWNUM = 1) MOTORMANNAME,--承运单位
				   
				   (SELECT TBZ00_COMMCD.SM_CFNM
					  FROM TBZ00_COMMCD
					 WHERE TBZ00_COMMCD.SM_CD = A.DEST_PCD
					   AND ROWNUM = 1) STATIONCODE, --到站
				   
				   A.BY_SEA_YN  --是否水运
			
			  FROM TBJ01_DLIV_DIR A,
				   (SELECT MIN(TRANS_CAR_NO) TRANS_CAR_NO,
						   MIN(SPEC_STL_GRD) SPEC_STL_GRD,
						   SUM(ACT_WGT) ACT_WGT,
						   DLIV_DIRNO,
						   MIN(SHIP_DIR_DTIME) SHIP_DIR_DTIME
					  FROM TBH02_COIL_COMM
					 GROUP BY DLIV_DIRNO) B
			 WHERE A.DLIV_DIRNO = B.DLIV_DIRNO
			   AND A.DLIV_DIR_DATE >= TO_CHAR(?)    --做主要查询条件
         	   AND A.DLIV_DIR_DATE <= TO_CHAR(?)    --做主要查询条件
			   AND A.DLIV_TP = ?     --  'T' 火车   'C' 汽车
			   AND A.ISDELETED <> '1'
        ]]>
    </query>
</queryMap>