DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 7761: FROM oe_order_lines_all sl

7757: p_use_open_quantity), 0))
7758: order_quantity,
7759: --end of fix bug#3417588
7760: split_from_line_id parent_line_id
7761: FROM oe_order_lines_all sl
7762: WHERE header_id = i_header_id
7763: AND inventory_item_id = i_item_id
7764: ORDER BY sl.line_id;
7765:

Line 7775: FROM oe_order_lines_all

7771: BEGIN
7772: -- get the header and item id
7773: SELECT header_id, inventory_item_id
7774: INTO l_header_id, l_item_id
7775: FROM oe_order_lines_all
7776: WHERE line_id = to_number(p_demand_source_line);
7777:
7778: -- get all potentially relevant lines
7779: l_lines.DELETE;

Line 7915: FROM oe_order_lines_all

7911: BEGIN
7912: IF p_demand_source_type = 2 THEN
7913: SELECT split_from_line_id
7914: INTO l_split_from_line
7915: FROM oe_order_lines_all
7916: WHERE line_id = to_number(p_demand_source_line);
7917: END IF;
7918:
7919: IF l_split_from_line IS NOT NULL THEN