APPS.MRP_RELEASE_SO dependencies on OE_ORDER_LINES_ALL

Line 25: from oe_order_lines_all

21:
22: CURSOR line_c(p_line_id number) is
23: select header_id, top_model_line_id,org_id, item_type_code,
24: order_quantity_uom
25: from oe_order_lines_all
26: where line_id = p_line_id;
27:
28:
29: CURSOR mtl_primary_uom (p_item_id NUMBER, p_org_id NUMBER) IS

Line 39: FROM oe_order_lines_all l,

35: CURSOR ord_num_c(p_line_id number) IS
36: SELECT h.order_number ,
37: l.line_number||'.'|| l.shipment_number ||'.'||
38: l.option_number ||'.'|| l.component_number ||'.'||l.service_number
39: FROM oe_order_lines_all l,
40: oe_order_headers_all h
41: WHERE l.header_id = h.header_id
42: AND l.line_id = p_line_id;
43:

Line 60: from oe_order_lines_all

56: select line_id,
57: header_id,
58: org_id,
59: nvl(ship_model_complete_flag,'N') ship_model_complete_flag
60: from oe_order_lines_all
61: where top_model_line_id = p_top_model_line_id
62: and line_id <> p_line_id
63: order by header_id;
64:

Line 411: -- bug 7537394, get operating_unit from oe_order_lines_all

407:
408: addHeaderList(p_so_table(i).header_id);
409:
410: if p_so_table(i).org_id <> p_org_id then
411: -- bug 7537394, get operating_unit from oe_order_lines_all
412: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id for line_id = '||p_so_table(i).line_id||' is changed to '||p_org_id ||' from '||p_so_table(i).org_id);
413: p_so_table(i).org_id := p_org_id;
414: end if;
415: