Search Results cst_le_cost_types_v




Overview
Explore in AI Chat

Overview

CST_LE_COST_TYPES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite. It is associated with the BOM (Bills of Material) product family and is delivered as a VALID database object in both Release 12.1.1 and 12.2.2. The view presents the intersection of cost types with legal entities, sets of books, primary cost methods, and accounting library assignments, providing a denormalized, human-readable projection of the configuration rows stored in CST_LE_COST_TYPES.

Where the base table CST_LE_COST_TYPES stores numeric identifiers and foreign keys, CST_LE_COST_TYPES_V resolves those identifiers into descriptive names. Cost type identifiers and PAC (period average cost) cost type identifiers are resolved against CST_COST_TYPES, the primary cost method is resolved to a lookup meaning via MFG_LOOKUPS using the MTL_PRIMARY_COST lookup type, the set of books identifier is resolved to a short name through GL_SETS_OF_BOOKS, the legal entity identifier is resolved through XLE_FIRSTPARTY_INFORMATION_V, and the accounting library identifier is resolved through CST_ACCOUNTING_LIBRARIES. This makes the view the natural source for reports, concurrent program extracts, and integration interfaces that need cost type configuration in business terms rather than raw IDs.

Underlying Base Objects

The documented base objects referenced by the view are CST_ACCOUNTING_LIBRARIES (SYNONYM), CST_COST_TYPES (SYNONYM), CST_LE_COST_TYPES (SYNONYM), GL_SETS_OF_BOOKS (VIEW), MFG_LOOKUPS (VIEW), and XLE_FIRSTPARTY_INFORMATION_V (VIEW). CST_LE_COST_TYPES is the driving table, supplying the legal entity, cost type, set of books, primary cost method, PAC rates cost type, and the GL transfer and accounting library attributes.

CST_COST_TYPES is joined twice: once as CCT to resolve the primary COST_TYPE and its description, and again as CCT1 to resolve the PAC_RATES_COST_TYPE and PAC_RATES_COST_TYPE_DESC. GL_SETS_OF_BOOKS and XLE_FIRSTPARTY_INFORMATION_V supply the set of books short name and legal entity name respectively. MFG_LOOKUPS supplies the primary cost method meaning. CST_ACCOUNTING_LIBRARIES is outer-joined (via the ACCOUNTING_LIB_ID(+) syntax) so that rows without an assigned accounting library remain visible, returning a null accounting library name.

Key Columns

Common Use Cases and Queries

A frequent requirement is to list the cost types configured for a given legal entity together with their primary cost method and accounting library. The following query illustrates this pattern:

SELECT legal_entity_name, cost_type, cost_type_desc, primary_cost_method_name, set_of_books_name, accounting_library_name FROM cst_le_cost_types_v WHERE legal_entity_name = :p_legal_entity ORDER BY cost_type;

Another common scenario is identifying cost types that post to the General Ledger, or those lacking an accounting library assignment, which the outer join makes detectable through a null ACCOUNTING_LIBRARY_NAME.

Integration interfaces typically extract COST_TYPE_ID and COST_TYPE for a specified SET_OF_BOOKS_ID, using the view to avoid joins to lookup and ledger tables in the consuming application. Because the view exposes audit and concurrent program columns, it also supports change-tracking extracts that filter on LAST_UPDATE_DATE or PROGRAM_UPDATE_DATE.