APPS.MRP_GRAPH_LINE_CAPACITY dependencies on BOM_CALENDAR_DATES

Line 16: bom_calendar_dates cal

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
20: AND mp.calendar_exception_set_id = cal.exception_set_id

Line 26: bom_calendar_dates cal

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
29: AND cal.calendar_date >= p_start_date
30: AND ((ls.planned_quantity - nvl(ls.quantity_completed,0)) > 0 and

Line 53: FROM bom_calendar_dates cal,

49: nvl(sum(decode(bdr.available_24_hours_flag,1,24,
50: ((decode(least(shifts.to_time,shifts.from_time),
51: shifts.to_time,shifts.to_time + 24*3600,
52: shifts.to_time) - shifts.from_time)/3600))),0))
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,

Line 92: FROM bom_calendar_dates cal_start,

88: sum(br.usage_rate_or_amount * (nvl(bos1.net_planning_percent, 100)/100) /
89: nvl(bos1.reverse_cumulative_yield, 1) * /*Fix for bug 2000775*/
90: decode(br.basis_type,1,ls.planned_quantity -
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,

Line 93: bom_calendar_dates cal_order,

89: nvl(bos1.reverse_cumulative_yield, 1) * /*Fix for bug 2000775*/
90: decode(br.basis_type,1,ls.planned_quantity -
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,