Results for “bomfv_bill_of_materials”

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

Overview

The APPS.BOMFV_BILL_OF_MATERIALS view is a Bills of Material (BOM) reporting view shipped in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes bill of materials header records combined with descriptive attributes drawn from organization, item, project, and task master data, resolving the raw identifiers held on BOM_BILL_OF_MATERIALS into user-facing codes and names. The view is documented in ETRM as VALID, owned by APPS, and carries the note "Retrofitted," indicating it was reconstructed from an earlier form (typically an 11i-style view) for continued compatibility following the multi-org and TCA changes introduced in Release 12.

A defining characteristic of the view is its support for "common" bill structures. Two independent organization contexts are exposed: the owning/primary organization of the bill (ORGANIZATION_CODE, ORGANIZATION_NAME) and a common organization context (COMMON_ORGANIZATION_CODE, COMMON_ORGANIZATION_NAME) that references the common assembly and common bill sequence. This design supports common bill of materials functionality, where a bill defined in one organization is shared by or referenced from other organizations. The view is READ ONLY and is intended for query and reporting rather than maintenance.

Underlying Base Objects

The view is defined over a set of documented base objects:

• BOM_BILL_OF_MATERIALS (aliased BI1, with a self-join alias BI2) — the driving table supplying bill header attributes such as assembly item, organization, alternate designator, ECN, and the common assembly/sequence references.
• HR_ALL_ORGANIZATION_UNITS (AL1, AL2) — supplies organization names; AL1 joins to the primary organization, AL2 to the common organization.
• MTL_PARAMETERS (PA1, PA2) — supplies organization codes for the primary and common organization contexts.
• MTL_SYSTEM_ITEMS (SY1, SY2) — supplies the assembly item definitions for the primary and common items.
• PA_PROJECTS_ALL (PR) and PA_TASKS (TA) — outer-joined to supply project and task names for project-referenced bills.
• FND_GLOBAL (package) — referenced as the source for session context, driving the multi-org security predicate.

The self-join to BOM_BILL_OF_MATERIALS (BI2) via COMMON_BILL_SEQUENCE_ID resolves the common bill header, while the common organization and item joins are outer joins, reflecting that the common context is optional.

Key Columns

• ALTERNATE_BOM_CODE — the alternate BOM designator of the primary bill.
• ORGANIZATION_CODE / ORGANIZATION_NAME — code and name of the bill's primary organization.
• COMMON_ORGANIZATION_CODE / COMMON_ORGANIZATION_NAME — code and name of the common organization referenced by the bill; these columns bear directly on searches for COMMON_ORGANIZATION_ID.
• DESCRIPTION — the specific assembly comment on the bill.
• PENDING_FROM_ECO — the pending engineering change order from which the bill derives.
• PROJECT_NAME / TASK_NAME — project and task associated with the bill, when applicable.
• Identifier columns — ASSEMBLY_ITEM_ID, ORGANIZATION_ID, BILL_SEQUENCE_ID, COMMON_ASSEMBLY_ITEM_ID, COMMON_BILL_SEQUENCE_ID, COMMON_ORGANIZATION_ID, PROJECT_ID, and TASK_ID expose the underlying keys, enabling joins back to base tables.
• Audit columns — CREATED_ON, CREATED_BY, UPDATED_ON, UPDATED_BY.

Common Use Cases and Queries

Because users frequently search for COMMON_ORGANIZATION_ID, this view is a natural reporting surface: it exposes that identifier alongside the corresponding common organization code and name, without requiring manual joins to MTL_PARAMETERS or HR_ALL_ORGANIZATION_UNITS.

• Common bill analysis — identify bills whose common organization is populated.
• Organization-level BOM reporting — list bills by owning organization.
• Project/task BOM listing — surface project-referenced bills.

Sample query:

• SELECT organization_code, assembly_item_id, alternate_bom_code, common_organization_code, pending_from_eco FROM apps.bomfv_bill_of_materials WHERE common_organization_code IS NOT NULL;
• SELECT * FROM apps.bomfv_bill_of_materials WHERE common_organization_code = 'M1' AND organization_code = 'M2';

Note that COMMON_ORGANIZATION_ID is returned as a key column, so it may also be filtered directly. As the view enforces a READ ONLY constraint and applies a security predicate on ORGANIZATION_ID, results are automatically scoped to organizations accessible to the current session.