APPS.RLM_EXTINTERFACE_SV dependencies on OE_ORDER_LINES_ALL

Line 626: FROM oe_order_lines_all

622: BEGIN
623:
624: SELECT ordered_item
625: INTO v_item_name
626: FROM oe_order_lines_all
627: WHERE line_id = oe_msg_pub.g_msg_tbl(i).line_id;
628:
629: IF (l_debug <> -1) THEN
630: rlm_core_sv.dlog(k_DEBUG,'v_item_name',v_item_name);

Line 2000: FROM oe_order_lines_all

1996: -- Making the change to reflect the changes OM made for in OEXFLINB.pls for 1172817
1997: --
1998: SELECT flow_status_code
1999: INTO v_status_code
2000: FROM oe_order_lines_all
2001: where line_id = x_OrderLineId;
2002: --
2003: IF v_status_code <> 'AWAITING_SHIPPING' AND
2004: v_status_code <> 'PRODUCTION_COMPLETE' AND

Line 2010: FROM oe_lookups a, oe_order_lines_all b

2006: v_status_code <> 'PICKED_PARTIAL' THEN
2007: --
2008: SELECT a.meaning
2009: INTO v_line_status
2010: FROM oe_lookups a, oe_order_lines_all b
2011: WHERE a.lookup_type like 'LINE_FLOW_STATUS'
2012: AND a.lookup_code = b.flow_status_code
2013: AND b.line_id = x_OrderLineId;
2014: --