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 MRP_RECOMMENDATIONS

Line 118: MRP_recommendations recom

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
121: AND res_end.seq_num =
122: old_end_date.prior_seq_num + NVL(recom.reschedule_days, 0) -

Line 226: mrp_recommendations recom,

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
228: WHERE res_date.seq_num =
229: TRUNC(sched_date.seq_num
230: - CEIL((items.variable_lead_time * new_order_quantity +

Line 301: from mrp_recommendations

297: plan1.source_transaction_id
298: AND plan2.operation_seq_num = plan1.operation_seq_num))
299: where source_transaction_id in
300: (select transaction_id
301: from mrp_recommendations
302: where compile_designator = arg_compile_desig
303: and organization_id in
304: (select planned_organization
305: from mrp_plan_organizations_v

Line 341: from mrp_recommendations

337: AND plan2.source_transaction_id =
338: plan1.source_transaction_id)
339: where source_transaction_id in
340: (select transaction_id
341: from mrp_recommendations
342: where compile_designator = arg_compile_desig
343: and organization_id in
344: (select planned_organization
345: from mrp_plan_organizations_v

Line 369: from mrp_recommendations

365:
366: update crp_resource_plan plan1
367: set resource_end_date =
368: (select new_schedule_date
369: from mrp_recommendations
370: where transaction_id = plan1.source_transaction_id)
371: where source_transaction_id in
372: (select transaction_id
373: from mrp_recommendations

Line 373: from mrp_recommendations

369: from mrp_recommendations
370: where transaction_id = plan1.source_transaction_id)
371: where source_transaction_id in
372: (select transaction_id
373: from mrp_recommendations
374: where compile_designator = arg_compile_desig
375: and organization_id in
376: (select planned_organization
377: from mrp_plan_organizations_v

Line 462: mrp_recommendations recom,

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
464: WHERE last_res_date.seq_num =
465: TRUNC(last_due.seq_num
466: - CEIL((items.variable_lead_time *