APPS.OE_RMA_GRP dependencies on OE_ORDER_LINES

Line 200: FROM oe_order_lines

196: /* Get the total qty already returned for the referenced SO Line */
197:
198: SELECT nvl(sum(ordered_quantity), 0)
199: INTO l_already_returned
200: FROM oe_order_lines
201: WHERE reference_line_id = p_line_tbl(l_index).reference_line_id
202: AND cancelled_flag <> 'Y'
203: AND line_category_code = 'RETURN'
204: AND line_id <> p_line_tbl(l_index).line_id;

Line 210: FROM oe_order_lines

206: /* Get the originally ordered qty on referenced SO line */
207:
208: SELECT nvl(ordered_quantity, 0)
209: INTO l_original_ordered
210: FROM oe_order_lines
211: WHERE line_id = p_line_tbl(l_index).reference_line_id;
212:
213: /* Check if the quantity is Over Returned */
214: