APPS.MRP_MANAGER_PK dependencies on MTL_PARAMETERS

Line 604: mtl_parameters param

600: upd.rowid
601: FROM
602: oe_order_lines_all dem,
603: mrp_sales_order_updates upd,
604: mtl_parameters param
605: WHERE NVL(upd.process_status, -1) <> 3
606: AND upd.sales_order_id(+) = dem.line_id
607: AND param.calendar_code IS NOT NULL
608: AND param.calendar_exception_set_id IS NOT NULL

Line 727: mtl_parameters param

723: WHERE process_status = 3
724: AND request_id = arg_request_id) V,
725: oe_order_lines_all dem,
726: mrp_sales_order_updates upd,
727: mtl_parameters param
728: WHERE NVL(upd.process_status, -1) <> 3
729: AND upd.sales_order_id(+) = dem.line_id
730: AND param.calendar_code IS NOT NULL
731: AND param.calendar_exception_set_id IS NOT NULL

Line 788: from mtl_parameters param,

784: CURSOR calendar is
785: SELECT DISTINCT calendar_code,
786: calendar_exception_set_id,
787: param.organization_id
788: from mtl_parameters param,
789: mrp_sales_order_updates mrp
790: where param.organization_id = mrp.organization_id
791: and mrp.process_status = 1
792: order by calendar_code, calendar_exception_set_id;

Line 2036: FROM mtl_parameters mtl,

2032: 1, DECODE(project_control_level,
2033: 2, dates2.task_id,
2034: NULL),
2035: NULL)
2036: FROM mtl_parameters mtl,
2037: mrp_forecast_dates dates2
2038: WHERE dates2.transaction_id = dates1.old_transaction_id
2039: AND dates1.organization_id = mtl.organization_id)
2040: WHERE dates1.old_transaction_id >= 0;

Line 2089: FROM mtl_parameters mtl,

2085: 1, DECODE(mtl.project_control_level,
2086: 2, fc_dates.task_id,
2087: NULL),
2088: NULL)
2089: FROM mtl_parameters mtl,
2090: mrp_forecast_dates fc_dates
2091: WHERE fc_dates.transaction_id = dates.old_transaction_id
2092: AND dates.organization_id = mtl.organization_id)
2093: WHERE dates.old_transaction_id >= 0

Line 2121: FROM mtl_parameters mtl

2117: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2118: NULL),
2119: NULL),
2120: mrp_manager_pk.get_unit_number(dates.reservation_id)
2121: FROM mtl_parameters mtl
2122: WHERE dates.organization_id = mtl.organization_id)
2123: WHERE dates.old_transaction_id >= 0
2124: AND (dates.schedule_origination_type = 3
2125: OR (dates.schedule_origination_type = 8

Line 2197: FROM mtl_parameters mtl,

2193: 1, DECODE(mtl.project_control_level,
2194: 2, dates2.task_id, NULL),
2195: NULL),
2196: dates2.end_item_unit_number
2197: FROM mtl_parameters mtl,
2198: mrp_schedule_designators sched1,
2199: mrp_schedule_designators sched2,
2200: mrp_schedule_dates dates2
2201: WHERE dates2.mps_transaction_id = dates1.old_transaction_id

Line 2238: FROM mtl_parameters mtl,

2234: NULL),
2235: NULL),
2236: NVL(recom.implement_end_item_unit_number,
2237: recom.end_item_unit_number)
2238: FROM mtl_parameters mtl,
2239: mrp_recommendations recom
2240: WHERE recom.transaction_id = dates.old_transaction_id
2241: AND dates.organization_id = mtl.organization_id)
2242: WHERE dates.old_transaction_id >= 0