DBA Data[Home] [Help]

APPS.OE_RSCH_SETS_CONC_REQUESTS dependencies on OE_ORDER_HEADERS

Line 267: FROM oe_order_headers h

263: l_set_name varchar2(240);
264: /* MOAC_SQL_CHANGE */
265: CURSOR Line_Set(l_start_date DATE,l_end_date DATE) IS
266: SELECT distinct l.ship_set_id, h.order_number
267: FROM oe_order_headers h
268: ,oe_order_lines_all l
269: , oe_sets s
270: WHERE h.order_number >= nvl(p_order_number_low,h.order_number)
271: AND h.order_number <= nvl(p_order_number_high,h.order_number)