eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CRP_PLANNER_PK dependencies on BOM_CALENDAR_DATES

Line 113: FROM bom_calendar_dates res_end,

109: (resources.operation_hours_required -
110: resources.hours_expended))/
111: (greatest(res_end.seq_num, res_date.seq_num) -
112: res_date.seq_num + 1)
113: FROM bom_calendar_dates res_end,
114: bom_calendar_dates old_end_date,
115: bom_calendar_dates res_date,
116: bom_calendar_dates old_start_date,
117: mrp_wip_resources resources,

Line 114: bom_calendar_dates old_end_date,

110: resources.hours_expended))/
111: (greatest(res_end.seq_num, res_date.seq_num) -
112: res_date.seq_num + 1)
113: FROM bom_calendar_dates res_end,
114: bom_calendar_dates old_end_date,
115: bom_calendar_dates res_date,
116: bom_calendar_dates old_start_date,
117: mrp_wip_resources resources,
118: MRP_recommendations recom

Line 115: bom_calendar_dates res_date,

111: (greatest(res_end.seq_num, res_date.seq_num) -
112: res_date.seq_num + 1)
113: FROM bom_calendar_dates res_end,
114: bom_calendar_dates old_end_date,
115: bom_calendar_dates res_date,
116: bom_calendar_dates old_start_date,
117: mrp_wip_resources resources,
118: MRP_recommendations recom
119: WHERE res_end.exception_set_id = arg_exception_set_id

Line 116: bom_calendar_dates old_start_date,

112: res_date.seq_num + 1)
113: FROM bom_calendar_dates res_end,
114: bom_calendar_dates old_end_date,
115: bom_calendar_dates res_date,
116: bom_calendar_dates old_start_date,
117: mrp_wip_resources resources,
118: MRP_recommendations recom
119: WHERE res_end.exception_set_id = arg_exception_set_id
120: AND res_end.calendar_code = arg_calendar_code

Line 222: FROM bom_calendar_dates res_date,

218: labor.operation_seq_num,
219: labor.resource_seq_num,
220: NULL,
221: NULL
222: FROM bom_calendar_dates res_date,
223: bom_calendar_dates sched_date,
224: mrp_system_items items,
225: mrp_planned_resource_reqs labor,
226: mrp_recommendations recom,

Line 223: bom_calendar_dates sched_date,

219: labor.resource_seq_num,
220: NULL,
221: NULL
222: FROM bom_calendar_dates res_date,
223: bom_calendar_dates sched_date,
224: mrp_system_items items,
225: mrp_planned_resource_reqs labor,
226: mrp_recommendations recom,
227: mrp_plans mp

Line 456: FROM bom_calendar_dates last_res_date,

452: labor.runtime_quantity * NVL(recom.daily_rate,0),
453: labor.runtime_quantity /
454: (last_res_date.seq_num -
455: first_res_date.seq_num + 1))
456: FROM bom_calendar_dates last_res_date,
457: bom_calendar_dates first_res_date,
458: bom_calendar_dates last_due,
459: bom_calendar_dates first_due,
460: mrp_system_items items,

Line 457: bom_calendar_dates first_res_date,

453: labor.runtime_quantity /
454: (last_res_date.seq_num -
455: first_res_date.seq_num + 1))
456: FROM bom_calendar_dates last_res_date,
457: bom_calendar_dates first_res_date,
458: bom_calendar_dates last_due,
459: bom_calendar_dates first_due,
460: mrp_system_items items,
461: mrp_planned_resource_reqs labor,

Line 458: bom_calendar_dates last_due,

454: (last_res_date.seq_num -
455: first_res_date.seq_num + 1))
456: FROM bom_calendar_dates last_res_date,
457: bom_calendar_dates first_res_date,
458: bom_calendar_dates last_due,
459: bom_calendar_dates first_due,
460: mrp_system_items items,
461: mrp_planned_resource_reqs labor,
462: mrp_recommendations recom,

Line 459: bom_calendar_dates first_due,

455: first_res_date.seq_num + 1))
456: FROM bom_calendar_dates last_res_date,
457: bom_calendar_dates first_res_date,
458: bom_calendar_dates last_due,
459: bom_calendar_dates first_due,
460: mrp_system_items items,
461: mrp_planned_resource_reqs labor,
462: mrp_recommendations recom,
463: mrp_plans mp