Results for “invfv_items”

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

Overview

INVFV_ITEMS is a valid APPS-schema view owned by the Inventory (INV) product module in Oracle E-Business Suite 12.1.1 and 12.2.2. The name follows the Flexfield Value (FV) naming convention, indicating that the view flattens the descriptive flexfield and key flexfield context associated with an inventory item's master organization definition into a single queryable row. The view presents item master attributes joined with organization code, item name, and the descriptive flexfield context identifier (rendered as the literal marker tags such as _KF:INV:MSTK:SY1), exposing the MSTK (Master Item) attribute group alongside code combination references (_KF:SQLGL:GL#:CO1, _KF:SQLGL:GL#:CO2). In practice, INVFV_ITEMS serves reporting, integration, and concurrent-program access to a denormalized view of MTL_SYSTEM_ITEMS plus selected organization-level attributes, allowing reports and interfaces to retrieve item master values without manually joining the many lookup and control tables that govern item behavior.

Underlying Base Objects

The documented ETRM metadata lists the following referenced base objects: CS_COVERAGES_ACTIVE_V (VIEW), FA_CATEGORIES, FND_COMMON_LOOKUPS, FND_GLOBAL, GL_CODE_COMBINATIONS, HR_ALL_ORGANIZATION_UNITS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, MTL_ATP_RULES, MTL_ITEM_CATALOG_GROUPS, MTL_ITEM_LOCATIONS, MTL_PARAMETERS, MTL_PICKING_RULES, MTL_SYSTEM_ITEMS, PER_PEOPLE_X, PO_HAZARD_CLASSES, PO_UN_NUMBERS, RA_RULES, RA_TERMS, and RCV_ROUTING_HEADERS.

The central base object is MTL_SYSTEM_ITEMS, which supplies the item master fields referenced in the view text (aliased SY1), including MARKET_PRICE, QTY_RCV_TOLERANCE, UNIT_OF_ISSUE, SHELF_LIFE_DAYS, PLANNER_CODE, and the ENGINEERING_ECN_CODE / ENGINEERING_DATE columns. Organization context is provided by MTL_PARAMETERS, which links the item to an organization and yields the ORGANIZATION_CODE consumed in the view (aliased PA1). Supporting lookups and controls such as FND_COMMON_LOOKUPS, MTL_ATP_RULES, MTL_PICKING_RULES, RA_TERMS, RA_RULES, and RCV_ROUTING_HEADERS resolve descriptive values for receiving, planning, and returns processing. HR objects (HR_ALL_ORGANIZATION_UNITS, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, PER_PEOPLE_X) and FND_GLOBAL supply organizational hierarchy, security, and session context, which is typical of Oracle's Multi-Org and HR-secured reporting views.

Key Columns

The view exposes a broad set of item attributes. Notable columns relevant to the "engineering_item_id" search include:

• ENGINEERING_ECN_CODE and ENGINEERING_DATE — identify the engineering change order and effective date governing the item revision.
• ORGANIZATION_CODE and NAME — the inventory organization and item description used as report keys.
• PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE, and UNIT_OF_ISSUE — unit-of-measure definitions.
• MARKET_PRICE, LIST_PRICE_PER_UNIT, PRICE_TOLERANCE_PERCENT — pricing and tolerance parameters.
• PLANNER_CODE, FIXED_LEAD_TIME, VARIABLE_LEAD_TIME, CUM_MANUFACTURING_LEAD_TIME — planning attributes.
• SAFETY_STOCK_BUCKET_DAYS, MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY — inventory replenishment controls.
• INVENTORY_ITEM_STATUS_CODE, TAX_CODE, PURCHASING_TAX_CODE — status and taxation references.
• Literal descriptor tags such as _KF:INV:MSTK:SY1 — denote the flexfield context of the returned item attribute group.

Common Use Cases and Queries

Reports and integrations use INVFV_ITEMS to obtain a single-row-per-item projection of master item attributes combined with organization context, often for engineering change tracking, planning extracts, or receiving configuration reviews.

Example query retrieving engineering change information for a given organization:

• SELECT organization_code, name, engineering_ecn_code, engineering_date, planner_code FROM apps.invfv_items WHERE organization_code = :org AND name = :item;

Example query listing planned items with lead times for a planner:

• SELECT organization_code, name, planner_code, fixed_lead_time, variable_lead_time FROM apps.invfv_items WHERE planner_code = :planner ORDER BY name;

Because the view draws on Multi-Org and HR security objects, results are typically filtered by the session's organization and security profile, ensuring that only authorized organizations and items are returned.