Results for “config_root_id”

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

Overview

CS_ACC_CP_RG_V is a valid APPS-owned database view in the Oracle E-Business Suite Service (CS) module. Its documented purpose is to support the main service request form, where it is consumed by a record group to retrieve install base information. In practical terms, the view exposes customer product (install base) records together with the item definition, system, revision, and status data needed to populate the customer product field on the service request window.

The view is defined with a SYSDATE predicate against the effective date range on CS_CUSTOMER_PRODUCTS_ALL, and it excludes certain inactive status identifiers (4 and 1003). As a result, it returns only currently effective customer products. Because it joins order line and order header data, it also surfaces the original sales order context associated with the installed item.

A notable characteristic of this view is that it explicitly projects placeholder columns. PLATFORM_ID, PLATFORM, PLATFORM_VERSION_ID, and VERSION are returned as typed NULLs rather than values sourced from a base table. This is directly relevant to searches for platform_version_id: although the column exists in the view's projection, it is not populated by this view. Its presence maintains a consistent record group structure for the service request form while the underlying platform data is supplied elsewhere, such as through the CSICUMPI_PUB package referenced in the metadata.

Underlying Base Objects

The view is defined over the following documented base objects:

• CS_CUSTOMER_PRODUCTS_ALL — the primary install base table (aliased CP), supplying customer product identifier, serial number, system, revision, status, reference number, lot number, configuration hierarchy, organization, customer, and install site.
• CS_CUSTOMER_PRODUCT_STATUSES — provides the status name and the INCIDENT_ALLOWED_FLAG.
• CS_CP_REVISIONS — supplies the revision identifier text for the current revision.
• CS_SYSTEMS — supplies the system name; joined with an outer join.
• CS_LOOKUPS — outer-joined on lookup type CUSTOMER_PRODUCT_TYPE for the type code.
• MTL_SYSTEM_ITEMS_KFV — the concatenated item description view, providing product name, description, and item type. The join is constrained to the inventory validation organization returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID.
• OE_ORDER_LINES_ALL and OE_ORDER_HEADERS_ALL — outer-joined through ORIGINAL_ORDER_LINE_ID to supply the order number and customer PO number.

The metadata additionally lists CS_STD, FND_GLOBAL, and CSICUMPI_PUB as referenced objects; these are packages used by the view definition or its supporting logic rather than row sources.

Key Columns

• CUSTOMER_PRODUCT_ID — primary identifier of the install base record.
• PRODUCT_NAME / PRODUCT_DESCRIPTION / PRODUCT_TYPE — derived from the concatenated item flexfield view.
• INVENTORY_ITEM_ID — inventory item identifier for the installed product.
• CURRENT_SERIAL_NUMBER, LOT_NUMBER, REFERENCE_NUMBER — identification attributes of the installed unit.
• SYSTEM_ID / SYSTEM_NAME — the system to which the customer product belongs.
• CURRENT_CP_REVISION_ID / REVISION — current revision of the customer product.
• CUSTOMER_PRODUCT_STATUS_ID / CUSTOMER_PRODUCT_STATUS / INCIDENT_ALLOWED_FLAG — status and whether incidents may be created.
• CONFIG_ROOT_ID / CONFIG_PARENT_ID — configuration hierarchy linkage.
• CUST_PO_NUMBER / ORDER_NUMBER — original order context.
• ORG_ID, CUSTOMER_ID, INSTALL_SITE_USE_ID — multi-org and party/site context.
• PLATFORM_ID, PLATFORM, PLATFORM_VERSION_ID, VERSION — structural placeholders returned as NULL.

Common Use Cases and Queries

Typical use is to resolve the install base entries available for a service request, filtered by item, serial number, or system. For example, locating a product by serial number:

• SELECT customer_product_id, product_name, current_serial_number, system_name, revision, customer_product_status
• FROM cs_acc_cp_rg_v
• WHERE current_serial_number = :serial_number;

Retrieving all effective products for a given system:

• SELECT customer_product_id, product_name, reference_number, order_number
• FROM cs_acc_cp_rg_v
• WHERE system_id = :system_id
• ORDER BY product_name;

Because PLATFORM_VERSION_ID is a constant NULL, queries that filter or report on platform version against this view will return no meaningful platform data; platform and version information must be obtained from the sources that populate it, consistent with the role of CSICUMPI_PUB in the documented metadata. Note also that the view applies its own effective-date and status filters, so callers do not need to re-apply them.