APPS.MRP_GRAPH_LINE_CAPACITY dependencies on MRP_FORM_QUERY

Line 58: mrp_form_query mfq

54: bom_department_resources bdr,
55: bom_resource_shifts brs,
56: bom_shift_times shifts,
57: mtl_parameters mp,
58: mrp_form_query mfq
59: WHERE bdr.department_id = p_dept_id
60: AND bdr.resource_id = p_res_id
61: AND bdr.department_id = brs.department_id(+)
62: AND bdr.resource_id = brs.resource_id(+)

Line 96: mrp_form_query mfq,

92: FROM bom_calendar_dates cal_start,
93: bom_calendar_dates cal_order,
94: mtl_system_items items,
95: mtl_parameters mp,
96: mrp_form_query mfq,
97: bom_operation_resources br,
98: bom_operation_sequences bos,
99: bom_operation_sequences bos1,
100: bom_resources bre,

Line 145: FROM mrp_form_query mfq,

141: ls.line_id,
142: mfq.number1,
143: mfq.date1,
144: sum(ls.planned_quantity - nvl(ls.quantity_completed,0))
145: FROM mrp_form_query mfq,
146: mrp_line_sch_avail_v ls
147: WHERE ls.organization_id = p_org_id
148: AND ls.line_id = p_line_id
149: AND trunc(ls.scheduled_completion_date) = mfq.date1

Line 346: SELECT mrp_form_query_s.nextval

342: -- Load and flush the dates
343: initialize_dates;
344:
345: -- Get the query_id
346: SELECT mrp_form_query_s.nextval
347: INTO l_query_id
348: FROM dual;
349:
350: -- We want to show all valid working days and non-working days

Line 365: -- Insert the dates into mrp_form_query so that we can join

361: -- Load the dates into mrp_workbench_bucket_dates so that the
362: -- form can select them into the flat file.
363: date_cells_tab(l_bucket_number) := l_bucket_date;
364:
365: -- Insert the dates into mrp_form_query so that we can join
366: -- to it in MRP_CAPACITY_CURSOR to get the appropriate bucket
367: -- numbers.
368: INSERT INTO MRP_FORM_QUERY(QUERY_ID, LAST_UPDATE_DATE,
369: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, DATE1,

Line 368: INSERT INTO MRP_FORM_QUERY(QUERY_ID, LAST_UPDATE_DATE,

364:
365: -- Insert the dates into mrp_form_query so that we can join
366: -- to it in MRP_CAPACITY_CURSOR to get the appropriate bucket
367: -- numbers.
368: INSERT INTO MRP_FORM_QUERY(QUERY_ID, LAST_UPDATE_DATE,
369: LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, DATE1,
370: NUMBER1)
371: VALUES(l_query_id, sysdate, -1, sysdate, -1,
372: l_bucket_date, l_bucket_number);