Results for “cost_code_type”

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

Overview

BOMBV_MFG_DEPARTMENT_RESOURCES is an APPS-owned read-only view in the Oracle E-Bills of Material (BOM) module, documented in ETRM as "Retrofitted". It presents a denormalized, reporting-friendly projection of the intersection between manufacturing departments and the resources assigned to them, enriched with organization, resource, and ATP context. In Oracle EBS 12.1.1 and 12.2.2 the view serves as a single query point for capacity and department-resource reporting without requiring joins across five base tables. The user search term capacity_units maps directly to the view's CAPACITY_UNITS column, which is sourced from BOM_DEPARTMENT_RESOURCES and expresses the number of capacity units a resource contributes within a given department-resource assignment.

Underlying Base Objects

The view text joins five base objects, each referenced through APPS synonyms:

• BOM_DEPARTMENT_RESOURCES — the driving assignment table providing CAPACITY_UNITS, RESOURCE_GROUP_NAME, EXCEPTION_SET_NAME, SHARE_FROM_DEPT_ID, flags, and keys.
• BOM_DEPARTMENTS — supplies DEPARTMENT_CODE and the DEPARTMENT_ID join key.
• BOM_RESOURCES — supplies RESOURCE_CODE and COST_CODE_TYPE via RESOURCE_ID.
• MTL_PARAMETERS — supplies ORGANIZATION_CODE and links resources to inventory organizations.
• HR_ALL_ORGANIZATION_UNITS — supplies the ORGANIZATION_NAME for the operating unit or inventory organization.

Joins are constrained by ORGANIZATION_ID equality (BOM_RESOURCES, MTL_PARAMETERS, HR_ALL_ORGANIZATION_UNITS) and by DEPARTMENT_ID and RESOURCE_ID (BOM_DEPARTMENT_RESOURCES to BOM_DEPARTMENTS and BOM_RESOURCES). The WHERE clause includes a security predicate ('_SEC:DE.ORGANIZATION_ID' IS NOT NULL), enforcing organization-level access, and the view is declared WITH READ ONLY.

Key Columns

• CAPACITY_UNITS — the capacity unit value for the department-resource assignment, central to capacity planning and the basis for the user's search.
• DEPARTMENT_CODE / RESOURCE_CODE — business-facing identifiers for the department and the resource.
• ORGANIZATION_CODE / ORGANIZATION_NAME — the inventory organization code and HR organization name.
• COST_CODE_TYPE — the cost code type classification of the resource.
• RESOURCE_GROUP_NAME — the resource group to which the resource belongs.
• Flag columns (AVAILABLE_24_HOURS_FLAG, SHARE_CAPACITY_FLAG, CTP_FLAG) — presented as descriptive "_LA:" lookups against MFG_LOOKUPS (SYS_YES_NO) to render MEANING values.
• EXCEPTION_SET_NAME, SHARE_FROM_DEPT_ID — sharing and exception configuration.
• DEPARTMENT_ID, RESOURCE_ID, ATP_RULE_ID — surrogate keys enabling further joins.
• Audit columns — UPDATED_ON, UPDATED_BY, CREATED_ON, CREATED_BY derived from LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical uses include capacity analysis by department and resource, resource-sharing audits, and custom reports or integrations that require department-resource capacity without embedding multi-table joins. A common query filters by organization and resource code:

• List capacity units for a department: SELECT DEPARTMENT_CODE, RESOURCE_CODE, CAPACITY_UNITS FROM BOMBV_MFG_DEPARTMENT_RESOURCES WHERE DEPARTMENT_CODE = :dept;
• Summarize capacity by organization: SELECT ORGANIZATION_CODE, SUM(CAPACITY_UNITS) FROM BOMBV_MFG_DEPARTMENT_RESOURCES GROUP BY ORGANIZATION_CODE;

Because the view is READ ONLY and carries an organization security predicate, it is safe for query-only reporting and conforms to EBS data-access restrictions.