APPS.MRP_OE dependencies on MTL_DEMAND

Line 88: FROM mtl_demand_om_view demand

84: FUNCTION updated_flag(p_demand_id IN NUMBER) RETURN NUMBER IS
85:
86: CURSOR GET_UPDATED_FLAG IS
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

Line 158: FROM mtl_demand MD1

154: total_reservation_quantity NUMBER := 0;
155: BEGIN
156: SELECT SUM(NVL(MD1.PRIMARY_UOM_QUANTITY,0))
157: INTO total_reservation_quantity
158: FROM mtl_demand MD1
159: WHERE
160: MD1.DEMAND_SOURCE_LINE = to_char(p_demand_id)
161: AND NVL(MD1.DEMAND_SOURCE_TYPE,2) IN (2,8,12)
162: AND NVL(MD1.RESERVATION_TYPE,2) IN (2,3);