Search Results install_customer




Overview
Explore in AI Chat

Overview

APPS.CS_SYSTEMS_V is a view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is registered in the FND Design Data repository under the application short name CS (Customer Support / Service), and its object definition is shipped as part of the standard Oracle Applications database tier. Within the Oracle E-Business Suite taxonomy the object is classified as a VIEW with VALID status, meaning it is a compiled, dictionary-resident object that can be queried directly by SQL tools and reporting engines.

The view presents installed base system records — customer-owned configurations tracked by the Service (CS) module — in a denormalized form that joins system header information to the associated customer account, party, installation site, and address data held in the Trading Community Architecture (TCA) tables. This makes it a convenient access point for anyone who needs a single-row-per-system picture of the installed base without reconstructing the joins manually. The documentation carries an explicit Oracle Internal Use Only warning: access to Oracle Applications data through this object is supported only from standard Oracle Applications programs, and the view is not published as a supported customer-facing interface. It should therefore be treated as a read-only, diagnostic, and reporting object rather than as an integration contract.

Underlying Base Objects

The documented reference list underlying CS_SYSTEMS_V comprises:

The principal relationship is a one-to-many expansion from CS_SYSTEMS to the TCA site and location tables, collapsed back to a single row through the view's definition. Because it also references FND_GLOBAL, the view is organization-aware and resolves values relative to the current operating unit session context.

Key Columns

Common Use Cases and Queries

Typical scenarios include installed base inventory reporting, coverage analysis for service contracts and warranties, address validation for field service dispatch, and reconciliation between Create Install Base records and TCA. A representative query retrieves all systems for a customer by account number:

  • SELECT system_id, serial_number, system_type, customer_name, cust_account_number FROM cs_systems_v WHERE customer_number = '12345';
  • SELECT system_id, system_type, ship_to_customer, ship_to_address1, ship_state FROM cs_systems_v WHERE org_id = :p_org_id ORDER BY creation_date DESC;
  • SELECT s.serial_number, s.system_type, c.contract_number FROM cs_systems_v s, okc_k_headers_all_b c WHERE s.customer_id = c.cle_id;

Because the object is an unsupported view, joins against service and contract tables should remain read-only, and any production integration should be built against the documented CS_SYSTEMS base table or the published Service APIs rather than the view.