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.MRP_CRP_HORIZONTAL_PLAN dependencies on MRP_RECOMMENDATIONS

Line 144: mrp_recommendations recom,

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,
148: mrp_form_query list

Line 370: FROM mrp_recommendations mr,

366: trunc(mr.new_wip_start_date),
367: to_date(null),
368: (mr.new_order_quantity - NVL(mr.implemented_quantity,0) +
369: NVL(mr.quantity_in_process,0))
370: FROM mrp_recommendations mr,
371: mrp_form_query list
372: WHERE mr.order_type = M_PLANNED_ORDER
373: AND mr.new_wip_start_date < g_cutoff_date
374: AND mr.compile_designator = g_designator

Line 725: INDEX(mr MRP_RECOMMENDATIONS_N2) */

721: -- ============================================
722: SELECT /*+ ORDERED
723: USE_NL(mr)
724: INDEX(list MRP_FORM_QUERY_N1)
725: INDEX(mr MRP_RECOMMENDATIONS_N2) */
726: mr.organization_id,
727: mr.inventory_item_id,
728: -1,
729: -1,

Line 740: mrp_recommendations mr

736: NVL(mr.new_wip_start_date,mr.new_schedule_date),
737: to_date(null),
738: mr.new_order_quantity
739: FROM mrp_form_query list,
740: mrp_recommendations mr
741: WHERE mr.order_type in (M_PLANNED_ORDER, M_DISCRETE_JOBS,
742: M_NONSTD_JOBS, M_FLOW_SCHEDULES)
743: AND mr.disposition_status_type <> 2
744: AND mr.new_schedule_date < g_cutoff_date