APPS.MRP_REPORT_INV_TURNS dependencies on MRP_RECOMMENDATIONS

Line 182: mrp_recommendations rec

178: (SELECT NVL(SUM(rec.new_order_quantity
179: * NVL(cst.item_cost, 0)), 0)
180: / 1000
181: FROM cst_item_costs cst,
182: mrp_recommendations rec
183: WHERE cst.organization_id = rec.organization_id
184: AND cst.inventory_item_id = rec.inventory_item_id
185: AND ( cst.cost_type_id = arg_cost_type
186: OR

Line 219: mrp_recommendations rec

215: (SELECT NVL(SUM(rec.new_order_quantity
216: * NVL(cst.item_cost,0)), 0)
217: / 1000
218: FROM cst_item_costs cst,
219: mrp_recommendations rec
220: WHERE cst.organization_id = rec.organization_id
221: AND cst.inventory_item_id = rec.inventory_item_id
222: AND ( cst.cost_type_id = arg_cost_type
223: OR

Line 257: mrp_recommendations rec

253: * NVL(cst.item_cost, 0)), 0)
254: / 1000
255: FROM cst_item_costs cst,
256: mrp_system_items sys,
257: mrp_recommendations rec
258: WHERE cst.organization_id = sys.organization_id
259: AND cst.inventory_item_id = sys.inventory_item_id
260: AND ( cst.cost_type_id = arg_cost_type
261: OR

Line 303: mrp_recommendations rec

299: + NVL(cst.tl_material_overhead, 0)
300: + NVL(cst.tl_outside_processing, 0))), 0)
301: / 1000
302: FROM cst_item_costs cst,
303: mrp_recommendations rec
304: WHERE cst.inventory_item_id = rec.inventory_item_id
305: AND cst.organization_id = rec.organization_id
306: AND ( cst.cost_type_id = arg_cost_type
307: OR

Line 345: mrp_recommendations rec

341: + NVL(cst.tl_outside_processing, 0))), 0)
342: / 1000
343: FROM cst_item_costs cst,
344: bom_calendar_dates cal,
345: mrp_recommendations rec
346: WHERE cst.inventory_item_id = rec.inventory_item_id
347: AND cst.organization_id = rec.organization_id
348: AND ( cst.cost_type_id = arg_cost_type
349: OR

Line 395: mrp_recommendations rec

391: + NVL(cst.tl_outside_processing, 0))), 0)
392: / 1000
393: FROM cst_item_costs cst,
394: mrp_system_items sys,
395: mrp_recommendations rec
396: WHERE cst.inventory_item_id = sys.inventory_item_id
397: AND cst.organization_id = sys.organization_id
398: AND ( cst.cost_type_id = arg_cost_type
399: OR