Results for “cost_element_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSTBV_COST_ELEMENTS is an Oracle EBS database view owned by the APPS schema and classified under the BOM — Bills of Material product family. The object is documented in ETRM 12.2.2 as a retrofitted view carrying a VALID status, and it is present in both the 12.1.1 and 12.2.2 releases. The view presents a denormalized projection of cost element definitions joined with their associated expenditure transfer types, exposing a single row per cost element for reporting, integration, and inquiry purposes.
In Oracle Cost Management, cost elements represent the fundamental building blocks of a cost structure — Material, Material Overhead, Resource, Outside Processing, and Overhead. The CSTBV_COST_ELEMENTS view consolidates the descriptive attributes of each cost element together with the In and Out expenditure type assignments used by the expenditure transfer process. Because the view is defined with a WITH READ ONLY constraint, it functions purely as a query surface and cannot be used as the target of DML. This design reinforces its intended role as a reporting and integration artifact rather than an operational data entry object.
Underlying Base Objects
The view is defined over two base objects, both accessed through APPS synonyms:
- CST_COST_ELEMENTS — the primary cost element definition table, supplying the cost element name, description, and surrogate identifier.
- CST_COST_ELEM_EXP_TYPES — the expenditure type mapping table, supplying the inbound and outbound expenditure type assignments for each cost element.
The join between the two objects is performed on COST_ELEMENT_ID. The view text demonstrates an inner join, meaning a cost element row is returned only when a matching expenditure type assignment exists in CST_COST_ELEM_EXP_TYPES. The view text also carries the UNIQUE ATTRIBUTES annotation on COST_ELEMENT_ID, confirming the intent to expose a single consolidated row per cost element.
Key Columns
The view exposes the following columns, several of which are aliased from the base tables during projection:
- COST_ELEMENT_ID — the surrogate primary key for the cost element; the unique attribute carried across from CST_COST_ELEMENTS.
- COST_ELEMENT_NAME — the display name of the cost element, projected from the CCE.COST_ELEMENT column.
- DESCRIPTION — the descriptive text associated with the cost element.
- EXPENDITURE_TRANSFER_IN_TYPE — the expenditure type used when costs are transferred into the cost element, projected from CCEET.EXPENDITURE_TYPE_IN.
- EXPENDITURE_TRANSFER_OUT_TYPE — the expenditure type used when costs are transferred out of the cost element, projected from CCEET.EXPENDITURE_TYPE_OUT.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — the standard WHO audit columns, retained from the CST_COST_ELEMENTS source.
Note the deliberate distinction between the base column COST_ELEMENT and the exposed column name COST_ELEMENT_NAME; queries written against the view must reference the exposed name.
Common Use Cases and Queries
Typical uses of this view include cost element listing reports, validation of expenditure transfer configuration ahead of period close, and integration extracts feeding downstream costing or analytics platforms. A representative query returning the full list of cost elements with their transfer types is shown below:
SELECT cost_element_id, cost_element_name, description, expenditure_transfer_in_type, expenditure_transfer_out_type FROM apps.cstbv_cost_elements ORDER BY cost_element_name;SELECT c.cost_element_name, c.expenditure_transfer_in_type FROM apps.cstbv_cost_elements c WHERE c.cost_element_name = 'Material';SELECT COUNT(*) FROM apps.cstbv_cost_elements;— used to reconcile the number of configured cost elements against expectations.
Because the view is read only, it is safe to grant SELECT access to reporting schemas and BI tools without risk of accidental modification. Queries should be qualified with the APPS schema prefix to avoid synonym resolution ambiguity, and callers should be aware that cost elements lacking a corresponding expenditure type mapping will not appear in the result set.
-
View: CSTBV_COST_ELEMENTS 12.2.2
- Retrofitted
APPS.CSTBV_COST_ELEMENTS·↳ CST_COST_ELEMENTS·↳ CST_COST_ELEM_EXP_TYPES·Explore BOM module →
-
View: CSTFV_COST_ELEMENTS 12.1.1
- Retrofitted
APPS.CSTFV_COST_ELEMENTS·↳ CST_COST_ELEMENTS·↳ CST_COST_ELEM_EXP_TYPES·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITM_STD_CST_UPD_ELM_HST·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_ELEMENTAL_COSTS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITM_STD_CST_UPD_ELM_HST·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_ELEMENTAL_COSTS·Explore BOM module →
-
View: CSTFV_COST_ELEMENTS 12.2.2
- Retrofitted
APPS.CSTFV_COST_ELEMENTS·↳ CST_COST_ELEMENTS·↳ CST_COST_ELEM_EXP_TYPES·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITM_STD_CST_UPD_ELM_HST·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_ELEMENTAL_COSTS·Explore BOM module →
-
View: CSTBV_COST_ELEMENTS 12.1.1
- Retrofitted
APPS.CSTBV_COST_ELEMENTS·↳ CST_COST_ELEMENTS·↳ CST_COST_ELEM_EXP_TYPES·Explore BOM module →
-
This shows the details of the cost of an item in a period and cost group. The costs are stored by element and level.
APPS.CSTBV_PAC_ITEM_COST_DETAILS·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_PAC_ITEM_COSTS·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_STD_COST_ADJ_VALUES·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITM_CST_GRP_UNT_CST_DTL·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_LAYER_COST_DETAILS·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITM_STD_CST_UPD_ELM_HST·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_ELEMENTAL_COSTS·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITM_CST_GRP_UNT_CST_DTL·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_LAYER_COST_DETAILS·Explore BOM module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.1.1
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
This shows the details of the cost of an item in a period and cost group. The costs are stored by element and level.
APPS.CSTBV_PAC_ITEM_COST_DETAILS·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_PAC_ITEM_COSTS·Explore BOM module →
-
Stores the cost details of an item in a period and cost group.
APPS.CSTFV_PAC_ITEM_COST_DETAILS·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_PAC_ITEM_COSTS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITM_CST_GRP_UNT_CST_DTL·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_LAYER_COST_DETAILS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITM_CST_GRP_UNT_CST_DTL·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_LAYER_COST_DETAILS·Explore BOM module →
-
View: OKL_AEL_SL_V 12.1.1
This view contains the accounting entries created for all the contract, asset and quote transactions. This view is used to enable sub-ledger accounting architecture to display the accounting entries for each Lease transaction.
APPS.OKL_AEL_SL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_JE_CATEGORIES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
APPS.XLA_PSA_REQ_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FA_AEL_GL_V 12.2.2
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_AP_STDIST_AEL_SL_V 12.2.2
APPS.JAI_AP_STDIST_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_AP_STDIST_AEL_V·Explore JA module →
-
View: JAI_INV_RG23_AEL_GL_V 12.2.2
APPS.JAI_INV_RG23_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_RG23_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_MTL_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_MTL_AEL_V·Explore JA module →
-
View: XLA_FV_PYA_GL_V 12.1.1
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
View: XLA_REQ_ENC_AEL_GL_V 12.1.1
APPS.XLA_REQ_ENC_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FV_PYA_GL_V 12.2.2
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
View: JAI_PO_OSPM_AEL_GL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
View: JAI_AP_MANUAL_AEL_GL_V 12.2.2
APPS.JAI_AP_MANUAL_AEL_GL_V·↳ FND_GLOBAL·↳ JAI_AP_MANUAL_AEL_V·Explore JA module →
-
View: XLA_FV_TC_GL_V 12.1.1
-
APPS.JAI_PO_REC_CENVAT_AEL_SL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_CENVAT_AEL_V·Explore JA module →
-
View: XLA_INV_AEL_GL_V 12.1.1
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.2.2
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_WIP_AEL_SL_V 12.1.1
APPS.XLA_WIP_AEL_SL_V·↳ CST_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_INV_AEL_GL_V 12.2.2
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
Stores the cost details of an item in a period and cost group.
APPS.CSTFV_PAC_ITEM_COST_DETAILS·↳ CST_COST_ELEMENTS·↳ CST_COST_GROUPS·↳ CST_PAC_ITEM_COSTS·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ·↳ CST_COST_ELEMENTS·↳ CST_COST_UPDATES·↳ CST_STD_COST_ADJ_VALUES·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITEM_UNIT_COST_DETAILS·↳ BOM_DEPARTMENTS·↳ BOM_OPERATION_SEQUENCES·↳ BOM_RESOURCES·Explore BOM module →
-
View: CST_PAC_AEL_GL_WIP_V 12.1.1
APPS.CST_PAC_AEL_GL_WIP_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·↳ CST_AE_HEADERS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_ITEM_UNIT_COST_DETAILS·↳ BOM_DEPARTMENTS·↳ BOM_OPERATION_SEQUENCES·↳ BOM_RESOURCES·Explore BOM module →
-
View: OKL_AEL_SL_V 12.2.2
This view contains the accounting entries created for all the contract, asset and quote transactions. This view is used to enable sub-ledger accounting architecture to display the accounting entries for each Lease transaction.
APPS.OKL_AEL_SL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_JE_CATEGORIES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: XLA_INV_AEL_SL_PAC_V 12.1.1
APPS.XLA_INV_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_INV_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_WIP_AEL_GL_PAC_V 12.2.2
APPS.XLA_WIP_AEL_GL_PAC_V·↳ CST_PAC_AEL_GL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_INV_AEL_GL_PAC_V 12.1.1
APPS.XLA_INV_AEL_GL_PAC_V·↳ CST_PAC_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_INV_AEL_SL_V 12.1.1
APPS.XLA_INV_AEL_SL_V·↳ CST_AEL_SL_INV_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PO_AEL_SL_PAC_V 12.1.1
APPS.XLA_PO_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_RCV_V·↳ FND_GLOBAL·↳ HR_GENERAL·Explore XLA module →
-
View: XLA_FA_AEL_SL_MRC_V 12.2.2
APPS.XLA_FA_AEL_SL_MRC_V·↳ FA_AEL_SL_MRC_V·Explore XLA module →
-
View: XLA_PO_AEL_SL_MRC_V 12.1.1
APPS.XLA_PO_AEL_SL_MRC_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_JL_FA_AEL_SL_V 12.1.1
APPS.XLA_JL_FA_AEL_SL_V·↳ JL_CO_FA_AEL_SL_V·Explore XLA module →
-
View: XLA_PSA_PO_ENC_BC_GL_V 12.2.2
APPS.XLA_PSA_PO_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →