| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="入库待机钢卷查询">
- <query id="UIN060110_REEL_NO.Select" desc="无时间查询">
- <![CDATA[
- SELECT 'false' CHK
- ,t1.ORI_OLD_SAMPL_NO EN_COIL_NO
- ,T1.MILL_DTIME
- ,T1.OLD_SAMPL_NO EXIT_COIL_NO
- ,t2.ORD_NO||T2.ORD_SEQ ORDNO
- ,T1.ACT_WGT
- ,T1.COIL_LEN
- ,T1.COIL_WTH
- ,T1.COIL_THK
- ,T1.COIL_INDIA
- ,T1.COIL_OUTDIA
-
- from c_tbc02_coil_comm t1
- ,c_tbc02_coil_comm_d t2
- WHERE T1.OLD_SAMPL_NO = t2.L_COIL_NO(+)
- AND T1.ORI_OLD_SAMPL_NO LIKE :1||'%'
- -- and t1.COIL_STAT in ('1','2')
- and T1.LINE_TP = 'C'
- AND NVL(T1.DIVIDE_YN,'D') NOT IN ('X','Y')
- ]]>
- </query>
- <query id="UIN060230_REEL_NO.Select" desc="无时间查询">
- <![CDATA[
- SELECT 'false' CHK
- ,t1.OLD_SAMPL_NO EN_COIL_NO
- ,T1.MILL_DTIME
- ,T1.OLD_SAMPL_NO EXIT_COIL_NO
- ,t2.ORD_NO||T2.ORD_SEQ ORDNO
- ,T1.ACT_WGT
- ,T1.COIL_LEN
- ,T1.COIL_WTH
- ,T1.COIL_THK
- ,T1.COIL_INDIA
- ,T1.COIL_OUTDIA
-
- from c_tbl02_coil_comm t1
- ,c_tbl02_coil_comm_d t2
- WHERE T1.OLD_SAMPL_NO = t2.L_COIL_NO(+)
- AND T1.OLD_SAMPL_NO LIKE :1||'%'
- -- and t1.COIL_STAT in ('1','2')
- -- and T1.LINE_TP = 'C'
- -- AND NVL(T1.DIVIDE_YN,'D') NOT IN ('X','Y')
- ]]>
- </query>
- <query id="UIN060110_COIL_NO.Select" desc="无时间查询">
- <![CDATA[
- SELECT T3.C_COIL_NO EN_COIL_NO
- ,'false' CHK
- ,T2.MILL_DTIME
- ,nvl(T2.Old_Sampl_No,t3.l_coil_no) EXIT_COIL_NO
- ,T4.COIL_CUT_SEQ
- ,t4.ord_no||t4.ord_seq ORDNO
- ,T2.ACT_WGT
- ,T2.COIL_LEN
- ,T2.COIL_WTH
- ,T2.COIL_THK
- ,T2.COIL_INDIA
- ,T2.COIL_OUTDIA
- ,T1.SLEEVE_MODE SLEEVE
- FROM C_TBN02_CAL_RESULT T1
- ,C_TBC02_COIL_COMM T2
- ,L_TBF03_SPEC_MILL T3
- ,L_TBF03_SPEC_MILL_D T4
- WHERE T3.C_COIL_NO = t2.ori_old_sampl_no
- AND T2.COIL_NO = T1.EXIT_COIL_NO(+)
- AND T3.C_COIL_NO = T4.C_COIL_NO(+)
- AND T3.CAL_NO = T4.CAL_NO(+)
- AND T3.COIL_EDT_SEQ = (SELECT MAX(COIL_EDT_SEQ) FROM L_TBF03_SPEC_MILL WHERE C_COIL_NO = :1)
- AND T2.DIVIDE_YN NOT IN ('X','Y')
- ]]>
- </query>
-
- <query id="UIN060110_COIL_NO_02.Select" desc="有时间查询">
- <![CDATA[
- SELECT T3.ORD_NO||T3.ORD_SEQ ORD_NO ,t3.STL_GRD ,T1.WEIGHT_MEASURED
- ,T1.WEIGHT_CALC
- ,T1.EX_LENGTH
- ,T1.EX_DIAM_INNER
- ,T1.EX_DIAM_OUTER
- ,T1.EN_WEIGHT
- ,T1.EN_DIAM_INSIDE
- ,T1.EN_DIAM_OUTSIDE
- ,T1.EN_WIDTH
- ,T1.EN_THICK
- ,T1.EN_LENGTH
-
- FROM C_TBN02_CAL_RESULT T1
- ,C_TBC02_COIL_COMM T2
- ,L_TBF03_SPEC_MILL T3
- ,L_TBF03_SPEC_MILL_D T4
- WHERE T3.C_COIL_NO = t2.ori_old_sampl_no
- AND T2.COIL_NO = T1.EXIT_COIL_NO(+)
- AND T3.C_COIL_NO = T4.C_COIL_NO(+)
- AND T3.CAL_NO = T4.CAL_NO(+)
- AND T3.COIL_EDT_SEQ = (SELECT MAX(COIL_EDT_SEQ) FROM L_TBF03_SPEC_MILL WHERE C_COIL_NO = :1)
- AND T2.DIVIDE_YN NOT IN ('X','Y')
- ]]>
- </query>
- <query id="UIN060110_COIL_NO_03.Select" desc="有时间查询">
- <![CDATA[
- SELECT
-
- T1.TIME_END
- ,T1.TIME_START
- ,T1.DURATION
- ,T1.SCRAP_LENGTH_ENTRY_HEAD
- ,T1.SCRAP_LENTGH_ENTRY_TAIL
- ,T1.SCRAP_LENGTH_EXIT_HEAD
- ,T1.SCRAP_LENGTH_EXIT_TAIL
- ,T1.OIL_MODE
- ,T1.MIN_DEV
- ,T1.MAX_DEV
- ,T1.AVG_DEV
- ,T1.STD_DEV
- FROM C_TBN02_CAL_RESULT T1
- ,C_TBC02_COIL_COMM T2
- ,L_TBF03_SPEC_MILL T3
- ,L_TBF03_SPEC_MILL_D T4
- WHERE T3.C_COIL_NO = t2.ori_old_sampl_no
- AND T2.COIL_NO = T1.EXIT_COIL_NO(+)
- AND T3.C_COIL_NO = T4.C_COIL_NO(+)
- AND T3.CAL_NO = T4.CAL_NO(+)
- AND T3.COIL_EDT_SEQ = (SELECT MAX(COIL_EDT_SEQ) FROM L_TBF03_SPEC_MILL WHERE C_COIL_NO = :1)
- AND T2.DIVIDE_YN NOT IN ('X','Y')
- ]]>
- </query>
-
- <query id="UIN060110_CAL_RESULT.call" desc="" fetchSize="10">
- <![CDATA[
- {call C_PKG_UIN.PROD_UIN060110_CAL_RESULT(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)}
- ]]>
- </query>
- <query id="UIN060110_CAL_RESULT_NEW.call" desc="" fetchSize="10">
- <![CDATA[
- {call C_PKG_UIN_NEW.SAVE_CAL_RESULT(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)}
- ]]>
- </query>
- <query id="UIN060210_REEL_RESULT.call" desc="" fetchSize="10">
- <![CDATA[
- {call C_PKG_UIN.PROD_UIN060210_REEL_RESULT(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)}
- ]]>
- </query>
- <query id="UIN060210_REEL_RESULT_NEW.call" desc="" fetchSize="10">
- <![CDATA[
- {call C_PKG_UIN_NEW.SAVE_REEL_RESULT(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)}
- ]]>
- </query>
- <query id="UIN060230_PLTCMREEL_RESULT_NEW.call" desc="" fetchSize="10">
- <![CDATA[
- {call C_PKG_UIN_NEW.SAVE_REELPLTCM_RESULT(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)}
- ]]>
- </query>
- <query id="UIN060110_CAL_RESULT_NEW_TEMP.call" desc="临时处理" fetchSize="10">
- <![CDATA[
- {call ZL_TEST_EXP.XZ_SHIJI_TEMP(?)}
- ]]>
- </query>
-
- </queryMap>
|
