Search Results edwbv_item_itemorgpf_lcv




Overview
Explore in AI Chat

Overview

EDWBV_ITEM_ITEMORGPF_LCV is a read-only Oracle EBS view owned by the APPS schema and registered as a VALID database object. It belongs to the Engineering (ENG) product family and forms part of the Oracle Enterprise Data Warehouse (EDW) extraction layer that ships with E-Business Suite releases 12.1.1 and 12.2.2. Functionally, the view exposes product family items — that is, master items that have been assigned a value in the PRODUCT_FAMILY_ITEM_ID column — at the item/organization level of granularity.

The name follows the EDW convention: the "BV" segment indicates a Business View, "ITEM_ITEMORGPF" indicates the item/organization/product-family scope, and the "_LCV" suffix denotes a local instance-aware view that joins to EDW_LOCAL_INSTANCE to stamp each row with a source instance code. Because it is a reporting and integration view rather than a transactional object, it is used to feed business intelligence extracts, data marts, and cross-instance consolidation rather than by online forms or concurrent programs that write data.

Underlying Base Objects

The view is defined over a fixed set of Oracle Inventory base objects:

The driving filter is MTI.PRODUCT_FAMILY_ITEM_ID IS NOT NULL, joined on MTI.ORGANIZATION_ID = MTP.ORGANIZATION_ID. A second reference to MTL_PARAMETERS (aliased MTM) also appears in the FROM clause. Although the ETRM record documents no explicit base-object dependencies, the view text clearly establishes these five sources, and the item master parent relationship is resolved through the packaged function EDW_ITEMS_PKG.GET_MASTER_PARENT.

Key Columns

The projection builds EDW surrogate keys and business attributes side by side:

Common Use Cases and Queries

Typical usage includes populating product family hierarchies in an EDW item dimension, reconciling product family membership across organizations, and reporting planning or purchasing attributes for family-level items. A representative query is:

SELECT inventory_item_id, organization_id, concatenated_segments, description, planning_make_buy_code FROM apps.edwbv_item_itemorgpf_lcv WHERE organization_id = :org_id;

Because the view performs multi-table joins and invokes EDW_ITEMS_PKG for each row, queries should always be restricted by ORGANIZATION_ID or a specific item range to avoid full-table processing. Restricting by STOCK_ENABLED_FLAG or PLANNING_MAKE_BUY_CODE further narrows results for planning-focused extracts. The view is not updatable and should be treated strictly as a query surface for reporting and downstream data integration.