APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1489: from oe_order_headers_all h, oe_order_lines_all l

1485: select decode (h.source_document_type_id, 10,
1486: inv_reservation_global.g_source_type_internal_ord,
1487: inv_reservation_global.g_source_type_oe )
1488: into l_demand_source_type_id
1489: from oe_order_headers_all h, oe_order_lines_all l
1490: where h.header_id = l.header_id
1491: and l.line_id = p_demand_source_line_id;
1492:
1493: l_rsv.demand_source_type_id := l_demand_source_type_id;

Line 3239: from 'oe_order_lines' to 'oe_order_lines_all' */

3235: --get the sales order header for the sales order line
3236: --the interface table does not have the sales order header information
3237: --
3238: /* Bug 2693130: Changed the table name in the following cursor
3239: from 'oe_order_lines' to 'oe_order_lines_all' */
3240: /* Bug 8524455, get the unit of measure and uom code also */
3241: CURSOR get_sales_order_line(v_demand_line_id IN NUMBER) IS
3242: SELECT oel.header_id
3243: , oel.ordered_quantity

Line 3246: FROM oe_order_lines_all oel

3242: SELECT oel.header_id
3243: , oel.ordered_quantity
3244: , oel.order_quantity_uom
3245: , muom.unit_of_measure
3246: FROM oe_order_lines_all oel
3247: , mtl_units_of_measure muom
3248: WHERE oel.line_id = v_demand_line_id
3249: AND cancelled_flag = 'N'
3250: AND oel.order_quantity_uom = muom.uom_code;