Results for “inventory_item_id”

50+ results




Overview
Explore in AI Chat

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

Overview

CS_SR_INV_COMPONENTS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, classified under the Service (CS) product family. Its documented purpose is to expose all inventory components derived from a bill of materials (BOM). In practice, the view flattens the relationship between a parent assembly and its component items so that service, depot repair, and field service logic can identify which inventory items constitute a given assembly at a point in time.

Because the view is defined entirely over other EBS views and synonyms, it carries no stored data of its own and reflects the current state of the underlying BOM and item master tables at query time. It is therefore most commonly consumed for reporting, integration extracts, and validation logic within the Service modules, where a component list is required without directly navigating the more complex BOM schema. The object is documented as VALID in ETRM 12.2.2, indicating the definition compiles cleanly against its referenced objects.

Underlying Base Objects

The view is defined over the following documented base objects:

  • BOM_BILL_OF_MMATERIALS (VIEW) — supplies the bill of materials header, including organization, assembly item, common bill sequence, and the alternate BOM designator filter.
  • BOM_INVENTORY_COMPONENTS (VIEW) — supplies the component lines, including component item, effectivity date, and disable date.
  • MTL_SYSTEM_ITEMS_VL (VIEW) — provides the concatenated segment description of the component item (aliased KFV in the definition).
  • MTL_SYSTEM_ITEMS (SYNONYM) — provides the inventory item reference for the parent assembly.
  • FND_GLOBAL (PACKAGE) — referenced in the general EBS context for runtime session values, though not central to the join logic.

The definition joins MTL_SYSTEM_ITEMS_VL to BOM_INVENTORY_COMPONENTS on component item and organization, links BOM_INVENTORY_COMPONENTS to BOM_BILL_OF_MATERIALS on the common bill sequence, and joins MTL_SYSTEM_ITEMS back to BOM_BILL_OF_MATERIALS on the assembly item and organization. A key filter restricts BOM_BILL_OF_MATERIALS.ALTERNATE_BOM_DESIGNATOR to NULL, so only the primary BOM is represented. The view also applies an effective-date condition, returning rows where the current date falls between the component effectivity date and the disable date (or is unbounded when disable date is null).

Key Columns

  • ORGANIZATION_ID — the inventory organization in which the assembly and component relationship is valid.
  • COMPONENT_ID — the inventory item identifier of the component, aliased from KFV.INVENTORY_ITEM_ID.
  • DESCRIPTION — the description of the component item, sourced from the item master view.
  • CONCATENATED_SEGMENTS — the concatenated key flexfield segments for the component item, providing a human-readable item identifier.
  • INVENTORY_ITEM_ID — the parent assembly inventory item identifier, sourced from MTL_SYSTEM_ITEMS and joined through the BOM assembly item.

Common Use Cases and Queries

Typical scenarios include retrieving the active component list for an assembly in a specific organization, feeding service repair or depot workflows, and validating whether a part is a valid component of a parent. A representative query is:

SELECT organization_id, inventory_item_id, component_id, concatenated_segments, description FROM apps.cs_sr_inv_components_v WHERE organization_id = :org_id AND inventory_item_id = :assembly_item_id;

Because the view already restricts rows to currently effective components of the primary BOM, callers do not need to reapply effectivity logic. Users should note, however, that alternate BOMs are excluded by design, so any requirement covering alternate structures must be handled against the base BOM views directly.