DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on OE_ORDER_LINES_ALL

Line 2198: FROM OE_ORDER_LINES_ALL

2194: -- could be multiple move orders per sales order line.
2195: BEGIN
2196: SELECT ordered_quantity, order_quantity_uom
2197: INTO l_cur_txn_source_req_qty, l_txn_source_line_uom
2198: FROM OE_ORDER_LINES_ALL
2199: WHERE line_id = l_cur_txn_source_line_id;
2200: EXCEPTION
2201: WHEN NO_DATA_FOUND then
2202: If is_debug then

Line 2319: FROM OE_ORDER_LINES_ALL

2315: -- Bug 3340502, fetching order_quantity_uom in variable
2316: -- l_txn_source_line_uom instead of l_set_txn_source_uom
2317: SELECT ordered_quantity, order_quantity_uom
2318: INTO l_set_txn_source_req_qty, l_txn_source_line_uom
2319: FROM OE_ORDER_LINES_ALL
2320: WHERE line_id = l_set_txn_source_line_id;
2321: EXCEPTION
2322: WHEN NO_DATA_FOUND then
2323: If is_debug then