Results for “relationship_type_id”

50+ results




Overview
Explore in AI Chat

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

Overview

ASO_I_RELATED_ITEMS_V is a validity-checked view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the ASO - Order Capture product family and exists to present item relationship data — the associations maintained in Oracle Inventory between an inventory item and its related, substitute, or cross-sell items — in a form that is directly consumable by order capture, pricing, and configuration logic. Rather than requiring callers to join Inventory tables themselves, the view pre-assembles the relationship record together with descriptive and commercial attributes of the related item, including its description, concatenated key flexfield segment value, primary unit of measure, and list price per unit.

For reporting and integration purposes, the view functions as a denormalized, read-only projection. Report developers, order-to-cash extract programs, and interface routines can select from it without resolving the underlying key flexfield structure, UOM codes, or lookup decoding. The column PADDED_CONCATENATED_SEGMENTS is particularly significant: it exposes the fully padded concatenated segment string for the related item, which preserves leading zeros and segment padding enforced by the item key flexfield. This padded form is the value required by many downstream processes and by external systems that must match the segment string exactly, whereas the unpadded CONCATENATED_SEGMENTS is better suited to display.

Underlying Base Objects

The documented base objects referenced by this view are MTL_RELATED_ITEMS_VIEW, MFG_LOOKUPS, and MTL_SYSTEM_ITEMS_VL, all resolved through the APPS schema in the ETRM 12.2.2 metadata. The join logic is as follows:

Because the definition is an inner join across all three sources, a row is returned only where a valid relationship exists, the related item is defined in the same organization, and its relationship type code exists in the manufacturing lookup set.

Key Columns

  • ORGANIZATION_ID, INVENTORY_ITEM_ID — the owning organization and the source item.
  • RELATED_ITEM_ID — the inventory item identifier of the associated item.
  • RELATIONSHIP_TYPE_ID, RELATIONSHIP_TYPE — the lookup code and its decoded meaning from MTL_RELATIONSHIP_TYPES.
  • RECIPROCAL_FLAG — indicates whether the relationship applies in both directions.
  • RELATED_ITEM_DESCRIPTION, RELATED_ITEM, PADDED_CONCATENATED_SEGMENTS — description and the padded/unpadded concatenated segment strings of the related item.
  • UOM, UNIT_PRICE — the primary UOM code and list price per unit of the related item.

Common Use Cases and Queries

Typical usage includes exposing related and substitute items on order entry screens, driving cross-sell suggestions, and supplying external catalogs with padded item keys. A representative query retrieving all relationships for a given item, returning the padded segment value searched for:

  • SELECT related_item, padded_concatenated_segments, relationship_type, uom, unit_price FROM aso_i_related_items_v WHERE organization_id = :org AND inventory_item_id = :item;
  • SELECT inventory_item_id, related_item_id, padded_concatenated_segments FROM aso_i_related_items_v WHERE relationship_type = 'Substitute' AND organization_id = :org;

Because the view is a read-only projection, it must not be used for DML; relationship maintenance is performed against the underlying Inventory relationship entities.