Search Results csi_ii_relation_types




Overview
Explore in AI Chat

Overview

The table CSI_II_RELATION_TYPES is a core reference data object within the Oracle E-Business Suite (EBS) Install Base (CSI) module, specifically for versions 12.1.1 and 12.2.2. It functions as a master repository for defining the permissible types of relationships that can exist between two inventory items, known as instances, within the Install Base system. The table's primary role is to enforce data integrity and provide a standardized set of relationship classifications, such as "Parent-Child," "Connected To," or "Replaced By." This foundational setup is critical for accurately modeling complex asset structures, tracking component hierarchies, and understanding dependencies between physical or logical items throughout their lifecycle.

Key Information Stored

The central column in this table is the RELATIONSHIP_TYPE_CODE, which serves as the primary key. This column stores the unique, short-form identifier for each relationship type (e.g., 'PARENT', 'CONNECTED'). While the provided ETRM metadata does not list additional columns, typical reference tables in EBS also include descriptive columns such as a NAME or DESCRIPTION to provide a user-friendly explanation of the code, and columns for controlling enabled status, start/end dates, and who created or last updated the record. The data is static and maintained via the application's setup interface, not through direct data manipulation.

Common Use Cases and Queries

This table is primarily referenced when creating, validating, or reporting on instance relationships. A common use case is generating a report to list all available relationship types for configuration in the application setup. Another key scenario involves querying the specific relationships between instances for service or asset management purposes, requiring a join to the relationship transaction table. A fundamental sample query to retrieve all active relationship types would be:

  • SELECT relationship_type_code, name FROM csi_ii_relation_types WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

For reporting on actual instance relationships, a join is essential:

  • SELECT rel.subject_id, rel.object_id, rel_type.name FROM csi_ii_relationships rel, csi_ii_relation_types rel_type WHERE rel.relationship_type_code = rel_type.relationship_type_code;

Related Objects

The CSI_II_RELATION_TYPES table is integral to the Install Base data model, with its primary key referenced by transactional tables. As documented in the provided metadata, the following foreign key relationships exist:

  • CSI_II_RELATIONSHIPS: This is the main transactional table that stores the actual created relationships between item instances. Its column CSI_II_RELATIONSHIPS.RELATIONSHIP_TYPE_CODE is a foreign key to CSI_II_RELATION_TYPES, ensuring every recorded relationship uses a valid, predefined type.
  • CSI_T_II_RELATIONSHIPS: This is likely a transactional or interface table (as indicated by the 'T_' prefix). It also references the master types table via its column CSI_T_II_RELATIONSHIPS.RELATIONSHIP_TYPE_CODE, maintaining the same referential integrity for data being processed into the system.