APPS.WSH_USA_ACTIONS_PVT dependencies on OE_ORDER_LINES

Line 540: from oe_order_lines

536: /*Bug#8373924*/
537: l_line_ordered_quantinty2 NUMBER;
538: cursor ordered_quantity2(l_source_line_id NUMBER) IS
539: select ordered_quantity2
540: from oe_order_lines
541: where line_id = l_source_line_id;
542:
543: -- muom
544: l_fulfillment_base VARCHAR2(1);

Line 3444: FROM oe_order_lines_all

3440: -- for instance in Import Del. Details.
3441:
3442: CURSOR C_OE_LINES_REC_LOCK (c_line_id NUMBER) is
3443: SELECT line_id
3444: FROM oe_order_lines_all
3445: --FROM oe_delivery_lines_v
3446: WHERE line_id = c_line_id
3447: and nvl(shipping_interfaced_flag, 'N') = 'N'
3448: FOR UPDATE NOWAIT;