Results for “csi_bc_systems_vl”

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

Overview

CSI_BC_SYSTEMS_VL is a backward-compatibility multilingual view owned by the APPS schema within the CSI - Install Base product module of Oracle E-Business Suite. The view presents a denormalized, language-aware projection of system (install base) records by joining the base table CSI_SYSTEMS_B with its translation table CSI_SYSTEMS_TL. Its role is to preserve the column interface and naming conventions that existed prior to the Install Base schema redesign, allowing customizations, reports, interfaces, and integrations written against the legacy object to continue functioning on EBS 12.1.1 and 12.2.2 without modification.

The view is documented as VALID and is intended primarily for read access in reporting and integration scenarios. Because it resolves translated columns (NAME, DESCRIPTION) using the session language, it returns user-facing text in the runtime language of the querying session.

Underlying Base Objects

The view is defined over two documented base objects, both accessed through synonyms owned by APPS:

• CSI_SYSTEMS_B — the base (non-translated) system table, aliased as B. It supplies all functional columns including identifiers, contact references, site use references, status dates, descriptive flexfield attributes, and audit columns.
• CSI_SYSTEMS_TL — the translation table, aliased as T. It supplies the language-dependent NAME and DESCRIPTION columns.

The join condition is B.SYSTEM_ID = T.SYSTEM_ID AND T.LANGUAGE = USERENV('LANG'), ensuring each row is returned in the session language. The view also exposes a literal NULL ORG_ID, a compatibility artifact for callers that expected a multi-org column.

Key Columns

• ROW_ID — maps to the B.ROWID pseudo-column, providing a physical row locator for the base table.
• SYSTEM_ID — the primary system identifier, joining the base and translation tables.
• CUSTOMER_ID — the owning customer of the system.
• SYSTEM_TYPE_CODE / CONFIG_SYSTEM_TYPE — classification of the system, including configuration typing.
• SERIAL_NUMBER — the externally visible system number (aliased from SYSTEM_NUMBER for backward compatibility).
• PARENT_SYSTEM_ID and AUTOCREATED_FROM_SYSTEM_ID — hierarchical and lineage references between systems.
• BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, SERVICE_ADMIN_CONTACT_ID, and TECHNICAL_CONTACT_ID — the four contact role references. Of particular note to users searching on this view, TECHNICAL_CONTACT_ID identifies the contact responsible for technical matters on the system; it corresponds to a party/contact identifier resolvable through contact-related tables.
• BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID, INSTALL_SITE_USE_ID — site use references for the billing, shipping, and installation locations.
• START_DATE_ACTIVE, END_DATE_ACTIVE, COTERMINATE_DAY_MONTH — lifecycle and cotermination scheduling attributes.
• ATTRIBUTE1 through ATTRIBUTE15, CONTEXT — descriptive flexfield segments.
• NAME and DESCRIPTION — translated values from CSI_SYSTEMS_TL.

Common Use Cases and Queries

Typical uses include install base reports, contact responsibility listings, and legacy integrations that require system records with translated names and technical contact references.

• Retrieve systems with their technical contact:
  SELECT system_id, serial_number, technical_contact_id, name FROM csi_bc_systems_vl WHERE technical_contact_id IS NOT NULL;
• List all contact roles for a system:
  SELECT serial_number, bill_to_contact_id, ship_to_contact_id, service_admin_contact_id, technical_contact_id FROM csi_bc_systems_vl WHERE customer_id = :p_customer_id;
• Report active systems in session language:
  SELECT serial_number, name, description FROM csi_bc_systems_vl WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);

Because the view is a compatibility layer, new development should generally target the current Install Base base tables directly; existing callers may continue to rely on CSI_BC_SYSTEMS_VL without change.