Search Results platform_number

Overview

CSS_DEF_PRODUCT_PLATFORMS_VL is a view within the Oracle E-Business Suite Support (CSS) module, a component of the ETRM (E-Business Suite Technology Reference Manual) catalog. Its name follows the standard EBS convention for a "VL" view, denoting a validated, language-enabled (translated) view that exposes both the primary key identifier and the user-facing translation columns for a defined entity. In this case, the entity represents the association bridges between defined products and the platforms on which those products are supported.

The view is categorized under the CSS - Support product, which the ETRM metadata explicitly marks as obsolete. The implementation note confirms that the object is "Not implemented in this database," meaning that within a standard EBS 12.1.1 or 12.2.2 installation the view may not physically exist, or exists only in legacy schemas where the Support (CSS) application was previously deployed. It is therefore encountered primarily in historical or customized environments rather than in fresh installations.

Underlying Base Objects

The view text is composed as a join between two validated language views:

• CSS_DEF_PRODUCTS_VL (aliased as PRODUCT) — provides the product definition records, including PRODUCT_INV_ITEM_ID.
• CSS_DEF_PLATFORMS_VL (aliased as PLATFORM) — provides the platform definition records, including PLATFORM_INV_ITEM_ID, PLATFORM_NUMBER, PLATFORM_DESCRIPTION, and PLATFORM_REVISION_CONTROL_CODE.

No explicit WHERE clause or outer-join syntax is documented, indicating a cartesian-style association in which every product row is paired with every platform row to form the full product-to-platform support matrix. The ETRM metadata records no separately documented base tables beneath these VL views, and the referenced base objects section lists none, so the physical detail tables underlying the VL definitions are implied rather than enumerated.

Key Columns

The view exposes five columns:

• PRODUCT_INV_ITEM_ID — the inventory item identifier for the defined product. This is the foreign key linking back to the product definition.
• PLATFORM_INV_ITEM_ID — the inventory item identifier for the platform entry.
• PLATFORM_NUMBER — the identifier number assigned to the platform. This column is the one most commonly associated with the search term "platform_number," as it uniquely labels a platform record for reporting and reference.
• PLATFORM_DESCRIPTION — the descriptive name or text for the platform.
• PLATFORM_REVISION_CONTROL_CODE — a code indicating the revision-control status of the platform record.

Together these columns yield a flattened, query-friendly list of every product supported on every configured platform, with the platform_number serving as the primary human-readable key.

Common Use Cases and Queries

Because the view is obsolete and generally absent from standard EBS instances, use cases are confined to legacy Support-module reporting, historical data migration, or reconciliation of old platform definitions. A typical query retrieves all platforms associated with a given product:

• SELECT PRODUCT_INV_ITEM_ID, PLATFORM_NUMBER, PLATFORM_DESCRIPTION FROM CSS_DEF_PRODUCT_PLATFORMS_VL;
• SELECT p.PLATFORM_NUMBER FROM CSS_DEF_PRODUCT_PLATFORMS_VL p WHERE p.PLATFORM_REVISION_CONTROL_CODE = 'Y';

Because the documented join lacks a filtering predicate, queries returning large result sets from a populated environment should be constrained on PRODUCT_INV_ITEM_ID or PLATFORM_NUMBER. Administrators should first confirm object existence via ALL_VIEWS before relying on the view in 12.1.1 or 12.2.2, given its obsolete and un-implemented status.