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 2041: FROM mtl_parameters mtl,

2037: 1, DECODE(project_control_level,
2038: 2, dates2.task_id,
2039: NULL),
2040: NULL)
2041: FROM mtl_parameters mtl,
2042: mrp_forecast_dates dates2
2043: WHERE dates2.transaction_id = dates1.old_transaction_id
2044: AND dates1.organization_id = mtl.organization_id)
2045: WHERE dates1.old_transaction_id >= 0;

Line 2094: FROM mtl_parameters mtl,

2090: 1, DECODE(mtl.project_control_level,
2091: 2, fc_dates.task_id,
2092: NULL),
2093: NULL)
2094: FROM mtl_parameters mtl,
2095: mrp_forecast_dates fc_dates
2096: WHERE fc_dates.transaction_id = dates.old_transaction_id
2097: AND dates.organization_id = mtl.organization_id)
2098: WHERE dates.old_transaction_id >= 0

Line 2126: FROM mtl_parameters mtl

2122: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2123: NULL),
2124: NULL),
2125: mrp_manager_pk.get_unit_number(dates.reservation_id)
2126: FROM mtl_parameters mtl
2127: WHERE dates.organization_id = mtl.organization_id)
2128: WHERE dates.old_transaction_id >= 0
2129: AND (dates.schedule_origination_type = 3
2130: OR (dates.schedule_origination_type = 8

Line 2202: FROM mtl_parameters mtl,

2198: 1, DECODE(mtl.project_control_level,
2199: 2, dates2.task_id, NULL),
2200: NULL),
2201: dates2.end_item_unit_number
2202: FROM mtl_parameters mtl,
2203: mrp_schedule_designators sched1,
2204: mrp_schedule_designators sched2,
2205: mrp_schedule_dates dates2
2206: WHERE dates2.mps_transaction_id = dates1.old_transaction_id

Line 2243: FROM mtl_parameters mtl,

2239: NULL),
2240: NULL),
2241: NVL(recom.implement_end_item_unit_number,
2242: recom.end_item_unit_number)
2243: FROM mtl_parameters mtl,
2244: mrp_recommendations recom
2245: WHERE recom.transaction_id = dates.old_transaction_id
2246: AND dates.organization_id = mtl.organization_id)
2247: WHERE dates.old_transaction_id >= 0