Search Results expenditure_transfer_out_type




Overview
Explore in AI Chat

Overview

APPS.CSTFV_COST_ELEMENTS is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications schema. Its FND Design Data identifier is BOM.CSTFV_COST_ELEMENTS, and its status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. The view belongs to the Cost Management (CST) product family and is designed to expose the five seeded cost elements alongside their corresponding expenditure types. In this way it provides a single, conveniently denormalized source that links costing configuration to the expenditure transfer mechanism used by Oracle Purchasing and Payables.

Because the object is a view rather than a base table, it carries no storage of its own and is populated at query time from the underlying cost element and expenditure type assignments. Its BIS designation marks it as an object intended for reporting and analytical consumption, particularly for tools and external integrations that need a readable, stable projection of cost element configuration without navigating the full normalized schema.

Underlying Base Objects

The ETRM metadata records that APPS.CSTFV_COST_ELEMENTS references two base objects, both resolved through APPS synonyms:

No database object in the EBS schema is documented as referencing APPS.CSTFV_COST_ELEMENTS, confirming that it is a terminal, read-only reporting object with no dependent children. This makes it safe to query without affecting downstream compilation or dependency chains.

Key Columns

  • COST_ELEMENT_ID (NUMBER) — the unique identifier of the seeded cost element; the natural join key back to CST_COST_ELEMENTS.
  • COST_ELEMENT_NAME (VARCHAR2, 50) — the name of the cost element (for example, Material, Material Overhead, Resource, Overhead, and Outside Processing in a standard costing configuration).
  • DESCRIPTION (VARCHAR2, 240) — descriptive text for the cost element.
  • EXPENDITURE_TRANSFER_IN_TYPE (VARCHAR2, 30) — the expenditure type used when costs transfer into the cost element. This is the column most directly relevant to the search term "expenditure_transfer_in_type".
  • EXPENDITURE_TRANSFER_OUT_TYPE (VARCHAR2, 30) — the expenditure type applied when costs transfer out of the cost element.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard EBS audit columns maintained through the underlying base tables.

Common Use Cases and Queries

The view is typically used to audit or replicate the mapping between cost elements and the expenditure types that drive cost transfer processing. A common requirement is verifying which expenditure type is applied when a transaction flows into a given cost element, as part of cost accounting configuration review or data migration validation.

A straightforward query lists all seeded cost elements with both transfer types:

  • SELECT COST_ELEMENT_ID, COST_ELEMENT_NAME, EXPENDITURE_TRANSFER_IN_TYPE, EXPENDITURE_TRANSFER_OUT_TYPE FROM APPS.CSTFV_COST_ELEMENTS;

To isolate the inbound mapping for a specific element:

  • SELECT COST_ELEMENT_NAME, EXPENDITURE_TRANSFER_IN_TYPE FROM APPS.CSTFV_COST_ELEMENTS WHERE COST_ELEMENT_NAME = 'Material';

Because the view surfaces only the five seeded cost elements, result sets are small and predictable, making it suitable for reference lookups, extract feeds, and validation scripts that confirm expenditure type configuration prior to cost transfer or period close activities.