APPS.MRP_EPI dependencies on MTL_PARAMETERS

Line 234: mtl_parameters mtl,

230: 1,
231: sysdate,
232: 1
233: FROM bom_calendar_dates cal,
234: mtl_parameters mtl,
235: mrp_schedule_dates dates,
236: mrp_bis_inv_detail inv
237: WHERE cal.calendar_date BETWEEN dates.schedule_date AND dates.rate_end_date
238: AND dates.rate_end_date is not null

Line 368: mtl_parameters mtl,

364:
365: CURSOR COST_C IS
366: SELECT NVL(cst.item_cost,0)
367: FROM cst_cost_types cct,
368: mtl_parameters mtl,
369: cst_item_costs cst
370: WHERE (cst.cost_type_id = cct.cost_type_id
371: OR (cst.cost_type_id = cct.default_cost_type_id
372: AND (NOT EXISTS (SELECT 'Primary Cost Type Row'

Line 405: mtl_parameters mtl,

401: + NVL(cst.tl_overhead,0)
402: + NVL(cst.tl_material_overhead,0)
403: + NVL(cst.tl_outside_processing,0)
404: FROM cst_cost_types cct,
405: mtl_parameters mtl,
406: cst_item_costs cst
407: WHERE (cst.cost_type_id = cct.cost_type_id
408: OR (cst.cost_type_id = cct.default_cost_type_id
409: AND (NOT EXISTS (SELECT 'Primary Cost Type Row'

Line 486: mtl_parameters param

482: INTO revenue, cost
483: FROM bom_calendar_dates cal,
484: mrp_schedule_dates dates,
485: mrp_system_items sys,
486: mtl_parameters param
487: WHERE dates.organization_id = sys.organization_id
488: AND dates.inventory_item_id = sys.inventory_item_id
489: AND dates.schedule_level = 3
490: AND dates.schedule_designator = sched_name

Line 702: mtl_parameters mp,

698: mtl_categories_kfv cat,
699: mtl_categories_vl vcat,
700: mtl_item_categories icat,
701: bom_calendar_dates cal,
702: mtl_parameters mp,
703: mtl_system_items_kfv sys3,
704: mtl_system_items_kfv sys2,
705: mtl_system_items_kfv sys,
706: (SELECT inventory_item_id,

Line 999: mtl_parameters mp,

995: mtl_categories_kfv cat,
996: mtl_categories_vl vcat,
997: mtl_item_categories icat,
998: bom_calendar_dates cal,
999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1003: mrp_forecast_designators desig,

Line 1203: mtl_parameters param,

1199: mtl_item_categories icat,
1200: mtl_system_items_kfv sys3,
1201: mtl_system_items_kfv sys2,
1202: mtl_system_items_kfv sys,
1203: mtl_parameters param,
1204: (SELECT distinct organization_id, organization_code, organization_name,
1205: update_type, forecast_set, inventory_item_id
1206: FROM mrp_bis_forecast_wb
1207: WHERE organization_id = p_organization_id

Line 1361: mtl_parameters mtl,

1357: SELECT NVL(SUM(DECODE(order_type,4,NVL(rec.daily_rate,0),
1358: NVL(rec.new_order_quantity,0))),0) *
1359: mrp_item_cost(rec.inventory_item_id, rec.organization_id)
1360: FROM bom_calendar_dates cal,
1361: mtl_parameters mtl,
1362: mrp_system_items msi,
1363: mrp_recommendations rec
1364: WHERE rec.disposition_status_type = 1
1365: AND ((calendar_date = TRUNC(rec.new_wip_start_date)

Line 1468: mtl_parameters param,

1464: 1,
1465: sysdate,
1466: 1
1467: FROM bom_calendar_dates cal,
1468: mtl_parameters param,
1469: crp_available_resources_v avail
1470: WHERE cal.calendar_date BETWEEN avail.resource_start_date
1471: AND NVL(avail.resource_end_date,avail.resource_start_date)
1472: AND cal.calendar_date BETWEEN p_start_date AND p_end_date

Line 1494: mtl_parameters param,

1490: 1,
1491: sysdate,
1492: 1
1493: FROM bom_calendar_dates cal,
1494: mtl_parameters param,
1495: crp_resource_requirements_v req
1496: WHERE cal.calendar_date BETWEEN req.resource_date
1497: AND NVL(req.resource_end_date,req.resource_date)
1498: AND cal.calendar_date BETWEEN p_start_date AND p_end_date