APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on BOM_CALENDAR_DATES

Line 107: FROM bom_calendar_dates

103: activity_rec crp_activity;
104:
105: CURSOR seqnum_cursor(p_date DATE) IS
106: SELECT next_seq_num
107: FROM bom_calendar_dates
108: WHERE calendar_code = g_calendar_code
109: AND exception_set_id = g_exc_set_id
110: AND calendar_date = p_date;
111:

Line 114: FROM bom_calendar_dates

110: AND calendar_date = p_date;
111:
112: CURSOR prior_seqnum_cursor(p_date DATE) IS
113: SELECT prior_seq_num
114: FROM bom_calendar_dates
115: WHERE calendar_code = g_calendar_code
116: AND exception_set_id = g_exc_set_id
117: AND calendar_date = p_date;
118:

Line 142: FROM bom_calendar_dates res_start,

138: DECODE(SIGN(nvl(recom.new_order_quantity, recom.firm_quantity) -
139: NVL(recom.implemented_quantity,0) -
140: NVL(recom.quantity_in_process,0)),
141: 1, routing.runtime_quantity, 0))
142: FROM bom_calendar_dates res_start,
143: bom_calendar_dates order_date,
144: mrp_recommendations recom,
145: mrp_system_items items,
146: mrp_planned_resource_reqs routing,

Line 143: bom_calendar_dates order_date,

139: NVL(recom.implemented_quantity,0) -
140: NVL(recom.quantity_in_process,0)),
141: 1, routing.runtime_quantity, 0))
142: FROM bom_calendar_dates res_start,
143: bom_calendar_dates order_date,
144: mrp_recommendations recom,
145: mrp_system_items items,
146: mrp_planned_resource_reqs routing,
147: mtl_parameters org,

Line 256: FROM bom_calendar_dates res_start,

252: (NVL(fs.planned_quantity,0) -
253: NVL(fs.quantity_completed,0)),0),
254: NVL(res.usage_rate_or_amount*muc2.conversion_rate/
255: muc1.conversion_rate, 0))
256: FROM bom_calendar_dates res_start,
257: bom_calendar_dates order_date,
258: mtl_system_items items,
259: mtl_parameters param,
260: wip_flow_schedules fs,

Line 257: bom_calendar_dates order_date,

253: NVL(fs.quantity_completed,0)),0),
254: NVL(res.usage_rate_or_amount*muc2.conversion_rate/
255: muc1.conversion_rate, 0))
256: FROM bom_calendar_dates res_start,
257: bom_calendar_dates order_date,
258: mtl_system_items items,
259: mtl_parameters param,
260: wip_flow_schedules fs,
261: bom_operational_routings routing,

Line 525: bom_calendar_dates cal,

521: FROM bom_shift_times shifts,
522: bom_resource_shifts res_shifts,
523: bom_department_resources dept_res,
524: mtl_parameters param,
525: bom_calendar_dates cal,
526: mrp_form_query list
527: WHERE (shifts.calendar_code is NULL OR
528: shifts.calendar_code = param.calendar_code)
529: AND shifts.shift_num (+) = res_shifts.shift_num

Line 582: FROM bom_calendar_dates dates,

578: (brc.capacity_change *
579: (DECODE(LEAST(NVL(brc.from_time, 0), NVL(brc.to_time, 1)),
580: NVL(brc.to_time, 1), 24 * 3600 + NVL(brc.to_time, 1),
581: NVL(brc.to_time, 1)) - NVL(brc.from_TIME, 0)))/3600
582: FROM bom_calendar_dates dates,
583: bom_resource_changes brc,
584: mrp_plan_organizations_v orgs,
585: mtl_parameters param,
586: mrp_form_query list