Search Results cs_line_inst_details




Overview
Explore in AI Chat

Overview

The CS_LINE_INST_DETAILS table is a core transactional data object within the Oracle E-Business Suite Service (CS) module for versions 12.1.1 and 12.2.2. It serves as the definitive repository for capturing and storing installation-specific information for a product at the precise moment of order or quote entry. This table is fundamental to the service logistics and contract fulfillment processes, as it links sales transactions (orders and quotes) to the installed base of customer products. By persisting installation details at the time of the transaction, it provides a critical audit trail and ensures the service organization has the correct contextual data—such as installation location and associated customer product—to support subsequent service delivery, warranty management, and contract administration.

Key Information Stored

The table's primary key is the system-generated identifier, LINE_INST_DETAIL_ID. Its most significant columns are foreign keys that establish essential relationships with other EBS entities. The ORDER_LINE_ID and QUOTE_LINE_SHIPMENT_ID columns link the installation details directly to the originating sales order line (in Order Management, OE) or the quote shipment line (in Advanced Sales, ASO), respectively. The CUSTOMER_PRODUCT_ID associates the line with a specific serialized item in the installed base (CS_CUSTOMER_PRODUCTS_ALL). The INSTALLED_AT_PARTY_SITE_ID defines the physical installation location by referencing the party site (HZ_PARTY_SITES). Other crucial references include the SYSTEM_ID, which can group the product into a logical system, and the TRANSACTION_TYPE_ID, which classifies the nature of the service transaction.

Common Use Cases and Queries

A primary use case is generating reports or providing data for service technicians that detail what was ordered, where it was to be installed, and against which customer product. For instance, a query to fetch installation details for a specific order would join CS_LINE_INST_DETAILS to OE_ORDER_LINES_ALL and HZ_PARTY_SITES. Another critical scenario involves tracing the provenance of a customer product in the installed base back to its original sales order line by querying via the CUSTOMER_PRODUCT_ID and ORDER_LINE_ID. The table is also pivotal during returns processing, as indicated by the NEW_CP_RMA_LINE_ID and INSTALLED_CP_RMA_LINE_ID columns, which link to Return Material Authorization (RMA) lines to manage replacements and updates to installation records.

Related Objects

CS_LINE_INST_DETAILS has extensive foreign key relationships, making it a central hub within the Service schema. Key documented relationships include:

  • OE_ORDER_LINES_ALL: Linked via ORDER_LINE_ID, NEW_CP_RMA_LINE_ID, and INSTALLED_CP_RMA_LINE_ID for order and RMA line details.
  • ASO_SHIPMENTS: Linked via QUOTE_LINE_SHIPMENT_ID for quotation-related installation data.
  • CS_CUSTOMER_PRODUCTS_ALL: Linked via CUSTOMER_PRODUCT_ID (the installed product) and is referenced by that table's ORIGINAL_LINE_SERV_DETAIL_ID.
  • CS_SYSTEMS_ALL_B: Linked via SYSTEM_ID for logical system grouping.
  • HZ_PARTY_SITES: Linked via INSTALLED_AT_PARTY_SITE_ID for the installation address.
  • CS_TRANSACTION_TYPES_B: Linked via TRANSACTION_TYPE_ID for the service transaction classification.
  • CS_CP_REVISIONS: References this table via its LINE_SERVICE_DETAIL_ID column.
  • CS_LINE_INST_DETAILS (Self-Referential): Linked via SOURCE_LINE_INST_DETAIL_ID to track lineage between related installation detail records.