| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="UID050010">
- <query id="UID050010.planRoll.select" desc="指示确认时查询浇次信息">
- <![CDATA[
- SELECT 'ROLL计划数' AS WTH_GRP_CD1
- ,'ROLL计划数' AS WTH_GRP_CD2
- ,D_00_CNT AS ELMT_FACTOR_00
- ,D_01_CNT AS ELMT_FACTOR_01
- ,D_02_CNT AS ELMT_FACTOR_02
- ,D_03_CNT AS ELMT_FACTOR_03
- ,D_04_CNT AS ELMT_FACTOR_04
- ,D_05_CNT AS ELMT_FACTOR_05
- ,D_06_CNT AS ELMT_FACTOR_06
- ,D_07_CNT AS ELMT_FACTOR_07
- ,D_08_CNT AS ELMT_FACTOR_08
- ,D_09_CNT AS ELMT_FACTOR_09
- ,D_00_CNT
- +D_01_CNT
- +D_02_CNT
- +D_03_CNT
- +D_04_CNT
- +D_05_CNT
- +D_06_CNT
- +D_07_CNT
- +D_08_CNT
- +D_09_CNT AS ELMT_FACTOR_SUM
- FROM (SELECT * FROM TBD00_PLAN_ROLL WHERE PLAN_SEQ = (SELECT MAX(PLAN_SEQ) FROM TBD00_PLAN_ROLL))
- UNION ALL
- SELECT '材料预定使用量' AS WTH_GRP_CD1
- , DECODE(Y.RN, 1, X.WTH_GRP_CD, '小计') AS WTH_GRP_CD2
- , SUM(ELMT_FACTOR_00 ) AS ELMT_FACTOR_00
- , SUM(ELMT_FACTOR_01 ) AS ELMT_FACTOR_01
- , SUM(ELMT_FACTOR_02 ) AS ELMT_FACTOR_02
- , SUM(ELMT_FACTOR_03 ) AS ELMT_FACTOR_03
- , SUM(ELMT_FACTOR_04 ) AS ELMT_FACTOR_04
- , SUM(ELMT_FACTOR_05 ) AS ELMT_FACTOR_05
- , SUM(ELMT_FACTOR_06 ) AS ELMT_FACTOR_06
- , SUM(ELMT_FACTOR_07 ) AS ELMT_FACTOR_07
- , SUM(ELMT_FACTOR_08 ) AS ELMT_FACTOR_08
- , SUM(ELMT_FACTOR_09 ) AS ELMT_FACTOR_09
- , SUM(ELMT_FACTOR_SUM) AS ELMT_FACTOR_SUM FROM(SELECT A.WTH_GRP_CD, A.MINI, A.MAXI
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_00_CNT,0) AS ELMT_FACTOR_00
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_01_CNT,0) AS ELMT_FACTOR_01
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_02_CNT,0) AS ELMT_FACTOR_02
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_03_CNT,0) AS ELMT_FACTOR_03
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_04_CNT,0) AS ELMT_FACTOR_04
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_05_CNT,0) AS ELMT_FACTOR_05
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_06_CNT,0) AS ELMT_FACTOR_06
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_07_CNT,0) AS ELMT_FACTOR_07
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_08_CNT,0) AS ELMT_FACTOR_08
- , NVL(A.ELMT_FACTOR,0) * NVL(B.D_09_CNT,0) AS ELMT_FACTOR_09
- , NVL(A.ELMT_FACTOR,0) *(NVL(B.D_00_CNT,0)
- + NVL(B.D_01_CNT,0)
- + NVL(B.D_02_CNT,0)
- + NVL(B.D_03_CNT,0)
- + NVL(B.D_04_CNT,0)
- + NVL(B.D_05_CNT,0)
- + NVL(B.D_06_CNT,0)
- + NVL(B.D_07_CNT,0)
- + NVL(B.D_08_CNT,0)
- + NVL(B.D_09_CNT,0)) AS ELMT_FACTOR_SUM
- FROM(SELECT WTH_GRP_CD, MINI, MAXI
- , DECODE(NVL(:1,'1'), '1', SLAB_CNT, '2', UNIT_SLAB_WGT) AS ELMT_FACTOR
- FROM TBF02_ROLL_WTH_GRP
- ORDER BY PLT, WTH_GRP_CD) A
- , (SELECT * FROM TBD00_PLAN_ROLL WHERE PLAN_SEQ = (SELECT MAX(PLAN_SEQ) FROM TBD00_PLAN_ROLL)) B) X
- ,(SELECT RNUM AS RN FROM TBZ00_COPY WHERE RNUM <= 2) Y
- GROUP BY DECODE(Y.RN, 1, X.WTH_GRP_CD, '小计')
- ORDER BY 2
- ]]>
- </query>
-
- <query id="UID050010.planRoll.insert" desc="指示确认时查询浇次信息">
- <![CDATA[
- INSERT INTO TBD00_PLAN_ROLL( PLAN_SEQ
- ,D_00_CNT
- ,D_01_CNT
- ,D_02_CNT
- ,D_03_CNT
- ,D_04_CNT
- ,D_05_CNT
- ,D_06_CNT
- ,D_07_CNT
- ,D_08_CNT
- ,D_09_CNT
- ,REG_ID
- ,REG_DTIME
- ,MOD_ID
- ,MOD_DTIME)
- SELECT MAX(PLAN_SEQ)+1
- ,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,:12,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- from TBD00_PLAN_ROLL
-
- ]]>
- </query>
- </queryMap>
|
