Search Results mrp_web_enterprise_v




Overview
Explore in AI Chat

Overview

MRP_WEB_ENTERPRISE_V is a database view owned by the APPS schema in Oracle E-Business Suite, belonging to the MRP (Master Scheduling/MRP) product family. Its documented purpose is to expose enterprise-level plan information for Web Inquiries, the self-service HTML interface through which planners and supply chain users interrogate planning results without accessing the full Oracle Forms-based Planner Workbench. The view is marked VALID and is available in both 12.1.1 and 12.2.2, with the underlying object list in the ETRM metadata confirming the same definition in either release.

The view presents one row per planned item for a single plan — specifically the plan with the highest PLAN_ID in MRP_MATERIAL_PLANS, restricted to horizontal plan type 10. It therefore returns the most recently generated horizontal plan across the enterprise, augmented with organization, project, and task attributes. This makes it the reporting and integration surface for enterprise-wide material plan inquiries rather than a transactional table.

Underlying Base Objects

The view is defined over four primary sources joined in a single SELECT:

The documented dependency list shows that these two project/task views are themselves built on the PA packages PA_PROJECT_UTILS, PA_TASK_UTILS, PA_SECURITY, PA_CROSS_BUSINESS_GRP, the MRP_GET_PROJECT package, and FND_PROFILE. This is significant: project and task visibility in the view is filtered through Oracle Projects security and the current responsibility's profile settings, so two users querying the same view may not see identical rows where projects are concerned.

Key Columns

The view exposes twenty-four columns. Identifiers include PLAN_ID, ORGANIZATION_ID, PLAN_ORGANIZATION_ID, INVENTORY_ITEM_ID, and COMPILE_DESIGNATOR, with ORGANIZATION_CODE resolving the owning organization and ITEM_SEGMENTS giving the concatenated item flexfield value. The supply and demand bucket columns — SALES_ORDERS, FORECASTS, DEPENDENT_DEMAND, GROSS_REQUIREMENTS, WIP, PURCHASE_ORDERS, PURCHASE_REQUISITIONS, IN_TRANSIT, IN_RECEIVING, PLANNED_ORDERS, TOTAL_SUPPLY, and SCHEDULED_RECEIPTS — correspond to the QUANTITY1 through QUANTITY18 positions in the horizontal plan record. Project columns are PLANNING_GROUP, PROJECT_ID, TASK_ID, PROJECT_NUMBER, and TASK_NUMBER; the view applies NVL defaults of '-' for PLANNING_GROUP and -1 for PROJECT_ID and TASK_ID so that non-project rows are retained under the outer-join condition.

Common Use Cases and Queries

The view is chiefly used for enterprise-level supply/demand reporting, exception dashboards, and extracts into external planning or BI tools. Because it already resolves organization code, project number, and task number, it removes the need for report authors to reproduce the Projects security joins.

A representative query retrieving demand and supply for a given item is:

  • SELECT organization_code, item_segments, gross_requirements, total_supply, project_number, task_number FROM mrp_web_enterprise_v WHERE inventory_item_id = :item_id;
  • SELECT organization_code, item_segments, forecast_plan, mps_plan FROM mrp_web_enterprise_v ORDER BY organization_code, item_segments;

Two caveats apply. First, the view returns only the single latest plan (MAX(PLAN_ID)) with horizontal plan type 10, so historical comparison requires querying MRP_MATERIAL_PLANS directly. Second, project and task rows are subject to Projects security via the underlying PA packages; users lacking project access will see the NVL placeholders rather than the true project or task values.