= SUBSTR(?,1,6) ||'01'
AND SUBSTR(CASTING_END_DTIME,1,8) <= ?
GROUP BY SLAB_RT
) b
WHERE a.SLAB_RT(+) = b.SLAB_RT
ORDER BY SEQ_NO
)
UNION
SELECT '6' SEQ_NO,'S' SLAB_RT
, TO_CHAR(CH_DAY_CNT) RST_CH_CNT
, TO_CHAR(CH_DAY_WGT) RST_CH_QTY
, TO_CHAR(CH_MON_CNT) RST_CH_T_CNT
, TO_CHAR(CH_MON_WGT) RST_CH_T_QTY
FROM
(
SELECT COUNT(CHARGE_NO) CH_DAY_CNT,ROUND(SUM(NVL(CHARGE_WGT,0))/1000,2) CH_DAY_WGT
FROM TBG02_CHARGE_COMM
WHERE SUBSTR(CASTING_END_DTIME,1,8) = ?
) a,
(
SELECT COUNT(CHARGE_NO) CH_MON_CNT,ROUND(SUM(NVL(CHARGE_WGT,0))/1000,2) CH_MON_WGT
FROM TBG02_CHARGE_COMM
WHERE SUBSTR(CASTING_END_DTIME,1,8) >= SUBSTR(?,1,6) ||'01'
AND SUBSTR(CASTING_END_DTIME,1,8) <= ?
) b
]]>
= SUBSTR(?,1,6) ||'01'
AND SUBSTR(SLAB_CUT_DTIME,1,8) <=?
GROUP BY SLAB_RT
) b
WHERE a.SLAB_RT(+) = b.SLAB_RT
ORDER BY SEQ_NO
)
UNION
SELECT '6' SEQ_NO,'S' SLAB_RT
,TO_CHAR(RST_SL_CNT) RST_SL_CNT
,TO_CHAR(RST_SL_QTY) RST_SL_QTY
,TO_CHAR(RST_SL_T_CNT) RST_SL_T_CNT
,TO_CHAR(RST_SL_T_QTY) RST_SL_T_QTY
FROM
(
SELECT COUNT(SLAB_NO) RST_SL_CNT,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) RST_SL_QTY
FROM TBG02_SLAB_COMM
WHERE SLAB_RT IS NOT NULL
AND SUBSTR(SLAB_CUT_DTIME,1,8) =?
) a,
(
SELECT COUNT(SLAB_NO) RST_SL_T_CNT,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) RST_SL_T_QTY
FROM TBG02_SLAB_COMM
WHERE SLAB_RT IS NOT NULL
AND SUBSTR(SLAB_CUT_DTIME,1,8) >= SUBSTR(?,1,6) ||'01'
AND SUBSTR(SLAB_CUT_DTIME,1,8) <=?
) b
]]>
= substr(?,1,6)||'01'
AND SUBSTR(SLAB_CUT_DTIME,1,8) <= ?
GROUP BY NONORD_CAUSE_CD
)
GROUP BY MTL_CLF
) b
WHERE a.MTL_CLF(+) = b.MTL_CLF
ORDER BY b.MTL_CLF
)
UNION
SELECT '4' MTL_CLF
,TO_CHAR(NONORD_CNT) NONORD_CNT
,TO_CHAR(NONORD_QTY) NONORD_QTY
,TO_CHAR(NONORD_T_CNT) NONORD_T_CNT
,TO_CHAR(NONORD_T_QTY) NONORD_T_QTY
FROM
(
SELECT COUNT(SLAB_NO) NONORD_CNT
,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) NONORD_QTY
FROM TBG02_SLAB_COMM
WHERE NONORD_CAUSE_CD IS NOT NULL
AND SUBSTR(SLAB_CUT_DTIME,1,8) = ?
) a,
(
SELECT COUNT(SLAB_NO) NONORD_T_CNT
,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) NONORD_T_QTY
FROM TBG02_SLAB_COMM
WHERE NONORD_CAUSE_CD IS NOT NULL
AND SUBSTR(SLAB_CUT_DTIME,1,8) >= substr(?,1,6)||'01'
AND SUBSTR(SLAB_CUT_DTIME,1,8) <= ?
) b
]]>
= substr(?,1,6)||'01'
AND SUBSTR(SLAB_CUT_DTIME,1,8) <= ?
GROUP BY SLAB_REGEN_CLF
) b
WHERE a.MTL_CLF(+) = b.MTL_CLF
ORDER BY b.MTL_CLF
]]>