Search Results cr_rsrc_mst_b




Overview
Explore in AI Chat

Overview

The CR_RSRC_MST_B table is the core master data table for defining resources within the Process Manufacturing Process Planning (GMP) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the foundational repository for all resource entities, which represent the equipment, labor, utilities, and other assets required to execute manufacturing and process operations. This table is central to planning, costing, and scheduling activities, as resources are key components in defining recipes, routings, and production batches. Its integrity is enforced by a primary key constraint (CR_RSRC_MST_B_PK) and it is extensively referenced by numerous transactional and setup tables across the GMP and related Cost Management (CM) modules.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and table description indicate the table stores essential attributes for each resource. Based on standard EBS GMP data model patterns, key columns typically include a unique RESOURCE_CODE and RESOURCE_ID, a RESOURCE_CLASS linking to CR_RSRC_CLS_B for categorization (e.g., equipment, labor), and a DESCRIPTION. It also holds critical costing information, such as a COST_CMPNTCLS_ID linking to CM_CMPT_MST_B to define the cost component class for the resource. A TEXT_CODE column links to CR_TEXT_HDR for storing extensive descriptive notes. Other common attributes define the resource's unit of measure, status, and various control flags for planning and scheduling.

Common Use Cases and Queries

This table is primarily accessed for master data maintenance, operational reporting, and integration with costing and production execution. Common scenarios include generating lists of active resources for a specific class, analyzing resource costs, and troubleshooting data issues in dependent modules. Sample query patterns include fetching resource details with their class description and cost component linkage, and identifying resources used in specific process plans.

  • Basic Resource Listing: SELECT resource_code, description, resource_class FROM gmp.cr_rsrc_mst_b WHERE enabled_flag = 'Y' ORDER BY 1;
  • Resource Details with Costing Info: SELECT r.resource_code, r.description, c.cost_cmpntcls_code, cls.resource_class FROM gmp.cr_rsrc_mst_b r, cm_cmpt_mst_b c, cr_rsrc_cls_b cls WHERE r.cost_cmpntcls_id = c.cost_cmpntcls_id AND r.resource_class = cls.resource_class;
  • Identifying Unused Resources: Queries checking for the absence of records in key child tables like CR_RSRC_DTL or CM_RSRC_DTL can help in data cleansing efforts.

Related Objects

The CR_RSRC_MST_B table has a wide network of dependencies, as shown in the foreign key metadata. Key related objects include:

  • Parent/Reference Tables: CR_RSRC_CLS_B (Resource Class), CM_CMPT_MST_B (Cost Component Class), CR_TEXT_HDR (Descriptive Text).
  • Primary Child Tables: CR_RSRC_DTL (for assigning resources to process plans), CM_RSRC_DTL and CM_BRDN_DTL (for resource costing and burden details), CM_SCST_LED (for standard cost ledgers).
  • Association Tables: CR_ARES_MST and FM_ARES_MST (for defining alternate resources in GMP and Formula Management).
  • Setup Tables: GMP_RESOURCE_PARAMETERS (for extended resource parameters), GL_ACCT_MAP (for general ledger accounting mapping).