145: ,0)),
146: SUM(NVL(S.COMMITTEDSALES_QTY2
147: ,0))
148: FROM
149: IC_SUMM_INV S
150: WHERE S.ITEM_ID = CF_1FORMULA.ITEM_ID
151: AND S.WHSE_CODE = CF_1FORMULA.WHSE_CODE;
152: CURSOR QTY_ON_HAND_GRADE IS
153: SELECT
159: ,0)),
160: SUM(NVL(S.COMMITTEDSALES_QTY2
161: ,0))
162: FROM
163: IC_SUMM_INV S
164: WHERE S.ITEM_ID = CF_1FORMULA.ITEM_ID
165: AND S.WHSE_CODE = CF_1FORMULA.WHSE_CODE
166: AND S.QC_GRADE = CF_1FORMULA.QC_GRADE;
167: CURSOR GET_GRADE_CTL IS