APPS.MRP_OE dependencies on MRP_SALES_ORDER_UPDATES

Line 8: FROM mrp_sales_order_updates u

4: FUNCTION mrp_quantity(p_demand_id IN NUMBER) RETURN NUMBER IS
5:
6: CURSOR GET_MRP_QUANTITY IS
7: SELECT NVL(new_schedule_quantity,0)
8: FROM mrp_sales_order_updates u
9: WHERE u.sales_order_id = p_demand_id
10: AND u.process_status = 5;
11:
12: l_quantity NUMBER;

Line 36: FROM mrp_sales_order_updates u

32: FUNCTION mrp_date(p_demand_id IN NUMBER) RETURN DATE IS
33:
34: CURSOR GET_MRP_DATE IS
35: SELECT new_schedule_date
36: FROM mrp_sales_order_updates u
37: WHERE u.sales_order_id = p_demand_id
38: AND u.process_status = 5;
39:
40: l_date DATE;

Line 91: FROM mrp_sales_order_updates updates

87: SELECT '2'
88: FROM mtl_demand_om_view demand
89: WHERE ((EXISTS
90: (SELECT NULL
91: FROM mrp_sales_order_updates updates
92: WHERE updates.sales_order_id = demand.demand_id
93: AND updates.old_schedule_date = demand.requirement_date
94: AND updates.old_schedule_quantity = demand.primary_uom_quantity
95: AND updates.previous_customer_id = demand.customer_id