DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on OE_ORDER_LINES_ALL

Line 221: FROM oe_order_lines_all

217: Order by l.org_id;
218:
219: CURSOR progress_pto IS
220: SELECT line_id
221: FROM oe_order_lines_all
222: WHERE header_id = l_header_id
223: AND top_model_line_id = l_line_id
224: AND item_type_code in ('MODEL','KIT','CLASS','OPTION')
225: AND ((ato_line_id is not null AND

Line 768: FROM oe_order_lines_all L

764: l_link_to_line_id,
765: l_smc_flag,
766: l_item_type_code,
767: l_schedule_status_code
768: FROM oe_order_lines_all L
769: WHERE L.open_flag = 'Y'
770: AND L.line_id = l_line_id;
771:
772: