DBA Data[Home] [Help]

APPS.OE_INV_IFACE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 230: FROM oe_order_headers_all h, oe_order_types_v ot

226:
227: /* get order info */
228: SELECT /* MOAC_SQL_CHANGE */ h.order_number,ot.name,h.ordered_date
229: INTO l_order_number,l_order_type_name,l_ordered_date
230: FROM oe_order_headers_all h, oe_order_types_v ot
231: WHERE h.header_id = l_line_rec.header_id AND
232: ot.order_type_id = h.order_type_id;
233:
234: --