= :1 AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 ) <= :2 AND T1.CRK_CD1 IN (SELECT SM_CD FROM TBZ00_COMMCD WHERE SM_CFNM LIKE ('%'||:3||'%') AND LG_CD = 'G03004') AND NVL(T2.CC_DEVNO,'NULL') LIKE :4 ORDER BY T2.CC_DEVNO,SUBSTR(T1.SLAB_NO, 1, 10),T1.SLAB_NO ]]> = :1 AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 ) <= :2 AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' AND T1.CRK_CD1 IS NULL)) OR (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50')))) AND NVL(T2.CC_DEVNO,'NULL') LIKE :3 ORDER BY T2.CC_DEVNO,SUBSTR(T1.SLAB_NO, 1, 10),T1.SLAB_NO ]]> = :1 AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 ) <= :2 AND NVL(T2.CC_DEVNO,'NULL') LIKE :3 ORDER BY T2.CC_DEVNO,SUBSTR(T1.SLAB_NO, 1, 10),T1.SLAB_NO ]]> = :1 AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 ) <= :2 AND NVL(T2.CC_DEVNO,'NULL') LIKE :3 ORDER BY T2.CC_DEVNO,SUBSTR(T1.SLAB_NO, 1, 10),T1.SLAB_NO ]]>