Search Results cs_line_inst_details_pk

Overview

CS_LINE_INST_DETAILS is a Service (CS) module table that stores installation details for a product captured at the time of order or quote entry. It belongs to the CS schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. The table serves as the bridge between order management transactions and the installed base maintained by Service. When a customer orders or quotes a product that must be installed at a customer site, the installation attributes — where the item is to be installed, when installation is expected, and how the resulting customer product record relates to return or RMA activity — are persisted here.

Based on the foreign key structure, the table exhibits a satellite-leaning Data Vault classification. It is best modeled as a satellite attached to the order line hub, since its primary key is a surrogate and its foreign keys reference multiple hub-like entities including order lines, customer products, systems, and party sites. The heavy concentration of descriptive and lifecycle attributes further supports satellite treatment rather than hub or link designation.

Key Information Stored

The surrogate primary key is LINE_INST_DETAIL_ID, enforced through CS_LINE_INST_DETAILS_PK. The principal business-key candidate linking the record back to order entry is ORDER_LINE_ID, a foreign key to OE_ORDER_LINES_ALL. Quote-driven installation records are tied through QUOTE_LINE_SHIPMENT_ID to ASO_SHIPMENTS. The installed base association is carried by CUSTOMER_PRODUCT_ID to CS_CUSTOMER_PRODUCTS_ALL, along with CUSTOMER_PRODUCT_TYPE_CODE and CUSTOMER_PRODUCT_QUANTITY describing the installed item.

Physical placement data includes INSTALLED_AT_PARTY_SITE_ID to HZ_PARTY_SITES, SYSTEM_ID to CS_SYSTEMS_ALL_B, and EXPECTED_INSTALLATION_DATE. Lifecycle and RMA columns include INSTALLED_CP_RETURN_BY_DATE, INSTALLED_CP_RMA_LINE_ID, NEW_CP_RETURN_BY_DATE, and NEW_CP_RMA_LINE_ID — the latter three also referencing OE_ORDER_LINES_ALL. Self-referencing lineage is captured through SOURCE_LINE_INST_DETAIL_ID. Audit and concurrency columns include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER, and SECURITY_GROUP_ID. The CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 flexfield columns provide extensibility.

Common Use Cases and Queries

Common reporting scenarios include retrieving installation details for a given order line, tracing which customer products are pending installation, and reconciling RMA return dates against expected installation dates. A representative query joining to order lines and customer products follows:

• SELECT l.LINE_INST_DETAIL_ID, l.ORDER_LINE_ID, l.CUSTOMER_PRODUCT_ID, l.EXPECTED_INSTALLATION_DATE FROM CS_LINE_INST_DETAILS l WHERE l.ORDER_LINE_ID = :order_line_id;
• Joining to OE_ORDER_LINES_ALL on ORDER_LINE_ID retrieves order header and line context for installation records.
• Joining to CS_CUSTOMER_PRODUCTS_ALL on CUSTOMER_PRODUCT_ID resolves the installed base instance corresponding to the order line.
• Filtering on INSTALLED_AT_PARTY_SITE_ID supports site-level installation reporting.
• Tracing derivation via SOURCE_LINE_INST_DETAIL_ID supports audit of copied or migrated installation records.

Related Objects

The most significant related objects, based on documented foreign key relationships, are:

• OE_ORDER_LINES_ALL — referenced through ORDER_LINE_ID, INSTALLED_CP_RMA_LINE_ID, and NEW_CP_RMA_LINE_ID.
• ASO_SHIPMENTS — referenced through QUOTE_LINE_SHIPMENT_ID for quote-driven installations.
• CS_CUSTOMER_PRODUCTS_ALL — referenced through CUSTOMER_PRODUCT_ID; also references this table via ORIGINAL_LINE_SERV_DETAIL_ID.
• CS_CP_REVISIONS — references this table through LINE_SERVICE_DETAIL_ID.
• CS_SYSTEMS_ALL_B — referenced through SYSTEM_ID.
• CS_TRANSACTION_TYPES_B — referenced through TRANSACTION_TYPE_ID.
• HZ_PARTY_SITES — referenced through INSTALLED_AT_PARTY_SITE_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID.