Results for “absorption_account”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view CSTBV_RTNG_OVHD_CST_SUB_ELMNT is an APPS-owned database view in Oracle E-Business Suite, delivered under the Bills of Material (BOM) product family. Its name indicates that it exposes routing overhead cost sub-elements — specifically the resource-level attributes used to derive overhead cost components during cost rollup and standard costing. The metadata classifies the object as "Retrofitted," meaning it is a backward-compatibility construct preserved across release boundaries; the same definition is shipped for 12.1.1 and 12.2.2.
The view is a filtered, attribute-formatted projection of resource definitions rather than a stored table. Its purpose is to present cost element 5 (overhead) resource records together with the descriptive and accounting attributes required by forms, concurrent programs, and reporting layers that expect a stable, user-facing interface. Because it is created WITH READ ONLY, it functions purely as a query surface and cannot be used for DML.
Users searching for rate_variance_account are typically investigating where a resource's rate variance posting account is stored and how it is surfaced for costing and accounting derivation. This view is one of the standard presentation points for that attribute.
Underlying Base Objects
The view is defined over a single documented base object, referenced in the shipped metadata as the synonym BOM_RESOURCES in the APPS schema. In practice this synonym resolves to the BOM resources table that holds resource codes, expenditure types, absorption and variance accounts, and organization-level costing attributes. No joins to other tables are present in the view text; the definition performs only row filtering and column projection.
Two predicates govern the result set. The first is COST_ELEMENT_ID = 5, restricting output to resources belonging to the overhead cost element. The second is the security predicate '_SEC:BR.ORGANIZATION_ID' IS NOT NULL, which is substituted at runtime by the Multi-Org / security layer so that only resources within the operating units accessible to the current responsibility are visible. The final WITH READ ONLY clause enforces the non-updatable nature of the view.
Key Columns
- RESOURCE_ID — Primary identifier of the overhead resource.
- RESOURCE_CODE — User-visible code of the resource.
- DESCRIPTION — Descriptive text for the overhead resource.
- DISABLE_DATE — Date on which the resource becomes inactive.
- EXPENDITURE_TYPE — Expenditure classification associated with the resource.
- ORGANIZATION_ID — Owning organization; subject to the applied security predicate.
- DEFAULT_ACTIVITY_ID — Default activity assigned to the resource.
- "_LA:DEFAULT_BASIS_TYPE" — Label-substituted value list column resolving
DEFAULT_BASIS_TYPEthrough theCST_BASISlookup type via theMEANINGcolumn. - "_LA:COST_CODE_TYPE" — Label-substituted value list column resolving
COST_CODE_TYPEthrough theCST_COST_CODE_TYPElookup type. - ABSORPTION_ACCOUNT — Account used to absorb the overhead cost.
- RATE_VARIANCE_ACCOUNT — Account to which rate variances for the overhead resource are posted. This is the column relevant to users searching on this identifier.
- CREATED_DATE, CREATED_BY, UPDATED_DATE, UPDATED_BY — Who-column audit attributes, aliased from the underlying
CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE, andLAST_UPDATED_BY.
Common Use Cases and Queries
Typical usage includes verifying that overhead resources carry a valid rate variance account before a cost rollup, reconciling variance postings back to resource setup, and driving custom reports that join resource attributes to cost element or organization data.
- Locating resources with a missing or unexpected variance account prior to period close.
- Auditing absorption versus rate variance account assignment across organizations.
- Extracting overhead resource attributes for integration into external costing or analytics platforms.
- Validating multi-org visibility — confirming which organization's resources a given responsibility can query.
A representative query:
SELECT resource_id,
resource_code,
organization_id,
rate_variance_account,
absorption_account
FROM cstbv_rtng_ovhd_cst_sub_elmnt
WHERE rate_variance_account IS NOT NULL
AND (disable_date IS NULL OR disable_date > SYSDATE);
Because the view applies organization security and filters strictly on cost element 5, it returns only active overhead resources visible to the session, making it suitable as a lightweight validation source without directly referencing BOM_RESOURCES.
-
- Retrofitted
APPS.CSTBV_RTNG_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_MATL_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_RTNG_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ GL_CODE_COMBINATIONS·Explore BOM module →
-
View: WIP_DEPT_RESOURCES_V 12.1.1
Resources owned by a department
APPS.WIP_DEPT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
- Retrofitted
APPS.CSTFV_RTNG_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ GL_CODE_COMBINATIONS·Explore BOM module →
-
Equipment resource instances
APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
- Retrofitted
APPS.BOMBV_INTERNAL_MFG_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
- Retrofitted
APPS.BOMBV_OUTSIDE_OPRATN_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
View: BOMBV_MFG_RESOURCES 12.2.2
- Retrofitted
APPS.BOMBV_MFG_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
- Retrofitted
APPS.BOMFV_INTERNAL_MFG_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
Equipment resource instances
APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
- Retrofitted
APPS.CSTBV_RTNG_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·Explore BOM module →
-
- Retrofitted
APPS.CSTBV_MATL_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·Explore BOM module →
-
Resources, overheads, material cost codes, and material overheads
-
Resources, overheads, material cost codes, and material overheads
-
View: BOM_RESOURCES_V 12.2.2
Resources, overheads, material cost codes, and material overheads
APPS.BOM_RESOURCES_V·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore BOM module →
-
View: BOM_RESOURCES_VAL_V 12.1.1
View for resource list of values - only enabled records
APPS.BOM_RESOURCES_VAL_V·↳ BOM_RESOURCES·Explore BOM module →
-
View: BOM_RESOURCES_V 12.1.1
Resources, overheads, material cost codes, and material overheads
APPS.BOM_RESOURCES_V·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_MATL_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ GL_CODE_COMBINATIONS·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_MATL_OVHD_CST_SUB_ELMNT·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ GL_CODE_COMBINATIONS·Explore BOM module →
-
- Retrofitted
APPS.BOMBV_INTERNAL_MFG_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
View: BOMBV_MFG_RESOURCES 12.1.1
- Retrofitted
APPS.BOMBV_MFG_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
- Retrofitted
APPS.BOMBV_OUTSIDE_OPRATN_RESOURCES·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_PARAMETERS·Explore BOM module →
-
View: WIP_DEPT_RESOURCES_V 12.2.2
Resources owned by a department
APPS.WIP_DEPT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
- Retrofitted
APPS.BOMFV_INTERNAL_MFG_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
View: BOMFV_MFG_RESOURCES 12.1.1
- Retrofitted
APPS.BOMFV_MFG_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
View: BOMFV_MFG_RESOURCES 12.2.2
- Retrofitted
APPS.BOMFV_MFG_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
- Retrofitted
APPS.BOMFV_OUTSIDE_OPRATN_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
- Retrofitted
APPS.BOMFV_OUTSIDE_OPRATN_RESOURCES·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_COST_ELEMENTS·Explore BOM module →
-
Employee resource instances
APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
Employee resource instances
APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
View: BOM_RESOURCES_VAL_V 12.2.2
View for resource list of values - only enabled records
APPS.BOM_RESOURCES_VAL_V·↳ BOM_RESOURCES·Explore BOM module →
-
View: BOM_RESOURCES_ALL_V 12.2.2
View for resource list of values - all records
APPS.BOM_RESOURCES_ALL_V·↳ BOM_RESOURCES·Explore BOM module →
-
View: BOM_RESOURCES_ALL_V 12.1.1
View for resource list of values - all records
APPS.BOM_RESOURCES_ALL_V·↳ BOM_RESOURCES·Explore BOM module →
-
VIEW: BOM.BOM_RESOURCES# 12.2.2