Results for “bombv_mfg_department_classes”

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

Overview

BOMBV_MFG_DEPARTMENT_CLASSES is a read-only Oracle EBS view owned by the APPS schema within the Bills of Material (BOM) product family. It presents manufacturing department class definitions in a denormalized, user-friendly format by joining the department class entity to organization and inventory parameter information. The "BV" naming convention identifies it as a business view, indicating that it is intended for reporting, inquiry, and integration consumption rather than for transactional updates. The view is marked VALID in ETRM and is described as "Retrofitted," meaning it was created or migrated to preserve a legacy business view interface across releases, including 12.1.1 and 12.2.2.

The primary purpose of the view is to expose the department_class_code — the attribute users most frequently search for — alongside the organization context in which the class is defined, thereby avoiding the need for ad-hoc multi-table joins in custom reports and extracts.

Underlying Base Objects

The view is defined over three documented base objects, each accessed through an APPS synonym:

• BOM_DEPARTMENT_CLASSES (CL) — the driving table. Supplies DEPARTMENT_CLASS_CODE, DESCRIPTION, ORGANIZATION_ID, and the audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY).
• HR_ALL_ORGANIZATION_UNITS (AL) — provides the organization NAME and is joined on ORGANIZATION_ID.
• MTL_PARAMETERS (PA) — supplies the ORGANIZATION_CODE and is also joined on ORGANIZATION_ID.

The join condition is a three-way equi-join on ORGANIZATION_ID across all three objects, ensuring that only classes with a valid inventory organization context are returned. The view text includes the predicate '_SEC:CL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY, a standard EBS security construct that applies organization-level access control (MOAC/security profile) and enforces read-only semantics.

Key Columns

• DEPARTMENT_CLASS_CODE — the unique identifier of the department class within an organization; the principal lookup attribute.
• ORGANIZATION_CODE — the inventory organization code from MTL_PARAMETERS, used to qualify the class by operating unit/organization.
• ORGANIZATION_NAME — the descriptive organization name from HR_ALL_ORGANIZATION_UNITS.
• DESCRIPTION — free-text description of the department class.
• ORGANIZATION_ID — the internal organization identifier linking the class to its owning organization.
• UPDATED_ON / UPDATED_BY — audit timestamps and user identifiers sourced from LAST_UPDATE_DATE and LAST_UPDATED_BY.
• CREATED_ON / CREATED_BY — creation audit information.

Common Use Cases and Queries

Typical uses include validating department class setup by organization, feeding downstream WIP or routing logic that references class codes, and driving reports that require both the code and the organization name.

To retrieve all classes for a given organization code:

• SELECT department_class_code, description, organization_name FROM apps.bombv_mfg_department_classes WHERE organization_code = :org_code;
• SELECT department_class_code, organization_id, updated_on FROM apps.bombv_mfg_department_classes WHERE department_class_code LIKE :pattern;

Because the view enforces the organization security predicate and read-only mode, queries automatically respect the session's organization access and cannot be used to modify data.