DBA Data[Home] [Help]

APPS.INV_MOVE_ORDER_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 304: from oe_order_headers_all h

300: where h.header_id = V_header_id;
301: -- 6689912
302: CURSOR get_sales_order (V_line_id NUMBER) IS
303: select h.order_number , l.org_id -- 6689912 added org_id
304: from oe_order_headers_all h
305: ,oe_order_lines_all l
306: where l.header_id = h.header_id
307: and l.line_id = V_line_id;
308:

Line 310: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

306: where l.header_id = h.header_id
307: and l.line_id = V_line_id;
308:
309: l_org_id number; -- 6689912
310: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
311: l_move_order_type MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE%TYPE;
312: l_error_code NUMBER;
313: l_msg_data VARCHAR2(240);
314: