DBA Data[Home] [Help]

APPS.MRP_OE dependencies on OE_ORDER_LINES_ALL

Line 64: FROM oe_order_lines_all oe

60: FUNCTION available_to_mrp(p_demand_id IN NUMBER) RETURN NUMBER IS
61:
62: CURSOR AVAIL IS
63: SELECT DECODE(visible_demand_flag,'Y',1,2)
64: FROM oe_order_lines_all oe
65: WHERE line_id = p_demand_id;
66:
67: l_available_to_mrp NUMBER := 1;
68:

Line 133: FROM oe_order_lines_all oe

129: FUNCTION available_to_atp(p_demand_id IN NUMBER) RETURN NUMBER IS
130:
131: CURSOR AVAIL IS
132: SELECT DECODE(visible_demand_flag,'Y',1,2)
133: FROM oe_order_lines_all oe
134: WHERE line_id = p_demand_id;
135:
136: l_available_to_atp NUMBER := 1;
137: