Results for “mrpbv_plan_org_items”

24 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MRPBV_PLAN_ORG_ITEMS is a denormalized reporting view owned by the APPS schema within the Oracle E-Business Suite Master Scheduling/MRP (MRP) product family. It presents the intersection of system items and planning organizations, exposing the planning attributes and item master information that the MRP/MPS engine and its associated inquiry forms require. The view is especially useful as a flattened, human-readable substitute for the underlying MRP_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS tables, since it joins organizational identifiers to their descriptive names and translates lookup-coded flag columns into their meanings through embedded message-dictionary references (the "_LA:" and "_KF:" tokens in the view text). The "_KF:INV:MSTK:SYSITEM" token designates a flexfield key reference for the item, and the various "_LA:..." tokens resolve MFG_LOOKUPS values for inventory type, planning code, build-in-WIP flag, purchasing-enabled flag, make/buy code, repetitive type, lot control, rounding control, ATP calculation, end assembly pegging, engineering item flag, and WIP supply type.

For users searching on the column NETTABLE_INVENTORY_QUANTITY, this view is the primary exposure point. That column carries the quantity of on-hand inventory treated as nettable for planning purposes, subject to the subinventory-level netting rules defined in MTL_PARAMETERS. It is a core input to the MRP netting calculation and is frequently referenced in supply/demand inquiries and custom planning reports.

Underlying Base Objects

ETRM metadata documents the following referenced base objects, resolved through APPS synonyms:

  • MRP_SYSTEM_ITEMS — the primary source of the planning attributes projected by the view, including all lead time, safety stock, order modifier, and time fence columns.
  • MTL_SYSTEM_ITEMS — source of core item master attributes (e.g., unit of measure, item descriptions).
  • MRP_PLANS — defines the plan context associated with the planning organizations.
  • MRP_PLAN_ORGANIZATIONS — the organization/plan association that governs which organizations participate in a given plan.
  • MTL_PARAMETERS — organization-level inventory parameters, notably the netting controls that qualify nettable quantity.
  • HR_ALL_ORGANIZATION_UNITS — resolves organization identifiers to descriptive names (ORG1.NAME, ORG2.NAME in the view text).

The view aliases MRP_SYSTEM_ITEMS as MRPITEM and exposes parallel organization code/name pairs (PARA1/ORG1 and PARA2/ORG2), reflecting a self-join joining the item's owning organization and the planning organization on a single row.

Key Columns

Common Use Cases and Queries

The view is commonly used in planning inquiries, custom MRP exception reports, and data extracts feeding planning analytics. A typical query locating items with nettable on-hand in a given organization follows:

  • SELECT organization_code, name, compile_designator, nettable_inventory_quantity, nonnettable_inventory_quantity FROM apps.mrpbv_plan_org_items WHERE organization_code = :org AND nettable_inventory_quantity > 0; — retrieve items with positive nettable on-hand.
  • SELECT organization_code, compile_designator, mrp_planning_code, nettable_inventory_quantity FROM apps.mrpbv_plan_org_items WHERE mrp_planning_code IN (1,2); — item/org combinations actively planned by MRP or DRP/MPS.
  • Joining to MRP_GROSS_REQUIREMENTS or MRP_RECOMMENDED_PLAN_ORDERS on inventory_item_id and organization_id to reconcile nettable supply against demand.
  • Extracting lead time and order modifier attributes for parameter audits or plan tuning exercises.
  • Populating custom planning dashboards where descriptive lookup values (from the embedded "_LA:" translations) are preferred over code values.