DBA Data[Home] [Help]

APPS.GML_ORUARPJ_XMLP_PKG dependencies on IC_SUMM_INV

Line 126: IC_SUMM_INV SUMINV

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

Line 136: IC_SUMM_INV SUMINV

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;