XinYu_RZMES/.svn/pristine/f8/f82a15015d8b2d875062af68f90673a0b516bcf8.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc=" 订单进程现况查询">

	<query id="UIE012010.OrdPrc.Select_bak" desc="" fetchSize="10">
		<![CDATA[
	     SELECT
                A.ORD_NO,                                        -- 合同号
                A.ORD_SEQ,                                        -- 订单号
                XB_PACKAGE.GF_COMNNAME_FIND('E01001', A.ORD_PROG_CD) ORD_PROG_CD,        -- 订单进度代码
                XB_PACKAGE.GF_CUSTOMER_FIND(A.CUST_CD) CUST_CD,                            -- 客户代码
                XB_PACKAGE.GF_COMNNAME_FIND('E01003', A.ABNOR_ORD_CD) ABNOR_ORD_CD,        -- 异常订单类型代码
                XB_PACKAGE.GF_COMNNAME_FIND('E01005', A.PROD_HOLD_CD) PROD_HOLD_CD,        -- 生产保留区分代码
                XB_PACKAGE.GF_COMNNAME_FIND('A01001', A.RCVORD_CLF) RCVORD_CLF,    -- 订单用途
                XB_PACKAGE.GF_COMNNAME_FIND('B01118', A.PRODNM_CD) PRODNM_CD,          -- 交货状态
                XB_PACKAGE.GF_COMNNAME_FIND('B01118', A.C_PRODNM_CD) C_PRODNM_CD,            -- 交货状态
			    XB_PACKAGE.GF_COMNNAME_FIND('A01004', A.PRD_TY) PRD_TY,            -- 产品类型
                A.STL_GRD,                                        -- 钢号
                A.H_SPEC_STL_GRD,
                A.SPEC_ABBSYM,                                    -- 标准号
                A.C_SPEC_STL_GRD,
                A.C_SPEC_ABBSYM,                                   -- 标准号
                XB_PACKAGE.GF_COMNNAME_FIND('A01007', A.ORD_USEAGE_CD) ORD_USEAGE_CD,    -- 订单用途
                NVL(A.KEEPWARM_YN, 'N') KEEPWARM_YN,            -- 是否需要进保温坑
                NVL(A.EACHLOT_YN, 'N') EACHLOT_YN,                -- 是否需要全部取样
                A.ORD_THK,                                        -- 订单厚度
                A.ORD_WTH,                                        -- 订单宽度
                A.ORD_LEN,                                        -- 订单长度
                A.ORD_UNIT_WGT,                                    -- 订单单重量
                A.ORD_UNIT_WGT_MIN,                                -- 订单单重量下限
                A.ORD_UNIT_WGT_MAX,                                -- 订单单重量上限
                NVL(A.EMGMTR_NMG_CLF, 'N') EMGMTR_NMG_CLF,        -- 紧急材代码
                A.MILL_DUE_DATE,
                -----------------------------------------------------------
                --modify by sjw 091012
                --desc change the column '--A.DEL_FR_DATE' to 'A.ORD_PLAN_DATA'
                B.ORD_PLAN_DATA ,                                --订单预排期
                -----------------------------------------------------------
                --A.DEL_FR_DATE,                                    -- 交货日期（发送）
                A.DEL_TO_DATE,                                    -- 交货日期（到达）
                A.ORD_WGT,                                        -- 订单重量
                A.WGT_ACVAL_MIN,                                -- 交付允许误差最小
                A.WGT_ACVAL_MAX,                                -- 交付允许误差最大
                PKG_QUALITY_COMM.FID070010(A.ORD_NO , A.ORD_SEQ)     SUM_WGT,
                DECODE(A.ORD_PROG_CD, 'G', 0, A.ORD_REM_WGT) ORD_REM_WGT,                -- 订单未生产量
                (SELECT SUM(TOT_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD IN ('JB', 'JR', 'JC', 'JL')) LG,    -- 炼钢
                (SELECT SUM(TOT_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD = 'JJ') LZ,                        -- 连铸
                (SELECT SUM(TOT_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD IN ('RA', 'RB', 'RC')) ZG,        -- 轧钢
                (SELECT SUM(TOT_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD = 'SC') JZ,                        -- 精整
                (SELECT SUM(TOT_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD IN ('SB', 'SD', 'SE')) ZH,        -- 综合判定
                (SELECT SUM(INS_WGT+WRK_WGT) FROM TBE02_ORD_PRC_DET
                 WHERE ORD_NO = A.ORD_NO
                   AND ORD_SEQ = A.ORD_SEQ
                   AND PROC_CD IN ('SF','PC')) DD,                        -- 发货等待
                A.SHIP_END_WGT,                                    -- 发货完重量
                DECODE(A.ORD_PROG_CD, 'G', 0,
                    (A.ORD_WGT - A.SHIP_END_WGT)) SHIP_REM_WGT    -- 剩余发货量
                ,XB_PACKAGE.GF_COMNNAME_FIND('A01012', B.DLIV_TP) DLIV_TP
                ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN
              -----------------------------------------------------------------------------------------------
              --modify by sjw 091028
              --desc:          
               ,decode(ROUND(A.SHIP_END_WGT / A.ORD_WGT * 100, 2) || '%','0%','',ROUND(A.SHIP_END_WGT / A.ORD_WGT * 100, 2) || '%') ORD_RATE, --合同兑现率
/*               CASE
                   WHEN SYSDATE > TO_DATE(A.DEL_TO_DATE, 'yyyymmdd') THEN
                    DECODE(A.PROD_END_WGT + A.ORD_PRC_WGT,
                           0,
                           '',
                           A.PROD_END_WGT + A.ORD_PRC_WGT)
               END OVER_DATE_WGT, */                                        
/*               CASE WHEN A.SHIP_END_WGT > M.WGT_IN_DEL THEN TO_CHAR(A.SHIP_END_WGT-M.WGT_IN_DEL)
                    ELSE ''                            END  OVER_DATE_WGT, 王黎注释(M.WGT_IN_DEL即超交货期的量 无需相减)*/
			   M.WGT_IN_DEL  OVER_DATE_WGT, --超交货期量
               CASE
                   WHEN B.DLIV_TP = 'T' THEN
                    DECODE(A.SHIP_END_WGT, 0, '', A.SHIP_END_WGT)
               END CALZADA_WGT,                                           --火车交货                                      
               CASE
                   WHEN B.DLIV_TP = 'C' THEN  
                    DECODE(A.SHIP_END_WGT, 0, '', A.SHIP_END_WGT)
               END TRAIN_WGT,                                              --汽车交货
                DECODE(A.ORD_PROG_CD,'G',A.SHIP_END_DATE,A.PROD_END_DATE) PROD_END_DATE --TL 091229 取出新添加的发货结束时间
               --屏蔽原来取的生产结束时间  DECODE(A.PROD_END_GP, '1' ,A.PROD_END_DATE,'')  PROD_END_DATE --发货结束时间
             -------------------------------------------------------------------------------------------------
			    ,B.MK_COIL
			    ,B.XSQY					--销售区域
			    ,C_PKG_ORD_REP.FUN_PING_ZHENG(B.ORD_NO , B.ORD_SEQ)    YN_PING_ZHENG   --是否平整
            FROM TBE02_ORD_PRC A, TBA01_ORD_LINE B                -- 订单进程表
			      ,TBZ00_CUSTOMER      C                          --客户公共表
                  ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
                    FROM TBB01_ORD_INGR
                   WHERE DSN_KIND = '1') K
           ,(SELECT A.ORD_NO,A.ORD_SEQ,SUM(A.ACT_WGT)   WGT_IN_DEL
  FROM TBH02_COIL_COMM      A
       ,TBE02_ORD_PRC       B
  WHERE A.ORD_NO            = B.ORD_NO
    AND A.ORD_SEQ           = B.ORD_SEQ
    AND A.ORD_FL            = '1'
    AND A.TRNF_DTIME        > B.DEL_TO_DATE
  GROUP BY (A.ORD_NO,A.ORD_SEQ))M
            WHERE A.ORD_NO LIKE ?||'%'                            -- 参数：合同号
              AND A.ORD_SEQ LIKE ?||'%'                            -- 参数：订单号
              AND A.ORD_NO = B.ORD_NO(+)
              AND A.ORD_SEQ = B.ORD_SEQ(+)
              AND A.ORD_NO = K.ORD_NO(+)
              AND A.ORD_SEQ = K.ORD_SEQ(+)
              AND A.ORD_NO = M.ORD_NO(+)
              AND A.ORD_SEQ = M.ORD_SEQ(+)
			  AND A.CUST_CD = C.CUST_CD(+)
              AND   INSTR(NVL(? , A.PRD_TY) , A.PRD_TY) > 0      -- 参数：产品代码
              AND (? IS NULL OR A.ORD_PROG_CD IN (                -- 参数：订单进度代码
                    SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(?) AS TABSTR_T))))
              AND A.ABNOR_ORD_CD||'&' LIKE ?||'%'                -- 参数：异常订单类型代码
           --   AND A.CUST_CD||'&' LIKE ?||'%'                    -- 参数：客户代码
			  AND C.CUST_NM LIKE '%'||?||'%'                    --参数：客户名称
              AND A.STL_GRD||'&' LIKE '%'||?||'%'                    -- 参数：钢号
              AND A.DEL_TO_DATE BETWEEN ? AND ?                    -- 参数：交货日期（到达）
              AND (? IS NULL OR A.RCVORD_CLF IN (                -- 参数：交货区分
                      SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(?) AS TABSTR_T))))
              AND NVL(B.ORD_PLAN_DATA,A.DEL_TO_DATE) BETWEEN NVL(?,'0000000') AND NVL(?,'99999999')
              AND B.DLIV_TP||'&' LIKE ?||'%'                     --运输方式，查询条件TL 091209
			  AND A.ORD_WTH BETWEEN NVL(?,0) AND NVL(?,99999999)
			  AND A.ORD_THK BETWEEN NVL(?,0) AND NVL(?,99999999)  
              AND B.XSQY||'&' LIKE ?||'%'
            ORDER BY A.ORD_NO, A.ORD_SEQ
		]]>
	</query> 
	<query id="UIE012010.OrdPrc.Select" desc="" fetchSize="10">
		<![CDATA[
	    SELECT 'N' CHK, --选择
       A.ORD_NO, -- 合同号
       A.ORD_SEQ, -- 订单号    
       XB_PACKAGE.GF_COMNNAME_FIND('E01001', A.ORD_PROG_CD) ORD_PROG_CD, -- 订单进度代码
       (SELECT TO_CHAR(wmsys.wm_concat(XB_PACKAGE.GF_COMNNAME_FIND('E04002',
                                                                   COLUMN_VALUE)))
          FROM TABLE(XB_PACKAGE.GF_TABSTR(A.ORD_PRC_LOCK, '|'))) ORD_PRC_LOCK,
       DECODE(B.ISNEWPRODUCTS,'N','质财','产销') ISNEWPRODUCTS,
       XB_PACKAGE.GF_CUSTOMER_FIND(A.CUST_CD) CUST_CD, -- 客户代码
       XB_PACKAGE.GF_COMNNAME_FIND('A01012', B.DLIV_TP) DLIV_TP,
       XB_PACKAGE.GF_COMNNAME_FIND('E01005', A.PROD_HOLD_CD) PROD_HOLD_CD, -- 生产保留区分代码
       XB_PACKAGE.GF_COMNNAME_FIND('A01001', A.RCVORD_CLF) RCVORD_CLF, -- 订单用途
       XB_PACKAGE.GF_COMNNAME_FIND('A01004', A.PRD_TY) PRD_TY, -- 产品类型
       C_PKG_ORD_REP.FUN_PING_ZHENG(B.ORD_NO, B.ORD_SEQ) YN_PING_ZHENG, --是否平整 
       A.PRODNM_CD, -- 交货状态
       A.C_PRODNM_CD, -- 交货状态
       
       A.STL_GRD, -- 厂内牌号
       A.H_SPEC_STL_GRD,
       A.SPEC_ABBSYM, -- 标准号
       A.C_SPEC_STL_GRD, -- 热轧标准号
       A.C_SPEC_ABBSYM, -- 冷轧标准号
       XB_PACKAGE.GF_COMNNAME_FIND('A01007', A.ORD_USEAGE_CD) ORD_USEAGE_CD, -- 订单用途
       A.ORD_THK, -- 订单厚度
       A.ORD_WTH, -- 订单宽度
       A.ORD_LEN, -- 订单长度
       A.ORD_UNIT_WGT, -- 订单单重量
       A.ORD_UNIT_WGT_MIN, -- 订单单重量下限
       A.ORD_UNIT_WGT_MAX, -- 订单单重量上限
       B.XSQY, --销售区域
       XB_PACKAGE.GF_COMNNAME_FIND('A01009', B.DEST_PCD) DEST_PCD,
       T.DSN_CMT_DATE,
       B.ORD_PLAN_DATA, --订单预排期
       A.MILL_DUE_DATE, --热轧完成期限
       A.DEL_TO_DATE, -- 交货日期（到达）
       A.ORD_WGT, -- 订单重量
       A.WGT_ACVAL_MIN, -- 交付允许误差最小
       A.WGT_ACVAL_MAX, -- 交付允许误差最大
       PKG_QUALITY_COMM.FID070010(A.ORD_NO, A.ORD_SEQ) SUM_WGT,
       DECODE(A.ORD_PROG_CD, 'G', 0, A.ORD_REM_WGT) ORD_REM_WGT, -- 订单未生产量
       DECODE(A.PRD_TY,
              'AR',
              A.SHIP_END_WGT,
              'CR',
              A.HOT_ROLL_END_WGT,
              'KB',
              A.HOT_ROLL_END_WGT,
              A.HOT_ROLL_END_WGT) HOT_ROLL_END_WGT, --热轧移送量
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('JB', 'JR', 'JC', 'JL')) LG, -- 炼钢
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'JJ') LZ, -- 连铸
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('RA', 'RB', 'RC')) ZG, -- 轧钢
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'SC') JZ, -- 精整
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'LC') SZ, -- 酸轧
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'LD') LT, -- 连退
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'LE') CJ, -- 重卷
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'LF') BZ, -- 包装
           (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD = 'SP') PZ, -- 平整
       (SELECT SUM(TOT_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('SB', 'SD', 'SE')) ZH, -- 综合判定
       (SELECT SUM(INS_WGT + WRK_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('SG', 'PA', 'SF')) DD, -- 发货等待
       (SELECT SUM(INS_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('SG', 'PA', 'SF')) DDA, -- 发货等待
       (SELECT SUM(WRK_WGT)
          FROM TBE02_ORD_PRC_DET
         WHERE ORD_NO = A.ORD_NO
           AND ORD_SEQ = A.ORD_SEQ
           AND PROC_CD IN ('SG', /*'PA',*/ 'SF')) DDB, -- 发货等待       20211026 夏雪生要求去掉运输链
       DECODE(A.PROD_LINE,
              'C',
              A.HOT_ROLL_END_WGT,
              'H',
              A.SHIP_END_WGT,
              A.SHIP_END_WGT) SHIP_END_WGT, -- 发货完重量
       DECODE(A.ORD_PROG_CD, 'G', 0, (A.ORD_WGT - A.SHIP_END_WGT)) SHIP_REM_WGT ,-- 剩余发货量    
       DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN,  
        decode(ROUND(A.SHIP_END_WGT / A.ORD_WGT * 100, 2) || '%',
              '0%',
              '',
              ROUND(A.SHIP_END_WGT / A.ORD_WGT * 100, 2) || '%') ORD_RATE, --合同兑现率
       M.WGT_IN_DEL OVER_DATE_WGT, --超交货期量
       CASE
         WHEN B.DLIV_TP = 'T' THEN
          DECODE(A.SHIP_END_WGT, 0, '', A.SHIP_END_WGT)
       END CALZADA_WGT, --火车交货                                      
       CASE
         WHEN B.DLIV_TP = 'C' THEN
          DECODE(A.SHIP_END_WGT, 0, '', A.SHIP_END_WGT)
       END TRAIN_WGT, --汽车交货
       DECODE(A.ORD_PROG_CD, 'G', A.SHIP_END_DATE, A.PROD_END_DATE) PROD_END_DATE,
      B.MK_COIL,
      B.MK_CONTENT ORD_REMK,
      b.TRTMTH_TP
      ,
      XB_PACKAGE.GF_COMNNAME_FIND('E01003', A.ABNOR_ORD_CD) ABNOR_ORD_CD, -- 异常订单类型代码
      A.SMS_DUE_DATE, --炼钢完成期限 
      A.MILL_DUE_DATE MILL_DATE, --热轧完成期限 
      A.PLTCM_DUE_DATE, --酸轧完成期限   
      A.CAL_DUE_DATE, --连退完成期限
       NVL(A.KEEPWARM_YN, 'N') KEEPWARM_YN, -- 是否需要进保温坑
       NVL(A.EACHLOT_YN, 'N') EACHLOT_YN, -- 是否需要全部取样
       NVL(A.EMGMTR_NMG_CLF, 'N') EMGMTR_NMG_CLF -- 紧急材代码 
	  FROM TBE02_ORD_PRC A,
	       TBA01_ORD_LINE B -- 订单进程表
	      ,
	       TBZ00_CUSTOMER C --客户公共表
	      ,TBB01_ORD_HEAD T,
	       (SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
	          FROM TBB01_ORD_INGR
	         WHERE DSN_KIND = '1') K,
	       (SELECT A.ORD_NO, A.ORD_SEQ, SUM(A.ACT_WGT) WGT_IN_DEL
	          FROM TBH02_COIL_COMM A, TBE02_ORD_PRC B
	         WHERE A.ORD_NO = B.ORD_NO
	           AND A.ORD_SEQ = B.ORD_SEQ
	           AND A.ORD_FL = '1'
	           AND A.TRNF_DTIME > B.DEL_TO_DATE
	         GROUP BY (A.ORD_NO, A.ORD_SEQ)) M
	 WHERE A.ORD_NO LIKE :1 || '%' -- 参数：合同号
	   AND A.ORD_SEQ LIKE :2 || '%' -- 参数：订单号
	   AND A.ORD_NO = B.ORD_NO(+)
	   AND A.ORD_SEQ = B.ORD_SEQ(+)
	    AND A.ORD_NO = T.ORD_NO(+)
	   AND A.ORD_SEQ = T.ORD_SEQ(+)
	   AND A.ORD_NO = K.ORD_NO(+)
	   AND A.ORD_SEQ = K.ORD_SEQ(+)
	   AND A.ORD_NO = M.ORD_NO(+)
	   AND A.ORD_SEQ = M.ORD_SEQ(+)
	   AND A.CUST_CD = C.CUST_CD(+)
	   AND INSTR(NVL(:3 , A.PRD_TY) , A.PRD_TY) > 0 -- 参数：产品类型
	   AND (:4 IS NULL OR
	       A.ORD_PROG_CD IN
	       ( -- 参数：订单进度代码
	         SELECT COLUMN_VALUE
	           FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(:5) AS TABSTR_T))))
	   AND A.ABNOR_ORD_CD || '&' LIKE :6 || '%' -- 参数：异常订单类型代码
	   AND C.CUST_NM LIKE '%' || :7 || '%' --参数：客户名称
	   AND A.STL_GRD || '&' LIKE '%'||:8 || '%' -- 参数：钢号
	   AND A.DEL_TO_DATE BETWEEN :9 AND :10 -- 参数：交货日期（到达）
	   AND (:11 IS NULL OR
	       A.RCVORD_CLF IN
	       ( -- 参数：交货区分
	         SELECT COLUMN_VALUE
	           FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(:12) AS TABSTR_T))))
	   AND NVL(B.ORD_PLAN_DATA, A.DEL_TO_DATE) BETWEEN NVL(:13, '0000000') AND
	       NVL(:14, '99999999')
	   AND B.DLIV_TP || '&' LIKE :15 || '%' --运输方式，查询条件TL 091209
	   AND A.ORD_WTH BETWEEN NVL(:16, 0) AND NVL(:17, 99999999)
	   AND A.ORD_THK BETWEEN NVL(:18, 0) AND NVL(:19, 99999999)
	   AND B.XSQY || '&' LIKE :20 || '%'
	   AND A.PROD_LINE||'&' LIKE :21 || '%' -- 参数：产品类型
	   AND (B.DEST_PCD in (SELECT T.SM_CD FROM tbz00_commcd t WHERE t.lg_cd = 'A01009' and t.sm_cfnm like :22||'%')  OR :23 IS NULL)  --到站
	   AND NVL(:24,'NULL') IN (SELECT *
                 FROM TABLE(XB_PACKAGE.GF_TABSTR(A.ORD_PRC_LOCK,'|'))
                 union all
                 select 'NULL' from dual
                 )
	 ORDER BY A.ORD_NO, A.ORD_SEQ
	     
		]]>
	</query>
    
	<query id="UIE012010.OrdPrc.Arrange" desc="" fetchSize="10">
		<![CDATA[
			SELECT ORD_NO, ORD_SEQ FROM TBE02_ORD_PRC
			WHERE ORD_PROG_CD IN ('D', 'E', 'F', 'G')			
			AND 	ORD_NO IN ('432010120013')
			-- add ('F', 'G') 20090724 BY SJW
		]]>
	</query> 
</queryMap>