APPS.FLM_MMM_CALCULATION dependencies on MRP_UNSCHEDULED_ORDERS_V

Line 153: /* performance bug 14597218 - try avoid using view mrp_unscheduled_orders_v */

149: );
150:
151:
152: -- cursor to retrieve sales orders and planned orders
153: /* performance bug 14597218 - try avoid using view mrp_unscheduled_orders_v */
154: /* use two more cursors instead*/
155: /* CURSOR order_entries(i_option IN NUMBER) IS
156: SELECT DISTINCT
157: inventory_item_id item_id,

Line 159: FROM mrp_unscheduled_orders_v

155: /* CURSOR order_entries(i_option IN NUMBER) IS
156: SELECT DISTINCT
157: inventory_item_id item_id,
158: line_id
159: FROM mrp_unscheduled_orders_v
160: WHERE organization_id = i_organization_id
161: AND trunc(order_date) BETWEEN i_start_date AND i_end_date
162: AND unscheduled_order_option = i_option;
163: */

Line 340: FROM mrp_unscheduled_orders_v

336:
337: -- cursor to retrieve demand days on a line, in case of Sales and Planned Orders
338: CURSOR unschedule_days(i_line_id IN NUMBER, i_option IN NUMBER) IS
339: SELECT count(distinct(to_char(order_date))) num_days
340: FROM mrp_unscheduled_orders_v
341: WHERE organization_id = i_organization_id
342: AND line_id = i_line_id
343: AND trunc(order_date) BETWEEN i_start_date AND i_end_date
344: AND unscheduled_order_option = i_option;