Search Results oe_order_lines_all




Overview
Explore in AI Chat

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.
  • Table: CS_LINE_INST_DETAILS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_LINE_INST_DETAILS,  object_name:CS_LINE_INST_DETAILS,  status:VALID,  product: CS - Service ,  description: Installation details of a product captured at the time of order or quote entry. ,  implementation_dba_data: CS.CS_LINE_INST_DETAILS , 

  • Table: CS_LINE_INST_DETAILS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_LINE_INST_DETAILS,  object_name:CS_LINE_INST_DETAILS,  status:VALID,  product: CS - Service ,  description: Installation details of a product captured at the time of order or quote entry. ,  implementation_dba_data: CS.CS_LINE_INST_DETAILS , 

  • View: CS_RETURNS_RG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_RETURNS_RG_V,  object_name:CS_RETURNS_RG_V,  status:VALID,  product: CS - Service ,  description: This View is a replica of the ASO object aso_returns_v ,  implementation_dba_data: APPS.CS_RETURNS_RG_V , 

  • View: CS_RETURNS_RG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_RETURNS_RG_V,  object_name:CS_RETURNS_RG_V,  status:VALID,  product: CS - Service ,  description: This View is a replica of the ASO object aso_returns_v ,  implementation_dba_data: APPS.CS_RETURNS_RG_V , 

  • View: CS_CP_REVISIONS_MAINT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CP_REVISIONS_MAINT_V,  object_name:CS_CP_REVISIONS_MAINT_V,  status:VALID,  product: CS - Service ,  description: Revision Details of a Product in InstalledBase ,  implementation_dba_data: APPS.CS_CP_REVISIONS_MAINT_V , 

  • View: CS_CP_REVISIONS_MAINT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CP_REVISIONS_MAINT_V,  object_name:CS_CP_REVISIONS_MAINT_V,  status:VALID,  product: CS - Service ,  description: Revision Details of a Product in InstalledBase ,  implementation_dba_data: APPS.CS_CP_REVISIONS_MAINT_V , 

  • View: CS_ACC_CP_RG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_ACC_CP_RG_V,  object_name:CS_ACC_CP_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve install base information. ,  implementation_dba_data: APPS.CS_ACC_CP_RG_V , 

  • View: CS_ACC_CP_RG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_ACC_CP_RG_V,  object_name:CS_ACC_CP_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve install base information. ,  implementation_dba_data: APPS.CS_ACC_CP_RG_V , 

  • View: CS_ACC_CP_RG_V_1155 12.1.1

    product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve install base information. ,  implementation_dba_data: Not implemented in this database , 

  • View: CS_ACC_CP_RG_V_1155 12.2.2

    product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve install base information. ,  implementation_dba_data: Not implemented in this database , 

  • View: CS_SR_FIND_PROD_MAINT_EAM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_PROD_MAINT_EAM_V,  object_name:CS_SR_FIND_PROD_MAINT_EAM_V,  status:VALID,  product: CS - Service ,  description: This view is used to bring eAM Assets in Find Product UI ,  implementation_dba_data: APPS.CS_SR_FIND_PROD_MAINT_EAM_V , 

  • View: CS_SR_FIND_PROD_MAINT_P_EAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_PROD_MAINT_P_EAM_V,  object_name:CS_SR_FIND_PROD_MAINT_P_EAM_V,  status:VALID,  product: CS - Service ,  description: This view is used to bring eAM Assests in Find Product UI ,  implementation_dba_data: APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V , 

  • View: CS_SR_FIND_PROD_MAINT_EAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_PROD_MAINT_EAM_V,  object_name:CS_SR_FIND_PROD_MAINT_EAM_V,  status:VALID,  product: CS - Service ,  description: This view is used to bring eAM Assets in Find Product UI ,  implementation_dba_data: APPS.CS_SR_FIND_PROD_MAINT_EAM_V , 

  • View: CS_SR_FIND_PROD_MAINT_P_EAM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_PROD_MAINT_P_EAM_V,  object_name:CS_SR_FIND_PROD_MAINT_P_EAM_V,  status:VALID,  product: CS - Service ,  description: This view is used to bring eAM Assests in Find Product UI ,  implementation_dba_data: APPS.CS_SR_FIND_PROD_MAINT_P_EAM_V , 

  • View: CS_SR_FIND_EAM_PROD_MAINT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_EAM_PROD_MAINT_V,  object_name:CS_SR_FIND_EAM_PROD_MAINT_V,  status:VALID,  product: CS - Service ,  description: This view is used to filter Instance related fields LOV in Search Installed Base UI. ,  implementation_dba_data: APPS.CS_SR_FIND_EAM_PROD_MAINT_V , 

  • View: CS_SR_NEW_ACC_CP_RG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_ACC_CP_RG_V,  object_name:CS_SR_NEW_ACC_CP_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve release 11.5.6 and higher, install base informationr . ,  implementation_dba_data: APPS.CS_SR_NEW_ACC_CP_RG_V , 

  • View: CS_SR_NEW_FIND_PROD_MAINT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_FIND_PROD_MAINT_V,  object_name:CS_SR_NEW_FIND_PROD_MAINT_V,  status:VALID,  product: CS - Service ,  description: This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticular account in Service request. This incorporates the 11.5.6 changes in Install base. ,  implementation_dba_data: APPS.CS_SR_NEW_FIND_PROD_MAINT_V , 

  • View: CS_SR_NEW_FIND_PROD_MAINT_P_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_FIND_PROD_MAINT_P_V,  object_name:CS_SR_NEW_FIND_PROD_MAINT_P_V,  status:VALID,  product: CS - Service ,  description: This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticular account in Service request. This incorporates the 11.5.6 changes in Install base. ,  implementation_dba_data: APPS.CS_SR_NEW_FIND_PROD_MAINT_P_V , 

  • View: CS_SR_NEW_FIND_PROD_MAINT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_FIND_PROD_MAINT_V,  object_name:CS_SR_NEW_FIND_PROD_MAINT_V,  status:VALID,  product: CS - Service ,  description: This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticular account in Service request. This incorporates the 11.5.6 changes in Install base. ,  implementation_dba_data: APPS.CS_SR_NEW_FIND_PROD_MAINT_V , 

  • View: CS_SR_NEW_FIND_PROD_MAINT_P_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_FIND_PROD_MAINT_P_V,  object_name:CS_SR_NEW_FIND_PROD_MAINT_P_V,  status:VALID,  product: CS - Service ,  description: This view contains the information about all products in the InstallBase. This view is using to get all product information for a perticular account in Service request. This incorporates the 11.5.6 changes in Install base. ,  implementation_dba_data: APPS.CS_SR_NEW_FIND_PROD_MAINT_P_V , 

  • View: CS_SR_NEW_ACC_CP_RG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_NEW_ACC_CP_RG_V,  object_name:CS_SR_NEW_ACC_CP_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used by the main service request form for a record group to retrieve release 11.5.6 and higher, install base informationr . ,  implementation_dba_data: APPS.CS_SR_NEW_ACC_CP_RG_V , 

  • View: CS_SR_FIND_EAM_PROD_MAINT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_FIND_EAM_PROD_MAINT_V,  object_name:CS_SR_FIND_EAM_PROD_MAINT_V,  status:VALID,  product: CS - Service ,  description: This view is used to filter Instance related fields LOV in Search Installed Base UI. ,  implementation_dba_data: APPS.CS_SR_FIND_EAM_PROD_MAINT_V , 

  • View: CS_SR_CP_NEW_ACCT_EAM_RG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_CP_NEW_ACCT_EAM_RG_V,  object_name:CS_SR_CP_NEW_ACCT_EAM_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used to filter the List of Values for the Product Related fields for eAM Service Requests. ,  implementation_dba_data: APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V , 

  • View: CS_SR_CP_NEW_ACCT_EAM_RG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_CP_NEW_ACCT_EAM_RG_V,  object_name:CS_SR_CP_NEW_ACCT_EAM_RG_V,  status:VALID,  product: CS - Service ,  description: This view is used to filter the List of Values for the Product Related fields for eAM Service Requests. ,  implementation_dba_data: APPS.CS_SR_CP_NEW_ACCT_EAM_RG_V , 

  • View: CS_CHARGE_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CHARGE_DETAILS_V,  object_name:CS_CHARGE_DETAILS_V,  status:VALID,  product: CS - Service ,  description: Charge Lines associated with Service request,depot repair and Field Service Report ,  implementation_dba_data: APPS.CS_CHARGE_DETAILS_V , 

  • View: CS_CHARGE_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_CHARGE_DETAILS_V,  object_name:CS_CHARGE_DETAILS_V,  status:VALID,  product: CS - Service ,  description: Charge Lines associated with Service request,depot repair and Field Service Report ,  implementation_dba_data: APPS.CS_CHARGE_DETAILS_V ,