XinYu_LZMES/.svn/pristine/d2/d2081760ad727871e4baceda5f01b6be52a31304.svn-base

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

<queryMap desc="连退作业对象选取">

<query id="UIF071010_01.SELECT" desc="选取对象查询">
  <![CDATA[	
	SELECT A.OLD_SAMPL_NO COIL_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_ORD_THK,
	       B.C_ORD_WTH,
	       B.C_ORD_LEN,
	       B.ORD_UNIT_WGT,
	       B.C_EXTSHAPE_REQ,
	       C.SM_CFNM L_ORD_USEAGE_CD,
	       D.CUST_NM ORDCUST_CD,
	       E.SM_CFNM 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,
	       TBZ00_COMMCD      E
	 WHERE A.COIL_STAT = '2'
	   AND A.ORD_NO = B.ORD_NO(+)
	   AND A.ORD_SEQ = B.ORD_SEQ(+)
	   AND (A.CUR_PROG_CD = 'DCB' OR
	       (A.CUR_PROG_CD IN ('DED', 'DRC') AND A.PACKAGE_FL <> 1 AND
	       A.EXTSHAPE_DEC_GRD = '1'))
	   AND NVL(A.PKG_FL, '0') = '0'
	   AND B.L_ORD_USEAGE_CD = C.SM_CD(+)
	   AND B.ORDCUST_CD = D.CUST_CD(+)
	   AND B.PACK_METHOD = E.SM_CD(+)
	   AND E.LG_CD(+) = 'A01010'
  ORDER BY A.OLD_SAMPL_NO
  ]]>
</query>
<query id="UIF071010_02.SELECT" desc="PKG计划汇总查询">
	<![CDATA[
		SELECT '包装计划号' TYPE_, MAX(PKG_NO) CAPTION
		  FROM L_TBF03_SPEC_PACK
		 WHERE FLAG = 'N'
		UNION
		SELECT '个数(个)' TYPE_, TO_CHAR(COUNT(PKG_NO)) CAPTION
		  FROM L_TBF03_SPEC_PACK
		 WHERE FLAG = 'N'
		UNION
		SELECT '重量(Ton)' TYPE_, TO_CHAR(SUM(A.ACT_WGT)) CAPTION
		  FROM C_TBC02_COIL_COMM A, L_TBF03_SPEC_PACK P
		 WHERE A.OLD_SAMPL_NO = P.C_COIL_NO
		   AND P.FLAG = 'N'
	]]>
</query>
<query id="UIF071010_03.SELECT" desc="PKG计划明细查询">
	<![CDATA[
		SELECT A.C_COIL_NO COIL_NO,
	           F.CUR_PROG_CD,
	           F.COIL_THK,
	           F.COIL_WTH,
	           F.COIL_LEN,
	           F.COIL_INDIA,
	           F.COIL_OUTDIA,
	           F.ACT_WGT COIL_WGT,
	           DECODE(F.TOT_DEC_GRD, '1', '合格', '2', '不合格', '未判') TOT_DEC_GRD,
	           NULL BUG,
	           F.CUR_LOAD_LOC,
	           B.C_SPEC_STL_GRD,
	           B.C_ORD_THK,
	           B.C_ORD_WTH,
	           B.C_ORD_LEN,
	           B.ORD_UNIT_WGT,
	           B.ORD_UNIT_WGT_MIN,
	           B.ORD_UNIT_WGT_MAX,
	           B.C_EXTSHAPE_REQ,
	           C.SM_CFNM L_ORD_USEAGE_CD,
	           D.CUST_NM ORDCUST_CD,
	           E.SM_CFNM PACK_METHOD,
	           B.C_SPEC_ABBSYM,
	           B.ANNOITA_YN,
	           B.PLY_REQUEST,
	           B.ORD_NO,
	           B.ORD_SEQ,
	           B.DEL_TO_DATE,
	           A.PKG_NO
	      FROM L_TBF03_SPEC_PACK A,
	           TBE02_ORD_PRC B,
	           TBZ00_COMMCD C,
	           TBZ00_CUSTOMER D,
	           TBZ00_COMMCD E,
	           C_TBC02_COIL_COMM F
	     WHERE A.ORD_NO = B.ORD_NO(+)
	       AND A.ORD_SEQ = B.ORD_SEQ(+)
	       AND A.C_COIL_NO = F.OLD_SAMPL_NO
	       AND B.L_ORD_USEAGE_CD = C.SM_CD(+)
	       AND B.ORDCUST_CD = D.CUST_CD(+)
	       AND A.PKG_LVL = E.SM_CD(+)
	       AND E.LG_CD(+) = 'A01010'
	       AND A.FLAG = 'N'
	  ORDER BY A.C_COIL_NO
	]]>
</query>
<query id="UIF071010_01.UPDATE" desc="修改包装等级" >
		<![CDATA[
			UPDATE L_TBF03_SPEC_PACK 
			   SET PKG_LVL = ?
			 WHERE PKG_NO = ?
			   AND C_COIL_NO = ?
		]]>
</query>
<query id="UIF071010.Add_PkgPlan" desc="新增包装计划信息" >
		<![CDATA[
			{call C_PKG_UIF_PKG.C_PRD_PKGPLAN_ADD(?,?,?,?,?)}
		]]>
</query>
<query id="UIF071010.Del_PkgPlan" desc="删除未确认包装计划信息" >
		<![CDATA[
			{call C_PKG_UIF_PKG.C_PRD_PKGPLAN_DEL(?,?,?)}
		]]>
</query>
<query id="UIF071010.Affirm_PkgPlan" desc="确认包装指示" >
		<![CDATA[
			{call C_PKG_UIF_PKG.C_PRD_PKGPLAN_AFM(?,?,?,?,?)}
		]]>
</query>
</queryMap>