Results for “asf_inventory_lov_v”

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

Overview

ASF_INVENTORY_LOV_V is a database view belonging to the ASF – Sales Online product family within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is designed to serve as a list-of-values (LOV) source for inventory item selections within Sales Online flows, presenting item identifiers alongside their associated unit-of-measure (UOM) attributes. The view exposes a consolidated projection that joins inventory item attributes with UOM details, allowing forms and concurrent processes to present users with a combined item and UOM choice set without querying the underlying inventory tables directly.

The view is documented as not implemented in this database in the ETRM metadata, meaning the definition exists in the reference documentation but no active deployment was found at the time of cataloguing. Its role in reporting and integration is nevertheless clear: it provides a denormalized, read-only interface for resolving item and UOM combinations, which is a common requirement in order capture, pricing, and inventory validation logic specific to Sales Online.

The presence of the UOM_DESCRIPTION column — the element the user searched for — confirms that this view is the canonical source for retrieving the human-readable description of the unit of measure associated with a given inventory item in the Sales Online context.

Underlying Base Objects

The view is defined over two base objects, both themselves views rather than tables:

• AS_INV_ITEM_LOV_V (aliased as ITEM) — supplies inventory item attributes, including the item identifier, category, organization, interest type and interest codes, concatenated segments, and item description.
• AS_INV_UOM_V (aliased as UOM) — supplies the UOM code and UOM description for each item-organization combination.

The join is performed on two keys: INVENTORY_ITEM_ID and ORGANIZATION_ID. This composite join ensures that the UOM returned corresponds to the item within the correct inventory organization, which is critical in multi-org EBS environments where the same item may carry different UOM definitions per organization. The SELECT DISTINCT clause indicates that the underlying sources may produce duplicate rows, and the view eliminates them to present a clean LOV result set. No base tables are documented as directly referenced; the view operates entirely over the ASF product’s intermediate LOV views.

Key Columns

• INVENTORY_ITEM_ID — Primary identifier of the inventory item; also a join key.
• ORGANIZATION_ID — Inventory organization context; the second join key.
• CATEGORY_ID — Category assignment for the item, useful for filtered LOVs.
• INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID — Sales Online interest classification attributes.
• ITEM_CONCAT_SEGS — Concatenated item key segments, typically used for display in LOV fields.
• ITEM_DESCRIPTION — Descriptive name of the item.
• UOM_CODE — Short code of the unit of measure associated with the item.
• UOM_DESCRIPTION — Full descriptive text of the unit of measure. This column supports display and reporting requirements where the readable UOM label is required rather than the code.

Common Use Cases and Queries

Typical use cases include populating item LOVs in Sales Online forms, validating item-UOM combinations during order entry, and generating reports that require UOM descriptions alongside item details.

Retrieve all item and UOM combinations for a specific organization:

• SELECT inventory_item_id, item_description, uom_code, uom_description FROM asf_inventory_lov_v WHERE organization_id = :org_id;

Filter by UOM description for a specific item:

• SELECT item_description, uom_description FROM asf_inventory_lov_v WHERE inventory_item_id = :item_id AND organization_id = :org_id;

Because the view is not implemented in the reference database, availability must be verified against the target instance before use.