Search Results current_serial_number




Overview
Explore in AI Chat

Overview

APPS.CS_CONFIG_RG_V is a reporting view in the Oracle E-Business Suite Customer Support (CS) / TeleService and Field Service schema. It presents a flattened, denormalized representation of the configured-item hierarchy maintained in the customer product tables, exposing both the parent and the top-level (root) configured item for each configuration relationship. In EBS 12.1.1 and 12.2.2 the view is owned by APPS and is used primarily for diagnostics, reporting, and integration queries where an installation or service engineer needs to resolve the genealogy of a configured product instance without writing recursive SQL.

The view is particularly relevant to searches for current_serial_number. It exposes two serialized columns — PARENT_SERIAL_NUMBER and TOP_SERIAL_NUMBER — sourced from CS_CUSTOMER_PRODUCTS_ALL.CURRENT_SERIAL_NUMBER. This allows a user to retrieve the serial number of an item at a given node and the serial number of the configuration root in a single query, which is valuable when serial-number tracking spans a multi-level configured bill of materials.

Underlying Base Objects

The view is defined over four documented base objects:

  • CS_CUSTOMER_PRODUCTS_ALL (SYNONYM) — aliased twice as CP1 (parent) and CP2 (top/root). This is the core customer-product instance table in the CS schema.
  • MTL_SYSTEM_ITEMS_KFV (SYNONYM) — aliased twice as KFV1 and KFV2, providing the concatenated item segments and item description for the parent and top items.
  • CS_STD (PACKAGE) — supplies GET_ITEM_VALDN_ORGZN_ID, which restricts item joins to the validation organization defined for the CS installation.
  • CSICUMPI_PUB (PACKAGE) — documented as a referenced package, generally associated with the customer-product instance APIs that maintain the underlying data.

The join path is a self-join on CS_CUSTOMER_PRODUCTS_ALL: CP2.CUSTOMER_PRODUCT_ID = CP1.CONFIG_ROOT_ID, meaning CP1 is any configured child and CP2 is the root of the configuration that child belongs to. Each is then joined to MTL_SYSTEM_ITEMS_KFV on inventory_item_id, filtered by the CS validation organization.

Key Columns

Common Use Cases and Queries

Typical uses include configuration genealogy reporting, service-desk lookup by serial number, and reconciliation of configured instances before upgrade. To locate a configuration by its serial number:

  • SELECT parent_cp_id, parent_reference_number, parent_product, parent_serial_number, top_reference_number, top_product, top_serial_number FROM apps.cs_config_rg_v WHERE parent_serial_number = :serial;
  • SELECT * FROM apps.cs_config_rg_v WHERE top_serial_number = :serial;

Because the view restricts MTL_SYSTEM_ITEMS_KFV to the CS validation organization, results are scoped to configurations defined in the current environment. For hierarchical (multi-level) traversal beyond the parent/root pair, the view is generally joined back to CS_CUSTOMER_PRODUCTS_ALL on CONFIG_ROOT_ID.