Search Results installed_cp_order_number

Overview

The view CS_LINE_INST_DETAILS_V belongs to the Oracle E-Business Suite Service (CS) module and is available in releases 12.1.1 and 12.2.2. It presents installation detail information for products captured at the time of order or quote entry. Installation details describe the customer product instance associated with an order line or quote line shipment, including the installed-at party site, expected installation date, return-by dates, RMA references, and the active date range of the record. The view is intended for reporting and integration consumption rather than for direct DML, and it consolidates the transactional installation detail row with descriptive attributes drawn from systems, transaction types, inventory, order, and quote sources so that consumers do not have to perform manual joins across those objects.

The column SOURCE_LINE_INST_DETAIL_ID, which prompted the search for this object, is a self-referencing identifier. It links an installation detail row back to the installation detail row that originated it, supporting traceability of corrections, replacements, or re-created installation records within the same logical chain of custody.

Underlying Base Objects

The view is defined over the base table CS_LINE_INST_DETAILS, aliased as LID, which supplies the primary installation detail identifiers, foreign keys, dates, DFF attributes, and the OBJECT_VERSION_NUMBER used for optimistic locking. It is further joined to CS_SYSTEMS (SY) for the system name and CS_TRANSACTION_TYPES (TT) for the transaction type name. Inventory attributes, including reference number, serial number, inventory item identifier, product, and product description, are sourced through an inventory construct. Additional inline subqueries expose order and quote context: installed order/line data, new CP order/line data, and quote number with quote line number.

Documented view metadata lists no referenced base objects, and the excerpt notes that the object is "Not implemented in this database," meaning the definition may be supplied by a patch or product installation and should be verified against the target instance.

Key Columns

• LINE_INST_DETAIL_ID — Primary key of the installation detail record.
• ORDER_LINE_ID, QUOTE_LINE_SHIPMENT_ID — Order and quote shipment context for the detail.
• SOURCE_LINE_INST_DETAIL_ID — Self-referencing link to the originating installation detail row.
• TRANSACTION_TYPE_ID, TRANSACTION_TYPE — Transaction type identifier and its decoded name.
• SYSTEM_ID, SYSTEM_NAME — Owning system and its name.
• CUSTOMER_PRODUCT_ID, CUSTOMER_PRODUCT_TYPE_CODE, CUSTOMER_PRODUCT_QUANTITY — Customer product identity and quantity.
• INSTALLED_AT_PARTY_SITE_ID, EXPECTED_INSTALLATION_DATE — Installation destination and planned date.
• INSTALLED_CP_RETURN_BY_DATE, INSTALLED_CP_RMA_LINE_ID, NEW_CP_RMA_LINE_ID, NEW_CP_RETURN_BY_DATE — Return and RMA tracking attributes.
• START_DATE_ACTIVE, END_DATE_ACTIVE — Effective date range.
• REFERENCE_NUMBER, CURRENT_SERIAL_NUMBER, INVENTORY_ITEM_ID, PRODUCT, PRODUCT_DESCRIPTION — Inventory and item identity.
• NEW_CP_ORDER_NUMBER, NEW_CP_LINE_NUMBER, INSTALLED_CP_ORDER_NUMBER, INSTALLED_CP_LINE_NUMBER, QUOTE_NUMBER, QUOTE_LINE_NUMBER — Decoded order and quote references.
• ATTRIBUTE1 through ATTRIBUTE15, CONTEXT — Descriptive flexfield storage.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — Standard WHO audit and concurrency columns.

Common Use Cases and Queries

Typical usage includes installation detail reporting, tracing the origin chain of an installation record, and exposing installation data to downstream integrations. The query below traces the source lineage of installation details.

SELECT line_inst_detail_id, source_line_inst_detail_id, order_line_id,
  customer_product_id, expected_installation_date, current_serial_number
FROM cs_line_inst_details_v
WHERE source_line_inst_detail_id IS NOT NULL;

A second pattern reports active installation details by system and order context.

SELECT system_name, transaction_type, installed_cp_order_number,
  installed_cp_line_number, product, product_description,
  installed_at_party_site_id
FROM cs_line_inst_details_v
WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Quote-based installation detail can be isolated by filtering on QUOTE_NUMBER and QUOTE_LINE_NUMBER, while RMA-related activity is identified through the populated RMA line identifiers and return-by dates. Because the view joins multiple sources, filtering on indexed identifiers such as ORDER_LINE_ID or CUSTOMER_PRODUCT_ID is recommended for performance in high-volume environments.