DBA Data[Home] [Help]

APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1514: from oe_order_headers_all h, oe_order_lines_all l

1510: select decode (h.source_document_type_id, 10,
1511: inv_reservation_global.g_source_type_internal_ord,
1512: inv_reservation_global.g_source_type_oe )
1513: into l_demand_source_type_id
1514: from oe_order_headers_all h, oe_order_lines_all l
1515: where h.header_id = l.header_id
1516: and l.line_id = p_demand_source_line_id;
1517:
1518: l_rsv.demand_source_type_id := l_demand_source_type_id;

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

3240: --get the sales order header for the sales order line
3241: --the interface table does not have the sales order header information
3242: --
3243: /* Bug 2693130: Changed the table name in the following cursor
3244: from 'oe_order_lines' to 'oe_order_lines_all' */
3245:
3246: CURSOR get_sales_order_line(v_demand_line_id IN NUMBER) IS
3247: SELECT header_id
3248: , ordered_quantity

Line 3250: FROM oe_order_lines_all

3246: CURSOR get_sales_order_line(v_demand_line_id IN NUMBER) IS
3247: SELECT header_id
3248: , ordered_quantity
3249: , order_quantity_uom
3250: FROM oe_order_lines_all
3251: WHERE line_id = v_demand_line_id
3252: AND cancelled_flag = 'N';
3253:
3254: --