Results for “invfv_organization_items”

50+ results




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

Overview

INVFV_ORGANIZATION_ITEMS is a public Oracle EBS view owned by the APPS schema in the Inventory (INV) module. It presents organization-level item attribute data by joining organization code information from HR/MTL parameter structures to the system-item master held in MTL_SYSTEM_ITEMS. The view exposes the full complement of planning, costing, receiving, and physical-attribute columns associated with an inventory item within a specific inventory organization, together with a set of descriptive flexfield and key flexfield context markers (the "_KF:INV:MSTK:SY", "_KF:INV:MTLL:IT", and "_KF:SQLGL:GL#:CO" placeholders visible in the view text) that signal to the Forms/TCA framework how the item's key flexfield segments should be resolved.

Because it carries both ORGANIZATION_CODE and the item's segment attributes, the view is frequently the target of ad-hoc queries for the "inventory_item_segment1" style lookup — users search for it when they want to identify or join on a single key flexfield segment (typically segment1, the item number) alongside its owning organization. It is a reporting and integration convenience layer rather than a transaction table.

Underlying Base Objects

The view is defined primarily over MTL_SYSTEM_ITEMS (aliased SY in the view text), which supplies all the item-level attributes, and over organization/parameter objects that supply ORGANIZATION_CODE and organizational context. Documented referenced objects include:

Note the enumerated list of "referenced base objects" reflects the metadata footprint; the actual view text shown drives the projection from MTL_SYSTEM_ITEMS.

Key Columns

Common Use Cases and Queries

Typical uses include item master reporting, planning-parameter extraction, and integration extracts that need organization-scoped item attributes.

SELECT organization_code,
       name,
       primary_uom_code,
       inventory_item_status_code,
       planner_code,
       min_minmax_quantity,
       max_minmax_quantity
FROM   apps.invfv_organization_items
WHERE  organization_code = :org_code;

To isolate the item number segment (segment1) the search implied, join to the underlying item flexfield:

SELECT o.organization_code,
       o.name,
       msi.segment1  inventory_item_segment1,
       o.primary_uom_code,
       o.inventory_item_status_code
FROM   apps.invfv_organization_items o,
       apps.mtl_system_items msi
WHERE  msi.organization_id = ...
AND    msi.inventory_item_id = ...;

The view is best treated as a read-only reporting object; updates to item attributes must go through the Item Master (MTL_SYSTEM_ITEMS) APIs or the Inventory item form.