Search Results css_def_platforms_vl

Overview

The view CSS_DEF_PLATFORMS_VL belongs to the Oracle E-Business Suite module CSS – Support, which is documented as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. This view exposes a platform catalog used by the CSS Support product, presenting supported platform definitions (hardware, operating systems, or similar configurations) as inventory item records filtered to a designated platform category set. It is an operational view rather than a descriptive or reporting-only construct: it depends on two database functions from the CSS_DEF_MTL_API package to resolve the inventory organization and the platform category set at runtime.

The view plays a reporting and integration role consistent with other CSS product catalog views. It allows Oracle Support/Service modules—and any downstream reporting that references it—to query the current set of defined platforms without hard-coding organization or category-set identifiers. Because the platform definitions are stored as inventory items in MTL_SYSTEM_ITEMS_VL and categorized through MTL_ITEM_CATEGORIES, the view reconciles the item master with category assignments to produce a clean, ready-to-consume platform list.

Underlying Base Objects

The ETRM metadata documents two referenced base objects. The primary source table is MTL_SYSTEM_ITEMS_VL, the item master view, which supplies the platform identifier, concatenated segment name, description, and revision control code. The second is MTL_ITEM_CATEGORIES, which provides the category assignment linking each item to the platform category set. The join condition requires that both tables share the same ORGANIZATION_ID and INVENTORY_ITEM_ID, ensuring that only items assigned to this category within the platform inventory organization are returned.

Two additional objects are referenced only through subqueries: CSS_DEF_MTL_API.GET_INV_ORGANIZATION_ID and CSS_DEF_MTL_API.GET_PLATFORM_CAT_SET_ID. These package functions encapsulate the environment-specific organization ID and platform category set ID, so the view adapts across installations without modification. The metadata notes the view is not implemented in every database, reflecting the obsolete status of the CSS – Support module.

Key Columns

The view exposes four columns. Their names differ from the underlying item column aliases, indicating the view assigns meaningful platform semantics:

• PLATFORM_INV_ITEM_ID — Maps to ITEM.INVENTORY_ITEM_ID, the unique inventory item identifier for the platform.
• PLATFORM_NUMBER — Maps to ITEM.CONCATENATED_SEGMENTS, the concatenated item key flexfield segments that form the platform's display number.
• PLATFORM_DESCRIPTION — Maps to ITEM.DESCRIPTION, the descriptive text for the platform.
• PLATFORM_REVISION_CONTROL_CODE — Maps to ITEM.REVISION_QTY_CONTROL_CODE, indicating the revision quantity control behavior for the platform item.

Because the view is keyed on inventory items, these columns align directly with standard EBS item attributes, allowing interoperability with inventory and order management reporting.

Common Use Cases and Queries

Typical usage includes validating platform setup, joining platform definitions in support or service reporting, and confirming which items are assigned to the platform category set. The view is useful during implementation checks and diagnostics where the configured organization or category set must be verified.

Listing all defined platforms:

SELECT platform_number,
       platform_description,
       platform_revision_control_code
FROM   css_def_platforms_vl
ORDER BY platform_number;

Locating a specific platform by item ID:

SELECT platform_inv_item_id,
       platform_number,
       platform_description
FROM   css_def_platforms_vl
WHERE  platform_inv_item_id = :item_id;

Because the view resolves its organization and category set internally, queries against it automatically reflect the current CSS configuration without additional WHERE clauses. Given the module's obsolete status, report developers should confirm availability before relying on this view in customizations or extracts.