Results for “csi_systems_vl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSI_SYSTEMS_VL is an APPS-owned, multilingual (VL) view within the Oracle E-Business Suite Install Base module (CSI). In Release 12.1.1 and 12.2.2, it presents the user-facing, language-translated representation of customer systems maintained in Oracle Install Base. A "system" in Install Base is a logical grouping of related instances (for example, a configured server with its dependent components, or a customer site treated as a single maintainable unit). The VL view joins the language-independent base table to the translation table so that the NAME and DESCRIPTION columns are returned in the session language of the querying user, resolved through USERENV('LANG'). Because it carries the translated attributes, CSI_SYSTEMS_VL is the appropriate access point for any reporting, integration, or custom code that must display system names and descriptions, while CSI_SYSTEMS_B remains the object used for DML and for language-independent attribute access. The view is reported as VALID in the ETRM registry.
Underlying Base Objects
The documented definition of CSI_SYSTEMS_VL is an equi-join between two base objects, both referenced through APPS synonyms:
- CSI_SYSTEMS_B — the language-independent base table holding system identifiers, foreign keys, descriptive flexfield context and attributes, and audit columns.
- CSI_SYSTEMS_TL — the translation table supplying NAME and DESCRIPTION per installed language.
The join predicate is CSB.SYSTEM_ID = CST.SYSTEM_ID combined with CST.LANGUAGE = USERENV('LANG'). Consequently, the view returns exactly one row per system for the language of the current session, and joins made against it in SQL inherit that language filter. Rows are only returned for systems that have a translation row in the session language, which in a normally configured EBS instance is guaranteed for each defined system.
Key Columns
- SYSTEM_ID — primary key of the system; the join key to nearly every other Install Base object.
- NAME, DESCRIPTION — translated values sourced from CSI_SYSTEMS_TL.
- CUSTOMER_ID, OPERATING_UNIT_ID — the owning customer and the operating unit under which the system was created.
- SYSTEM_NUMBER, SYSTEM_TYPE_CODE, CONFIG_SYSTEM_TYPE — the user-visible system number and the classification of the system, including whether it represents a configuration.
- PARENT_SYSTEM_ID, AUTOCREATED_FROM_SYSTEM_ID — hierarchical relationships and the source system from which the record was generated.
- SHIP_TO_CONTACT_ID, BILL_TO_CONTACT_ID, TECHNICAL_CONTACT_ID, SERVICE_ADMIN_CONTACT_ID — party/contact assignments used by service and depot processes.
- SHIP_TO_SITE_USE_ID, BILL_TO_SITE_USE_ID, INSTALL_SITE_USE_ID — site-use references locating the system at a customer address.
- START_DATE_ACTIVE, END_DATE_ACTIVE — the effective date range of the system record; NULL END_DATE_ACTIVE indicates an open-ended record.
- COTERMINATE_DAY_MONTH, CONTEXT, ATTRIBUTE1–ATTRIBUTE15 — service contract cotermination control and the descriptive flexfield context and segments.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the Install Base APIs.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical scenarios include reporting on customer systems by name, listing active systems for a given operating unit, and driving integrations that must publish translated system names. The following query lists active systems for a specific customer:
SELECT system_id, system_number, name, system_type_code
FROM csi_systems_vl
WHERE customer_id = :p_customer_id
AND (end_date_active IS NULL OR end_date_active > SYSDATE)
ORDER BY name;
Because the view is keyed on SYSTEM_ID, it is frequently joined to CSI_ITEM_INSTANCES or to the Install Base instance views to enumerate the instances belonging to each system, and to CSI_SYSTEMS_B when non-translated attributes or DML access is required. Reporting users should note that the view performs no operating unit (MOAC) filtering; the OPERATING_UNIT_ID column must be constrained explicitly when multi-org security is required. In release 12.2.2 the object remains unchanged in structure from 12.1.1, so existing custom queries remain portable across both releases.
-
View: CSI_SYSTEMS_VL 12.2.2
Multi Lingual View for Systems.
APPS.CSI_SYSTEMS_VL·↳ CSI_SYSTEMS_B·↳ CSI_SYSTEMS_TL·Explore CSI module →
-
View: CSI_SYSTEMS_VL 12.1.1
Multi Lingual View for Systems.
APPS.CSI_SYSTEMS_VL·↳ CSI_SYSTEMS_B·↳ CSI_SYSTEMS_TL·Explore CSI module →
-
VIEW: APPS.CSI_SYSTEMS_VL 12.1.1
-
VIEW: APPS.CSI_SYSTEMS_VL 12.2.2
-
View: CSI_CP_SYSTEMS_RG_V 12.2.2
Backward Compatible : Customer Product - Systems Record Groups.
APPS.CSI_CP_SYSTEMS_RG_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_LOOKUPS·↳ CSI_SYSTEMS_VL·Explore CSI module →
-
View: CS_SR_SYSTEMS_V 12.2.2
This view brings data related to systems and corresponding customer details.
APPS.CS_SR_SYSTEMS_V·↳ CSI_SYSTEMS_VL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CS module →
-
View: CSI_BIS_TXN_DTLS_V 12.2.2
View created for the Oracle IT - GSI
APPS.CSI_BIS_TXN_DTLS_V·↳ CSI_SYSTEMS_VL·↳ CSI_TXN_SUB_TYPES·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
View: CSI_CP_SYSTEMS_RG_V 12.1.1
Backward Compatible : Customer Product - Systems Record Groups.
APPS.CSI_CP_SYSTEMS_RG_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_LOOKUPS·↳ CSI_SYSTEMS_VL·Explore CSI module →
-
View: CS_SR_SYSTEMS_V 12.1.1
This view brings data related to systems and corresponding customer details.
APPS.CS_SR_SYSTEMS_V·↳ CSI_SYSTEMS_VL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore CS module →
-
View: CSI_BIS_TXN_DTLS_V 12.1.1
View created for the Oracle IT - GSI
APPS.CSI_BIS_TXN_DTLS_V·↳ CSI_SYSTEMS_VL·↳ CSI_TXN_SUB_TYPES·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
VIEW: APPS.CS_SR_SYSTEMS_V 12.1.1
-
View: CSI_SYSTEMS_V 12.1.1
System Details with foreign key resolutions.
APPS.CSI_SYSTEMS_V·↳ CSI_LOOKUPS·↳ CSI_SYSTEMS_VL·↳ HR_OPERATING_UNITS·Explore CSI module →
-
SYNONYM: APPS.CSI_SYSTEMS_B 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.CSI_SYSTEMS_TL 12.1.1
-
VIEW: APPS.CS_SR_SYSTEMS_V 12.2.2
-
This View retrives the Subscriptions from the Installed Base
Not implemented in this database·Explore XNC module →
-
SYNONYM: APPS.CSI_SYSTEMS_TL 12.2.2