DBA Data[Home] [Help]

APPS.OE_RSCH_SETS_CONC_REQUESTS dependencies on OE_ORDER_LINES_ALL

Line 268: ,oe_order_lines_all l

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)
272: AND h.header_id = l.header_id