APPS.OE_RSCH_SETS_CONC_REQUESTS dependencies on OE_SETS

Line 269: , oe_sets s

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
273: AND h.org_id = l.org_id

Line 293: oe_sets where

289: FOR UPDATE;
290:
291: CURSOR Get_Set_Name IS
292: Select Set_Name from
293: oe_sets where
294: set_id = p_set_id;
295:
296:
297: l_start_date DATE;