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 MTL_UOM_CONVERSIONS

Line 203: FROM mtl_uom_conversions muc2,

199: DECODE(res.applied_resource_units, 0,
200: NVL(res.usage_rate_or_amount*muc2.conversion_rate/
201: muc1.conversion_rate, 0),
202: 0))/compute_days_between (g_spread_load,res.start_date,res.completion_date)
203: FROM mtl_uom_conversions muc2,
204: wip_discrete_jobs jobs,
205: wip_operations op,
206: wip_operation_resources res,
207: mrp_form_query list,

Line 208: mtl_uom_conversions muc1

204: wip_discrete_jobs jobs,
205: wip_operations op,
206: wip_operation_resources res,
207: mrp_form_query list,
208: mtl_uom_conversions muc1
209: WHERE muc1.inventory_item_id = 0
210: AND muc1.uom_code = g_hour_uom
211: AND muc2.uom_code = res.uom_code
212: AND muc2.inventory_item_id = 0

Line 265: mtl_uom_conversions muc2,

261: bom_operational_routings routing,
262: bom_operation_sequences seqs,
263: bom_operation_resources res,
264: bom_resources bom_res,
265: mtl_uom_conversions muc2,
266: mtl_uom_conversions muc1,
267: mrp_form_query list
268: WHERE res_start.exception_set_id = param.calendar_exception_set_id
269: AND res_start.calendar_code = param.calendar_code

Line 266: mtl_uom_conversions muc1,

262: bom_operation_sequences seqs,
263: bom_operation_resources res,
264: bom_resources bom_res,
265: mtl_uom_conversions muc2,
266: mtl_uom_conversions muc1,
267: mrp_form_query list
268: WHERE res_start.exception_set_id = param.calendar_exception_set_id
269: AND res_start.calendar_code = param.calendar_code
270: AND res_start.seq_num = order_date.prior_seq_num -

Line 324: FROM mtl_uom_conversions muc2,

320: DECODE(res.applied_resource_units, 0,
321: NVL(res.usage_rate_or_amount*muc2.conversion_rate/
322: muc1.conversion_rate, 0),
323: 0))
324: FROM mtl_uom_conversions muc2,
325: wip_repetitive_schedules rep,
326: wip_repetitive_items items,
327: wip_operations op,
328: wip_operation_resources res,

Line 330: mtl_uom_conversions muc1

326: wip_repetitive_items items,
327: wip_operations op,
328: wip_operation_resources res,
329: mrp_form_query list,
330: mtl_uom_conversions muc1
331: WHERE muc1.inventory_item_id = 0
332: AND muc1.uom_code = g_hour_uom
333: AND muc2.uom_code = res.uom_code
334: AND muc2.inventory_item_id = 0