XinYu_RZMES/.svn/pristine/02/02e701c26568b08f6ff274146f933b8bb41d0a21.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
    <query id="UIG040021_INIT.select" desc="   " fetchSize="10">
        <![CDATA[
		 select yard_addr from tbg04_std_slab_yard where yard_addr like 'L%'
        ]]>
    </query> 
    <query id="UIG040021_01.select" desc="板坯库中所有位置的板坯数" fetchSize="10">
        <![CDATA[
			SELECT   
			L01A1,L01A2,L01A3,L01A4,L01A5,L01A6
        ,L01B1,L01B2,L01B3,L01B4,L01B5,L01B6
        ,L01C1,L01C2,L01C3,L01C4,L01C5,L01C6
        ,L01D1,L01D2,L01D3,L01D4,L01D5,L01D6
        ,L02A1,L02A2,L02A3,L02A4,L02A5,L02A6
        ,L02B1,L02B2,L02B3,L02B4,L02B5,L02B6
        ,L02C1,L02C2,L02C3,L02C4,L02C5,L02C6
        ,L02D1,L02D2,L02D3,L02D4,L02D5,L02D6
        ,L03A1,L03A2,L03A3,L03A4,L03A5,L03A6
        ,L03B1,L03B2,L03B3,L03B4,L03B5,L03B6
        ,L03C1
        ,L03C2
        ,L03C3
        ,L03C4
        ,L03C5
        ,L03D6
        ,L03D1
        ,L03D2
        ,L03D3
        ,L03D4
        ,L03D5
        ,L03D6
        ,L04A1
        ,L04A2
        ,L04A3
        ,L04A4
        ,L04A5
        ,L04A6
        ,L04B1
        ,L04B2
        ,L04B3
        ,L04B4
        ,L04B5
        ,L04B6
        ,L04C1
        ,L04C2
        ,L04C3
        ,L04C4
        ,L04C5
        ,L04C6
        ,L04D1
        ,L04D2
        ,L04D3
        ,L04D4
        ,L04D5
        ,L04D6
        ,L05A1
        ,L05A2
        ,L05A3
        ,L05A4
        ,L05A5
        ,L05A6
        ,L05B1
        ,L05B2
        ,L05B3
        ,L05B4
        ,L05B5
        ,L05B6
        ,L05C1
        ,L05C2
        ,L05C3
        ,L05C4
        ,L05C5
        ,L05C6
        ,L05D1
        ,L05D2
        ,L05D3
        ,L05D4
        ,L05D5
        ,L05D6
        ,L06A1
        ,L06A2
        ,L06A3
        ,L06A4
        ,L06A5
        ,L06A6
        ,L06B1
        ,L06B2
        ,L06B3
        ,L06B4
        ,L06B5
        ,L06B6
        ,L06C1
        ,L06C2
        ,L06C3
        ,L06C4
        ,L06C5
        ,L06C6
        ,L06D1
        ,L06D2
        ,L06D3
        ,L06D4
        ,L06D5
        ,L06D6
        ,L07A1
        ,L07A2
        ,L07A3
        ,L07A4
        ,L07A5
        ,L07A6
        ,L07B1
        ,L07B2
        ,L07B3
        ,L07B4
        ,L07B5
        ,L07B6
        ,L07C1
        ,L07C2
        ,L07C3
        ,L07C4
        ,L07C5
        ,L07C6
        ,L07D1
        ,L07D2
        ,L07D3
        ,L07D4
        ,L07D5
        ,L07D6
        ,L08A1
        ,L08A2
        ,L08A3
        ,L08A4
        ,L08A5
        ,L08A6
        ,L08B1
        ,L08B2
        ,L08B3
        ,L08B4
        ,L08B5
        ,L08B6
        ,L08C1
        ,L08C2
        ,L08C3
        ,L08C4
        ,L08C5
        ,L08C6
        ,L08D1
        ,L08D2
        ,L08D3
        ,L08D4
        ,L08D5
        ,L08D6
        ,L09A1
        ,L09A2
        ,L09A3
        ,L09A4
        ,L09A5
        ,L09A6
        ,L09A7

       FROM
            (SELECT COUNT(YARD_ADDR) L01A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L01D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L01D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D2'  AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L02D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L02D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L03D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L03D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L04D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L04D6' AND SLAB_NO IS NOT NULL) ,
            (SELECT COUNT(YARD_ADDR) L05A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L05D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L05D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L06D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L06D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L07D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L07D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08B6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08B6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08C6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08C6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L08D6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L08D6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A1  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A1' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A2  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A2' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A3  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A3' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A4  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A4' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A5  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A5' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A6  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A6' AND SLAB_NO IS NOT NULL),
            (SELECT COUNT(YARD_ADDR) L09A7  FROM TBG04_SLAB_YARD WHERE YARD_ADDR = 'L09A7' AND SLAB_NO IS NOT NULL) 
        ]]>
    </query>  
    <query id="UIG040021_TOT.select" desc=" UIG040030 INTI_PARAM   ">
        <![CDATA[
       SELECT
            ALL_T_CNT,PL_SLAB_CNT,CORR_DIR_SLAB_CNT,CORR_RST_SLAB_CNT,
            ORD_SLAB_CNT,NONORD_SLAB_CNT
       FROM 
       ( 
        SELECT  COUNT(slab_no) ALL_T_CNT
 	     FROM TBG04_SLAB_YARD  
	     WHERE  YARD_ADDR like 'L%'
	   ) a ,
	   ( 
         SELECT  count(a.SLAB_NO) PL_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE SUBSTR(PRODNM_CD,1,1) = 'P'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) b,
	   ( 
         SELECT  count(a.SLAB_NO) CORR_DIR_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE CORRECT_RSLT_CD = '1'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) c, 
	   ( 
         SELECT  count(a.SLAB_NO) CORR_RST_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE CORRECT_RSLT_CD = '2'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) d ,
	   ( 
         SELECT  count(a.SLAB_NO) ORD_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE ORD_FL = '1'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) e,
	   ( 
         SELECT  count(a.SLAB_NO) NONORD_SLAB_CNT
           FROM TBG04_SLAB_YARD a,
                TBG02_SLAB_COMM b  
		   WHERE ORD_FL = '2'
		     AND  a.SLAB_NO = b.SLAB_NO    
		     AND  YARD_ADDR like 'L%'
	   ) f     
        ]]>
    </query>
</queryMap>