XinYu_RZMES/.svn/pristine/f2/f21de730f4821dfc6b42c25f57456623ffe01108.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏设计结果查询">

    <query id="SearchFacStlGrd.Select" desc="SearchFacStlGrd.Select" fetchSize="10">
        <![CDATA[
SELECT '(ALL)' AS FAC_STL_GRDNM, '%' AS FAC_STL_GRD FROM DUAL
UNION ALL
SELECT A.FAC_STL_GRDNM, A.FAC_STL_GRD
FROM TBD00_STLGRD A
WHERE EXISTS (SELECT 'X'
              FROM TBD01_SLABDN_RST B
              WHERE B.FAC_STL_GRD = A.FAC_STL_GRD)
        ]]>
    </query>

    <query id="SearchProcPathCd.Select" desc="SearchFacStlGrd.Select" fetchSize="10">
        <![CDATA[
SELECT 0 AS CD_SEQ, '(ALL)' AS PROC_PATH_NM, '%' AS PROC_PATH  FROM DUAL
UNION ALL
SELECT A.CD_SEQ, A.SM_CFNM, A.SM_CD
FROM TBZ00_COMMCD A
WHERE A.LG_CD = 'F01001'
AND A.SM_CD LIKE 'J%'
ORDER BY 1
        ]]>
    </query>

    <query id="SearchSlabDnRst.Select" desc="SearchFacStlGrd.Select" fetchSize="10">
        <![CDATA[
SELECT A.DSN_SLAB_NO, A.P_DSN_SLAB_NO
     , A.ORD_NO, A.ORD_SEQ
     , A.SLAB_THK, A.SLAB_WTH, A.SLAB_LEN, A.SLAB_WGT
     , A.SLAB_TRMTH_TP
     , A.GRAVITY
     , A.AUTODSN_YN
     , A.COIL_PACK_WGT_MIN, A.COIL_PACK_WGT_MAX
     , A.FAC_STL_GRD
     , A.COIL_THK, A.COIL_WTH, A.COIL_LEN, A.COIL_WGT
     , A.PROC_PATH
     , A.HCR_YN
     , A.EMGMTR_YN
     , A.FAC_STL_GRP
     , A.COMB_YN
     , A.COIL_INDIA, A.COIL_OUTDIA
     , B.SPEC_ABBSYM, B.SPEC_STL_GRD, B.PRDNM_CD, LEVEL AS LVL
     ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN 
FROM TBD01_SLABDN_RST A
   ,(SELECT X.ORD_NO, X.ORD_SEQ, Y.SPEC_ABBSYM, Y.SPEC_STL_GRD, Z.PRDNM_CD
     FROM TBD01_SLABDN_OBJ X, TBA01_ORD_LINE Y, TBA01_ORD_COMM Z
     WHERE X.ORD_NO = Y.ORD_NO
     AND X.ORD_SEQ = Y.ORD_SEQ
     AND Y.ORD_NO = Z.ORD_NO
     AND X.DSN_PROC_STAT = '2') B
   ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
					  FROM TBB01_ORD_INGR
					 WHERE DSN_KIND = '1') K
WHERE 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.FAC_STL_GRD LIKE :1||'%'
AND A.PROC_PATH LIKE '%'||:2||'%'
AND NVL(:3, 0) < A.SLAB_WTH AND A.SLAB_WTH <= NVL(:4, 9999)
START WITH A.P_DSN_SLAB_NO IS NULL
CONNECT BY PRIOR A.DSN_SLAB_NO = A.P_DSN_SLAB_NO
/*** ORDER SIBLINGS BY A.DSN_SLAB_NO DESC ***/
        ]]>
    </query>

</queryMap>