Results for “cstfv_le_cost_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CSTFV_LE_COST_TYPES view is a read-only reporting object owned by the APPS schema in Oracle E-Business Suite, associated with the Bills of Material (BOM) product family and the Cost Management (CST) subsystem. In the 12.1.1 and 12.2.2 releases, it exposes the effective assignment of cost types to legal entities and ledgers, providing a denormalized, human-readable projection of the underlying configuration captured in CST_LE_COST_TYPES.

The view answers the practical question of "which cost types are enabled for a legal entity, and which one drives PAC (Period Average Cost) rates?" It resolves the internal key columns into descriptive names by joining the primary cost type to CST_COST_TYPES and, separately, the PAC rates cost type to the same table via an aliased join. It also resolves the legal entity name through XLE_FIRSTPARTY_INFORMATION_V and the ledger name through GL_SETS_OF_BOOKS. Because it is defined WITH READ ONLY, the view cannot be used as a DML target.

In reporting and integration terms, the view is the natural source for validating cost type configuration across legal entities without writing multi-table joins against the base tables.

Underlying Base Objects

The view is defined over four documented base objects:

• CST_LE_COST_TYPES (SYNONYM) — the driving table holding the legal entity to cost type assignments, including PAC_RATES_COST_TYPE_ID, PRIMARY_COST_METHOD, and set of books.
• CST_COST_TYPES (SYNONYM) — referenced twice (aliases CCT and CCT1) to resolve the primary cost type name and the PAC rates cost type name respectively.
• GL_SETS_OF_BOOKS (VIEW) — supplies the ledger name via SET_OF_BOOKS_ID.
• XLE_FIRSTPARTY_INFORMATION_V (VIEW) — supplies the legal entity name via LEGAL_ENTITY_ID.

The join keys are XFI.LEGAL_ENTITY_ID = CLCT.LEGAL_ENTITY, GSOB.SET_OF_BOOKS_ID = CLCT.SET_OF_BOOKS_ID, CCT.COST_TYPE_ID = CLCT.COST_TYPE_ID, and CCT1.COST_TYPE_ID = CLCT.PAC_RATES_COST_TYPE_ID.

Key Columns

• LEGAL_ENTITY / LEGAL_ENTITY_NAME — legal entity identifier and resolved name.
• COST_TYPE_ID / COST_TYPE_NAME — the primary cost type and its descriptive name.
• PAC_RATES_COST_TYPE_ID / PAC_RATES_COST_TYPE_NAME — the cost type designated as the source of PAC rates, plus its name. This is the intersection with the user's search term.
• LEDGER_ID / LEDGER_NAME — the ledger (set of books) associated with the assignment.
• PRIMARY_COST_METHOD_ID / "_LA:PRIMARY_COST_METHOD_NAME" — the primary cost method, with a lookup-resolved meaning exposed as a quoted alias.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which cost types serve as PAC rates sources per legal entity, validating setup prior to period close, and feeding downstream reporting extracts.

Locate the PAC rates cost type for a legal entity:

SELECT legal_entity_name, cost_type_name,
       pac_rates_cost_type_id, pac_rates_cost_type_name,
       ledger_name
  FROM cstfv_le_cost_types
 WHERE legal_entity = :legal_entity_id;

Resolve a known PAC rates cost type ID back to its entity and ledger:

SELECT legal_entity_name, ledger_name,
       cost_type_name, pac_rates_cost_type_name
  FROM cstfv_le_cost_types
 WHERE pac_rates_cost_type_id = :pac_rates_cost_type_id;

List all assignments for reporting:

SELECT legal_entity_name, ledger_name,
       cost_type_name, pac_rates_cost_type_name, last_update_date
  FROM cstfv_le_cost_types
 ORDER BY legal_entity_name, ledger_name;

Because the view is read-only, all maintenance must be performed on CST_LE_COST_TYPES directly.