1430) THEN 1450 ELSE TO_NUMBER(SM_CD) + 50 END AS SLAB_WTH , CD_SEQ FROM TBZ00_COMMCD WHERE LG_CD = 'D01001' AND USED_YN = 'Y') A ,(SELECT TO_NUMBER(SM_CD) AS SLAB_THK FROM TBZ00_COMMCD WHERE LG_CD = 'D01002'AND USED_YN = 'Y') B ,(SELECT MIN(DECODE(CD_SEQ,1,TO_NUMBER(SM_CD))) AS SLAB_TYPE1_MIN_LEN , MAX(DECODE(CD_SEQ,2,TO_NUMBER(SM_CD))) AS SLAB_TYPE1_MAX_LEN , MIN(DECODE(CD_SEQ,3,TO_NUMBER(SM_CD))) AS SLAB_TYPE2_MIN_LEN , MAX(DECODE(CD_SEQ,4,TO_NUMBER(SM_CD))) AS SLAB_TYPE2_MAX_LEN FROM TBZ00_COMMCD WHERE LG_CD = 'D01003' AND USED_YN = 'Y') C ,(SELECT TO_NUMBER(SM_CD) AS GRAVITY FROM TBZ00_COMMCD WHERE LG_CD = 'D01006') D ORDER BY A.CD_SEQ) Y WHERE Y.SLAB_THK = X.SLAB_THK(+) AND Y.SLAB_WTH = X.SLAB_WTH(+) ]]>