122: SUM(SUMINV.COMMITTEDSALES_QTY),
123: SUM(SUMINV.COMMITTEDPROD_QTY)
124: INTO V_SHIP_QTY,V_COMMITTEDSALES_QTY,V_COMMITTEDPROD_QTY
125: FROM
126: IC_SUMM_INV SUMINV
127: WHERE SUMINV.ITEM_ID = ITEM_ID_1
128: AND SUMINV.WHSE_CODE = FROM_WHSE;
129: ELSE
130: SELECT
132: SUM(SUMINV.COMMITTEDSALES_QTY),
133: SUM(SUMINV.COMMITTEDPROD_QTY)
134: INTO V_SHIP_QTY,V_COMMITTEDSALES_QTY,V_COMMITTEDPROD_QTY
135: FROM
136: IC_SUMM_INV SUMINV
137: WHERE SUMINV.ITEM_ID = ITEM_ID_1
138: AND SUMINV.WHSE_CODE = FROM_WHSE
139: AND SUMINV.QC_GRADE = QC_GRADE_WANTED;
140: END IF;