DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 7788: FROM oe_order_lines_all sl

7784: p_use_open_quantity), 0))
7785: order_quantity,
7786: --end of fix bug#3417588
7787: split_from_line_id parent_line_id
7788: FROM oe_order_lines_all sl
7789: WHERE header_id = i_header_id
7790: AND inventory_item_id = i_item_id
7791: ORDER BY sl.line_id;
7792:

Line 7802: FROM oe_order_lines_all

7798: BEGIN
7799: -- get the header and item id
7800: SELECT header_id, inventory_item_id
7801: INTO l_header_id, l_item_id
7802: FROM oe_order_lines_all
7803: WHERE line_id = to_number(p_demand_source_line);
7804:
7805: -- get all potentially relevant lines
7806: l_lines.DELETE;

Line 7942: FROM oe_order_lines_all

7938: BEGIN
7939: IF p_demand_source_type = 2 THEN
7940: SELECT split_from_line_id
7941: INTO l_split_from_line
7942: FROM oe_order_lines_all
7943: WHERE line_id = to_number(p_demand_source_line);
7944: END IF;
7945:
7946: IF l_split_from_line IS NOT NULL THEN