SQLize Online / PHPize Online  /  SQLtest Online

SELECT COUNT(*) INTO CNT_SLS FROM INTG.PRD_MATL_DIST_CHNL_N A WHERE A.MATL_NBR = L_MAT_HIER_CD AND A.DISTR_CHN_LVL_DEL_FG <> 'Y' AND A.SLS_ORG_CD IN ('YCUS','GMUS') AND A.DISTR_CHNL_CD = 'FS'; IF CNT_SLS = 0 THEN L_SLS_ORG_CD := NULL; ELSE SELECT NULLIF(SLS_ORG_CD,NULL) INTO L_SLS_ORG_CD FROM INTG.PRD_MATL_DIST_CHNL_N A WHERE A.MATL_NBR = L_MAT_HIER_CD AND A.DISTR_CHN_LVL_DEL_FG <> 'Y' AND A.SLS_ORG_CD IN ('YCUS','GMUS') AND A.DISTR_CHNL_CD = 'FS'; END IF;