Search Results resource_rate




Overview
Explore in AI Chat

Overview

The CSTBV_MFG_RESOURCE_COSTS view is a read-only database object owned by the APPS schema in Oracle E-Business Suite, classified under the BOM - Bills of Material product family. Its ETRM documentation designates it as "Retrofitted," indicating that the view was introduced or re-created to preserve backward compatibility with earlier EBS releases, including 12.1.1 and 12.2.2. Functionally, the view presents manufacturing resource cost information by joining cost type definitions, bill of material resource definitions, and resource cost records. It exposes the resource rate associated with a given resource, cost type, and organization, which makes it a convenient reporting surface for cost rollups, manufacturing overhead analysis, and rate verification. Because the view is defined WITH READ ONLY, it cannot be used for DML; its role is strictly to present a consolidated, denormalized projection of costing data to reports, interfaces, and integration layers that expect the legacy column list. This is significant in upgrade scenarios, where custom reports written against the older object continue to function without modification.

Underlying Base Objects

The view is defined over three base objects, each referenced through a synonym in the APPS schema:

The join predicates are CRC.COST_TYPE_ID = CCT.COST_TYPE_ID and CRC.RESOURCE_ID = BR.RESOURCE_ID. A notable predicate, '_SEC:CRC.ORGANIZATION_ID' IS NOT NULL, reflects the EBS security/partitioning convention applied to the organization context, effectively restricting results to rows where ORGANIZATION_ID is populated. All WHO columns originate from CST_RESOURCE_COSTS.

Key Columns

  • COST_TYPE_ID — Identifier of the cost type (e.g., Frozen, Average, Standard).
  • COST_TYPE_NAME — Descriptive name of the cost type from CST_COST_TYPES.
  • RESOURCE_ID — Identifier of the manufacturing resource.
  • RESOURCE_NAME — The resource code from BOM_RESOURCES, identifying the resource (e.g., labor or machine).
  • RESOURCE_RATE — The cost rate assigned to the resource for the cost type and organization; the central costing value surfaced by the view.
  • ORGANIZATION_ID — The inventory/operating organization to which the rate applies.
  • CREATED_BY, CREATION_DATE, UPDATED_BY, UPDATED_DATE — WHO audit columns inherited from CST_RESOURCE_COSTS, useful for change tracking and auditing.

Common Use Cases and Queries

The view is typically used in cost reporting, rate comparison across cost types, and validation of manufacturing resource rates prior to a cost rollup. A representative query returns resource rates for a specific organization and cost type:

  • Listing all resource rates for an organization: SELECT cost_type_name, resource_name, resource_rate FROM cstbv_mfg_resource_costs WHERE organization_id = :org_id ORDER BY cost_type_name, resource_name;
  • Comparing a resource's rate across cost types: SELECT cost_type_name, resource_rate FROM cstbv_mfg_resource_costs WHERE resource_id = :resource_id AND organization_id = :org_id;
  • Auditing recently changed rates: SELECT resource_name, resource_rate, last_update_date, last_updated_by FROM cstbv_mfg_resource_costs WHERE last_update_date > :cutoff_date;
  • Feeding external costing models: joining the view to BOM_DEPARTMENTS or routing data to reconcile resource rates against standard costs.

Because the view is read-only, all maintenance of resource rates must be performed against the underlying CST_RESOURCE_COSTS table through supported costing forms or APIs.