APPS.MRP_GRAPH_LINE_CAPACITY dependencies on MTL_PARAMETERS

Line 15: FROM mtl_parameters mp,

11: p_line_id NUMBER,
12: p_start_date DATE)
13: IS
14: SELECT distinct cal.calendar_date
15: FROM mtl_parameters mp,
16: bom_calendar_dates cal
17: WHERE mp.organization_id = p_org_id
18: AND cal.calendar_date >= p_start_date
19: AND cal.seq_num IS NOT NULL

Line 24: FROM mtl_parameters mp,

20: AND mp.calendar_exception_set_id = cal.exception_set_id
21: AND mp.calendar_code = cal.calendar_code
22: UNION ALL
23: SELECT distinct cal.calendar_date
24: FROM mtl_parameters mp,
25: mrp_line_sch_avail_v ls,
26: bom_calendar_dates cal
27: WHERE mp.organization_id = p_org_id
28: AND ls.line_id = p_line_id

Line 57: mtl_parameters mp,

53: FROM bom_calendar_dates cal,
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(+)

Line 95: mtl_parameters mp,

91: nvl(ls.quantity_completed,0) , 2, 1))
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,