Search Results crp_bill_of_resource_items




Overview
Explore in AI Chat

Overview

The CRP_BILL_OF_RESOURCE_ITEMS table is a core data structure within the Oracle E-Business Suite (EBS) Capacity (CRP) module. It functions as a junction table that defines the specific inventory items associated with a Bill of Resources (BOR) set. A Bill of Resources is a critical planning construct used to model the resource requirements—such as labor, machines, and materials—needed to produce a specific item or assembly. This table, therefore, establishes the foundational link between an item master definition and its corresponding resource model, enabling the system to perform detailed capacity planning and rough-cut capacity checks for master production scheduling and material requirements planning.

Key Information Stored

The table's primary purpose is to store the unique combination of an item and a bill of resources within a specific manufacturing organization. Its structure is defined by a composite primary key, ensuring that each item is uniquely associated with a BOR set per organization. The key columns are INVENTORY_ITEM_ID, which references the master item from MTL_SYSTEM_ITEMS_B; BILL_OF_RESOURCES, which references the resource set definition from CRP_BILLS_OF_RESOURCES; and ORGANIZATION_ID, which identifies the inventory organization. This design enforces data integrity and supports the multi-org architecture of Oracle EBS. While the provided metadata focuses on these key identifiers, the table may also contain additional descriptive or control columns not detailed in the excerpt.

Common Use Cases and Queries

This table is central to queries that analyze or report on the resource planning setup for items. A common use case is identifying all items that utilize a specific Bill of Resources, which is essential for impact analysis when a resource model is changed. Conversely, it is used to retrieve the BOR assigned to a specific item for capacity simulation. For reporting, it is frequently joined with item master and BOR header tables to create user-friendly lists. A typical SQL pattern to list items and their associated BOR would be:

  • SELECT msib.segment1 item_code,
    msib.description,
    cbor.bill_of_resources_code,
    cbi.organization_id
    FROM crp_bill_of_resource_items cbi,
    mtl_system_items_b msib,
    crp_bills_of_resources cbor
    WHERE cbi.inventory_item_id = msib.inventory_item_id
    AND cbi.organization_id = msib.organization_id
    AND cbi.bill_of_resources = cbor.bill_of_resources
    AND cbi.organization_id = cbor.organization_id;

Related Objects

The CRP_BILL_OF_RESOURCE_ITEMS table maintains documented foreign key relationships with several other critical EBS tables, forming a key node in the capacity planning data model.

  • MTL_SYSTEM_ITEMS_B: Links the item definition. The join is on INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • CRP_BILLS_OF_RESOURCES: Links the header definition of the Bill of Resources set. The join is on BILL_OF_RESOURCES and ORGANIZATION_ID.
  • CRP_RESOURCE_HOURS: This table, which holds detailed resource hour requirements, references CRP_BILL_OF_RESOURCE_ITEMS. The foreign key is on the composite of ASSEMBLY_ITEM_ID, BILL_OF_RESOURCES, and ORGANIZATION_ID, establishing that resource hour details are defined for a specific item-BOR combination.