Results for “mnt_cost_element”

6 results




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

Overview

The CST_CAT_ELE_EXP_ASSOCS_V view is an APPS-owned database view within the Oracle E-Business Suite (EBS) Bills of Material (BOM) product family. It presents the denormalized contents of the Category Associations entity, joining cost-element and expenditure-type reference data so that the "Category Associations" form — and any reporting or integration layer that depends on it — can retrieve human-readable descriptions alongside raw identifier columns. In the context of releases 12.1.1 and 12.2.2, the view is documented as VALID and is registered against the APPS schema. The view is particularly relevant to searches for mfg_cost_element_id, because that column is exposed directly and represents the manufacturing cost element associated with a given category.

The primary purpose of the view is to associate an inventory category with both a maintenance (EAM) cost element and a manufacturing cost element, and to tie that association to an expenditure type. This supports cost rollup, transaction costing, and expenditure recognition logic in Cost Management and related modules.

Underlying Base Objects

The view is defined over five documented base objects:

  • CST_CAT_ELE_EXP_ASSOCS (synonym) — the driving table holding the stored category-to-cost-element-to-expenditure-type associations, including the start and end dates.
  • MTL_CATEGORIES_B_KFV (view) — the key flexfield view supplying the concatenated category segment string (CATEGORY_CONCAT_SEGMENTS).
  • CST_COST_ELEMENTS (synonym) — the cost element reference table supplying the manufacturing cost element description.
  • CST_EAM_COST_ELEMENTS (synonym) — the EAM cost element reference table supplying the maintenance cost element description.
  • PA_EXPENDITURE_TYPES (synonym) — the expenditure type reference table.

The join conditions link CCEEA.CATEGORY_ID = MCK.CATEGORY_ID, CCEEA.MNT_COST_ELEMENT_ID = CECE.EAM_COST_ELEMENT_ID, CCEEA.MFG_COST_ELEMENT_ID = CCE.COST_ELEMENT_ID, and CCEEA.EXPENDITURE_TYPE_ID = PET.EXPENDITURE_TYPE_ID(+). The outer-join symbol on the expenditure type join indicates that the expenditure type is optional and a category association can exist without one.

Key Columns

  • CATEGORY_ID — identifier of the inventory category driving the association.
  • CATEGORY_CONCAT_SEGMENTS — the concatenated flexfield segments representing the category, sourced from MTL_CATEGORIES_B_KFV.
  • MNT_COST_ELEMENT_ID / MNT_COST_ELEMENT — the EAM (maintenance) cost element identifier and its descriptive name.
  • MFG_COST_ELEMENT_ID / MFG_COST_ELEMENT — the manufacturing cost element identifier and its descriptive name; the column central to mfg_cost_element_id searches.
  • START_DATE / END_DATE — the effective date range during which the association is valid.
  • EXPENDITURE_TYPE / EXPENDITURE_TYPE_ID — the expenditure type description and its identifier, optionally populated through the outer join.

Common Use Cases and Queries

Typical uses include cost-element reporting, category costing configuration review, and interfaces that need to resolve which manufacturing cost element is bound to a category and expenditure type.

SELECT category_id,
       category_concat_segments,
       mfg_cost_element_id,
       mfg_cost_element,
       mnt_cost_element,
       expenditure_type,
       start_date,
       end_date
FROM   cst_cat_ele_exp_assocs_v
WHERE  mfg_cost_element_id = :p_mfg_cost_element_id
AND    TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);

Analysts can also join the view to MTL_CATEGORIES_KFV for unrestricted category reporting, or filter on expenditure_type when reconciling expenditure recognition rules. Because the expenditure type is outer-joined, reports should account for NULL expenditure_type_id values.