XinYu_LZMES/.svn/pristine/1d/1de631bae2aa53f18f5fbee653fe38c0293cf9ea.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="连退作业对象申报">

<query id="UIF051020_01.SELECT" desc="申报对象查询">
	SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,A.CUR_PROG_CD,A.SPEC_STL_GRD,
           A.COIL_THK,A.COIL_WTH,A.COIL_LEN,
           A.COIL_INDIA,A.COIL_OUTDIA,A.ACT_WGT,
           DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD,
           C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(A.CRK_CD1,A.CRK_CD2,A.CRK_CD3,A.CRK_CD4,A.CRK_CD5) BUG,
           A.CUR_LOAD_LOC,
           B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX,
           B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX,
           B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX,
           B.ORD_UNIT_WGT ORD_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX,
           B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD,
           B.PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG,
           B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE 
      FROM C_TBC02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D  
     WHERE A.COIL_STAT='2' AND A.ORD_NO=B.ORD_NO(+) AND A.ORD_SEQ=B.ORD_SEQ(+) AND A.CUR_LOAD_LOC IS NOT NULL
       AND A.FAN_XIU = 'Y'
       AND B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+)
</query>
<query id="UIF051020_02.SELECT" desc="已申报信息查询">
	SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,F.CUR_PROG_CD,F.SPEC_STL_GRD,
		     F.COIL_THK,F.COIL_WTH,F.COIL_LEN,
		     F.COIL_INDIA,F.COIL_OUTDIA,F.COIL_WGT,
		     DECODE(F.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD,
		     C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(F.CRK_CD1,F.CRK_CD2,F.CRK_CD3,F.CRK_CD4,F.CRK_CD5) BUG,
		     A.CUR_LOAD_LOC,
		     B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX,
		     B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX,
		     B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX,
		     B.ORD_UNIT_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX,
		     B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD,
		     B.PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG,
		     B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE,
		     F.DCL_REASON,F.DCL_MEMO,F.STATUS_CD  
		FROM C_TBC02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D,L_TBF03_CAL_DECLARE F  
	 WHERE F.ORD_NO=B.ORD_NO AND F.ORD_SEQ=B.ORD_SEQ  AND  A.OLD_SAMPL_NO=F.C_COIL_NO
	  AND  B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+)
</query>
<query id="UIF051020_03.SELECT" desc="获取连退申报原因信息">
	SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD='F02001'
</query>
<query id="UIF051020_04.SELECT" desc="交货状态查询">
	SELECT SM_CD, SM_CFNM
	  FROM TBZ00_COMMCD
	 WHERE LG_CD = 'B01118'
	   AND CD_DESC = 'C'
</query>
<query id="UIF051020.Add" desc="新增连退申报信息" >
		<![CDATA[
			{call C_PKG_UIF_CAL.P_PRD_DCL_CALPLAN_ADD(?,?,?,?,?,?,?,?,?)}
		]]>
</query>
<query id="UIF051020.Del" desc="删除连退申报信息" >
		<![CDATA[
			{call C_PKG_UIF_CAL.P_PRD_DCL_CALPLAN_DEL(?,?,?,?)}
		]]>
</query>
</queryMap>