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
- ORGANIZATION_CODE / NAME — organization identifiers and descriptive names for the owning and planning organizations.
- NETTABLE_INVENTORY_QUANTITY — on-hand quantity eligible for MRP netting.
- NONNETTABLE_INVENTORY_QUANTITY — on-hand quantity excluded from netting.
- COMPILE_DESIGNATOR — identifies the item as keyed by the SYSITEM flexfield reference.
- MRP_PLANNING_CODE — planning status (e.g., planned, not planned, MRP/DRP planned).
- LOW_LEVEL_CODE — low-level code used for planning order.
- PREPROCESSING_LEAD_TIME / POSTPROCESSING_LEAD_TIME / FULL_LEAD_TIME / CUMULATIVE_TOTAL_LEAD_TIME / CUM_MANUFACTURING_LEAD_TIME / FIXED_LEAD_TIME / VARIABLE_LEAD_TIME — the family of lead time attributes driving planning offsets.
- STANDARD_COST — item standard cost used for planning valuation.
- SAFETY_STOCK_CODE / SAFETY_STOCK_PERCENT / SAFETY_STOCK_BUCKET_DAYS / SAFETY_STOCK_QUANTITY — safety stock policy definitions.
- FIXED_DAYS_SUPPLY / FIXED_ORDER_QUANTITY / FIXED_LOT_MULTIPLIER / MINIMUM_ORDER_QUANTITY / MAXIMUM_ORDER_QUANTITY — order modifier attributes.
- PLANNING_TIME_FENCE_DAYS / DEMAND_TIME_FENCE_DAYS — time fence horizons.
- INVENTORY_USE_UP_DATE / ACCEPTABLE_EARLY_DELIVERY — supply/demand timing controls.
- WIP_SUPPLY_TYPE / REPETITIVE_TYPE / BUILD_IN_WIP_FLAG / PURCHASING_ENABLED_FLAG / ENGINEERING_ITEM_FLAG — manufacturing and procurement nature of the item.
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.
-
View: MRPBV_PLAN_ORG_ITEMS 12.1.1
APPS.MRPBV_PLAN_ORG_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →
-
View: MRPBV_PLAN_ORG_ITEMS 12.2.2
APPS.MRPBV_PLAN_ORG_ITEMS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →
-
SYNONYM: APPS.MRP_PLANS 12.2.2
-
SYNONYM: APPS.MRP_PLANS 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.MTL_PARAMETERS 12.1.1
-
SYNONYM: APPS.MTL_PARAMETERS 12.2.2
-
eTRM - MRP Tables and Views 12.1.1
Recommendations based on user criteria selected in MRP Planner WorkBench
-
eTRM - MRP Tables and Views 12.2.2
Recommendations based on user criteria selected in MRP Planner WorkBench
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - MRP Tables and Views 12.1.1
Recommendations based on user criteria selected in MRP Planner WorkBench
-
eTRM - MRP Tables and Views 12.2.2
Recommendations based on user criteria selected in MRP Planner WorkBench