Search Results updated_date




Overview
Explore in AI Chat

Overview

The view APPS.CSTBV_MATL_COST_SUB_ELEMENT is a Business Intelligence System (BIS) view registered in the Oracle E-Business Suite applications schema. It is classified as a VIEW object owned by APPS with a status of VALID, and it carries the FND Design Data reference BOM.CSTBV_MATL_COST_SUB_ELEMENT. As a BIS view, it is designed to expose cost subelement information in a flattened, reporting-friendly shape suitable for downstream analytics, extracts, and integration layers that read from the APPS schema rather than directly from the underlying cost and bill-of-material base tables.

The view presents information about material cost subelements. In Oracle EBS costing, a material subelement defines how a material component of a cost is valued — for example, which basis type and cost code type are applied, which expenditure type is associated, and which organization and default activity govern the record. Because these attributes are maintained on the resource definition, the view surfaces them per resource and per organization. It carries several standard Oracle who-columns (CREATED_DATE, CREATED_BY, UPDATED_DATE, UPDATED_BY) that support audit and incremental-change reporting.

Underlying Base Objects

The only documented base object referenced by this view is BOM_RESOURCES, accessed through a SYNONYM. No other database object is documented as a dependency, and the view itself is not referenced by any other database object. This means CSTBV_MATL_COST_SUB_ELEMENT is a leaf-level reporting view defined directly over the BOM resources table.

The relationship is therefore one-to-one at the row level with the qualifying resource rows in BOM_RESOURCES. In Oracle EBS, BOM_RESOURCES stores the resource definitions used across bills of material, routings, and costing, including material resources that carry the subelement and cost code configuration. The view projects a subset of those columns, adding label-friendly names and the BIS labeling convention described below. It does not aggregate or join additional tables; all projected attributes derive from the resource record itself.

Key Columns

  • RESOURCE_ID — Numeric primary identifier of the resource record; the key used to join back to BOM_RESOURCES.
  • RESOURCE_CODE — Character code (length 10) that uniquely identifies the resource to users.
  • DESCRIPTION — Descriptive text (length 240) for the resource or subelement.
  • DISABLE_DATE — Date on which the subelement becomes inactive; supports effective-dating and current-state reporting.
  • EXPENDITURE_TYPE — Expenditure type (length 30) associated with the material subelement.
  • _LA:DEFAULT_BASIS_TYPE — Label-assigned attribute indicating the default basis type for the subelement.
  • _LA:COST_CODE_TYPE — Label-assigned attribute indicating the cost code type applied.
  • ORGANIZATION_ID — Inventory/costing organization context for the record.
  • DEFAULT_ACTIVITY_ID — Identifier of the default activity associated with the resource.
  • CREATED_DATE, CREATED_BY, UPDATED_DATE, UPDATED_BY — Standard audit columns enabling change tracking and incremental extracts.

The _LA:-prefixed columns follow the BIS convention in which label-assigned attributes present a business-friendly name in place of the underlying flexfield or code column.

Common Use Cases and Queries

Typical use cases include cost setup reporting, subelement configuration audits, and integration extracts feeding cost simulation or third-party costing tools. Because the query text is fully documented, consumers can rely on the exact projection and filter by organization, active status, or last update.

Retrieve all active material subelements for an organization:

SELECT RESOURCE_ID, RESOURCE_CODE, DESCRIPTION,
       EXPENDITURE_TYPE, ORGANIZATION_ID
FROM   APPS.CSTBV_MATL_COST_SUB_ELEMENT
WHERE  ORGANIZATION_ID = :org_id
AND   (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);

Track records changed since a given date — a common pattern when the search term is updated_date:

SELECT RESOURCE_CODE, DESCRIPTION,
       UPDATED_DATE, UPDATED_BY
FROM   APPS.CSTBV_MATL_COST_SUB_ELEMENT
WHERE  UPDATED_DATE >= :since_date
ORDER  BY UPDATED_DATE DESC;

Combine audit and status filters for a full-enabled subelement inventory, or join RESOURCE_ID back to BOM_RESOURCES where additional base-table columns beyond the projected set are required.