APPS.OE_INV_IFACE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 243: FROM oe_order_headers_all h, oe_order_types_v ot

239:
240: /* get order info */
241: SELECT /* MOAC_SQL_CHANGE */ h.order_number,ot.name,h.ordered_date
242: INTO l_order_number,l_order_type_name,l_ordered_date
243: FROM oe_order_headers_all h, oe_order_types_v ot
244: WHERE h.header_id = l_line_rec.header_id AND
245: ot.order_type_id = h.order_type_id;
246:
247: --