Search Results cs_cost_details




Overview
Explore in AI Chat

Overview

The CS_COST_DETAILS table is a core transactional data object within the Oracle E-Business Suite Service (CS) module. It stores the granular cost records associated with service-related transactions, most notably incidents and estimates, and serves as the central repository where individual cost elements are captured, calculated, and ultimately prepared for financial interface. Each row represents a discrete cost line tied to a service activity, carrying quantities, unit and extended costs, currency and organizational context, and a flag indicating whether the record has been passed to Project Accounting.

The table resides in the CS schema and is owned by the Service product. Its primary key, CS_COST_DETAILS_PK, is defined on the COST_ID column. Based on the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a standalone entity — it does not function primarily as a hub, link, or satellite in a strict Data Vault sense, though its transactional nature and foreign key dependencies make it conceptually similar to a satellite capturing cost-event attributes around service reference data.

Key Information Stored

The table comprises 39 documented columns. The most significant include:

Common Use Cases and Queries

Typical usage centers on cost reporting, reconciliation, and the project accounting interface. Analysts query cost lines by incident or estimate to review total service costs, while integration processes select records where INTERFACED_TO_PA_FLAG is 'N' for transfer to Project Accounting.

A representative query joining cost details to their parent estimate:

  • SELECT c.COST_ID, c.ESTIMATE_DETAIL_ID, c.QUANTITY, c.EXTENDED_COST FROM CS_COST_DETAILS c WHERE c.ESTIMATE_DETAIL_ID = :detail_id
  • SELECT * FROM CS_COST_DETAILS WHERE INTERFACED_TO_PA_FLAG = 'N' AND ORG_ID = :org_id

Common reporting scenarios include cost-per-incident analysis, estimate versus actual cost comparison, and monitoring of unprocessed records pending financial interface.

Related Objects

The following objects are most significant in relation to CS_COST_DETAILS:

  • CS_ESTIMATE_DETAILS — referenced via CS_COST_DETAILS.ESTIMATE_DETAIL_ID; parent of each cost line.
  • CS_TXN_BILLING_TYPES — referenced via CS_COST_DETAILS.TXN_BILLING_TYPE_ID; defines billing classification.
  • CS_INCIDENTS — related through INCIDENT_ID; the service incident context.
  • MTL_SYSTEM_ITEMS_B — related through INVENTORY_ITEM_ID; item definitions.
  • Project Accounting interface tables — downstream consumers of records flagged for PA interface.