Search Results cs_estimate_details

Overview

The CS_ESTIMATE_DETAILS table is a core transaction table within the Oracle E-Business Suite Service (CS) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for storing detailed line-level information for service charges and estimates. Its primary role is to capture the financial and logistical details of chargeable items associated with service transactions, such as repairs, field service tasks, or service requests. This table is fundamental to the service estimation and billing processes, acting as a detailed child record to higher-level service transaction headers.

Key Information Stored

The table's structure is defined by its primary key, ESTIMATE_DETAIL_ID, which uniquely identifies each charge line. Its extensive foreign key relationships reveal the breadth of data it consolidates. Key columns and their purposes include transactional identifiers (INCIDENT_ID, SOURCE_ID), billing determinants (TXN_BILLING_TYPE_ID, PRICE_LIST_HEADER_ID), and product information (CUSTOMER_PRODUCT_ID). Crucially, it stores comprehensive customer and site data for invoicing and shipping, linking to the Trading Community Architecture (HZ) tables via columns like INVOICE_TO_ACCOUNT_ID, SHIP_TO_ORG_ID, BILL_TO_CONTACT_ID, and SHIP_TO_PARTY_ID. This design enables the table to hold a complete snapshot of the chargeable service line for financial and operational processing.

Common Use Cases and Queries

This table is central to generating service estimates, invoices, and related operational reports. A common use case involves querying all estimated charges for a specific service incident to review a customer quote. Another is extracting detailed billing lines for integration with financial systems. Sample SQL patterns often involve joining to related service and customer tables.

• Finding Estimate Details for an Incident:
  SELECT ced.* FROM cs_estimate_details ced WHERE ced.incident_id = <incident_id> ORDER BY ced.estimate_detail_id;
• Joining with Customer and Product Information:
  SELECT ced.estimate_detail_id, hca.account_number, cpa.instance_number
  FROM cs_estimate_details ced, hz_cust_accounts hca, cs_customer_products_all cpa
  WHERE ced.invoice_to_account_id = hca.cust_account_id
  AND ced.customer_product_id = cpa.customer_product_id(+);

Related Objects

CS_ESTIMATE_DETAILS has a dense network of relationships, as indicated by its foreign keys. Key related objects include:

• Parent/Dependency Tables: CS_INCIDENTS_ALL_B (service request), CS_TXN_BILLING_TYPES, QP_LIST_HEADERS_B (pricing), HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_PARTY_SITES (customer data), CS_CUSTOMER_PRODUCTS_ALL, and CSD_REPAIRS.
• Child/Referencing Tables: The table is a key parent to several Service Depot (CSD) transaction lines, including CSD_REPAIR_ESTIMATE_LINES, CSD_REPAIR_ACTUAL_LINES, and CSD_PRODUCT_TRANSACTIONS, which link actual repair work to the original estimate. It is also referenced by CSF_DEBRIEF_LINES in Field Service.

This interconnectedness underscores its critical position as the linchpin between service execution, estimation, and financial charging.