?
]]>
?
ORDER BY A.ROLL_MANA_NO
]]>
?
MINUS
SELECT CHG_ROLL_MANA_NO
FROM TBF02_CHG_ROLL) C
WHERE A.ROLL_MANA_NO = C.ROLL_MANA_NO
ORDER BY A.ROLL_MANA_NO
]]>
?
MINUS
SELECT CHG_ROLL_MANA_NO
FROM TBF02_CHG_ROLL) D
WHERE A.ROLL_MANA_NO = D.ROLL_MANA_NO
AND A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
ORDER BY A.ROLL_MANA_NO
,A.ROLL_SLAB_SEQ
]]>
?
MINUS
SELECT CHG_ROLL_MANA_NO
FROM TBF02_CHG_ROLL) D
WHERE A.ROLL_MANA_NO = D.ROLL_MANA_NO
AND A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
ORDER BY A.ROLL_MANA_NO
,A.ROLL_SLAB_SEQ
]]>
?
MINUS
SELECT CHG_ROLL_MANA_NO
FROM TBF02_CHG_ROLL) C
WHERE A.ROLL_MANA_NO = C.ROLL_MANA_NO
]]>
?
ORDER BY A.ORG_SEQ
]]>
?
AND A.FL IS NULL
]]>
?
AND A.FL IS NULL
]]>
?
AND A.FL IS NULL
]]>
?
AND FL = ? ) C
WHERE A.ROLL_MANA_NO = C.CHG_ROLL_MANA_NO
ORDER BY A.ROLL_MANA_NO
]]>
?
AND FL = ? ) D
WHERE A.ROLL_MANA_NO = D.CHG_ROLL_MANA_NO
AND A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
ORDER BY A.ROLL_MANA_NO
,A.ROLL_SLAB_SEQ
]]>
?
AND FL = ? ) D
WHERE A.ROLL_MANA_NO = D.CHG_ROLL_MANA_NO
AND A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
ORDER BY A.ROLL_MANA_NO
,A.ROLL_SLAB_SEQ
]]>
?
AND FL = ? ) C
WHERE A.ROLL_MANA_NO = C.CHG_ROLL_MANA_NO
ORDER BY A.ROLL_MANA_NO
,A.ROLL_SLAB_SEQ
]]>
?) C
WHERE C.SLAB_EDT_SEQ = A.SLAB_EDT_SEQ)
,A.ROLL_EDT_SEQ = ?
WHERE A.ROLL_MANA_NO = ?
AND A.ROLL_SLAB_SEQ > ?
]]>