Search Results collateral_flag




Overview
Explore in AI Chat

Overview

APPS.ASO_I_ITEMS_V is a reporting and integration view in the Oracle E-Business Suite Order Management and Advanced Pricing schema (ASO). As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, the view exposes item master attributes relevant to service, warranty, catalog, and order-entry processing. It is defined over MTL_SYSTEM_ITEMS_VL, the value-set-enabled item master view, and is owned by the APPS schema. Because ASO_I_ITEMS_V is a simple projection rather than a stored table, it inherits the multitenancy, translation, and organization-specific behavior of the underlying MTL_SYSTEM_ITEMS_VL view, including its item description joins for the user's session language. The view is commonly used by order capture, service contracts, and pricing components that must qualify items as serviceable products, service items, warranties, or collateral, and that must retrieve catalog and pricing attributes in a single query. The presence of BASE_WARRANTY_SERVICE_ID, SERVICE_ITEM_FLAG, and the serviceability flags makes the view particularly relevant to warranty and service offering configuration in Oracle Service and Oracle Order Management.

Underlying Base Objects

The ETRM documentation identifies a single referenced base object: MTL_SYSTEM_ITEMS_VL, itself a view over INV.MTL_SYSTEM_ITEMS_B (the organization-specific item attribute table) and its translations table. Wrapping this value-set view provide the concatenated segment display columns (CONCATENATED_SEGMENTS, PADDED_CONCATENATED_SEGMENTS), key flexfield segment columns, and the descriptive and attribute columns used by pricing and service applications. Consequently, any change in item master data—item status, service flags, or the base warranty reference—is reflected immediately when querying ASO_I_ITEMS_V, with no staging or denormalization layer. The view does not modify MTL_SYSTEM_ITEMS_VL; it is a read-only projection intended for consumer applications in the ASO module.

Key Columns

Common Use Cases and Queries

Typical usage includes identifying the base warranty item for a sellable product and listing orderable service items in a given organization.

  • Locate items referencing a specific base warranty service:
SELECT inventory_item_id, organization_id, concatenated_segments, base_warranty_service_id
FROM   aso_i_items_v
WHERE  base_warranty_service_id = :p_base_warranty_service_id
AND    customer_order_enabled_flag = 'Y';
  • Retrieve all service items available for order entry:
SELECT inventory_item_id, concatenated_segments, service_duration, service_duration_period_code
FROM   aso_i_items_v
WHERE  service_item_flag = 'Y'
AND    customer_order_enabled_flag = 'Y'
AND    enabled_flag = 'Y';

Because the view joins directly to the item master, queries should always filter by ORGANIZATION_ID to avoid cross-organization duplication, and should restrict to ENABLED_FLAG = 'Y' and NVL(END_DATE_ACTIVE, SYSDATE+1) > SYSDATE where active-only results are required.