Results for “routing_class_uom”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMD_ROUTING_CLASS_B is the routing class base table in the Oracle E-Business Suite Process Manufacturing Product Development (GMD) module. It serves as the master definition table for routing classes, which are organizational groupings used to categorize and classify routings in process manufacturing environments. A routing class provides a mechanism to group related routings together, typically by production type, product family, or operational category, allowing planners and production supervisors to filter, report on, and manage routings as logical sets rather than individual records.
The table resides in the GMD schema and is considered a core setup or reference object within the Process Manufacturing Product Development product. Its role is analogous to a lookup or classification entity: it holds the class definition and descriptive attributes, while transactional routing records in GMD_ROUTINGS_B reference it via a foreign key on ROUTING_CLASS. Within a Data Vault modeling context, the documented FK structure suggests a satellite-leaning classification, since GMD_ROUTING_CLASS_B primarily holds descriptive attributes (description, unit of measure, process loss) around a business key (ROUTING_CLASS) that is also referenced by dependent tables.
Key Information Stored
The primary key of GMD_ROUTING_CLASS_B is GMD_ROUTING_CLASS_B_PK, defined on the ROUTING_CLASS column. ROUTING_CLASS is therefore both the surrogate primary key and the business-key candidate, as it is the sole column in the unique index. Each row represents one routing class definition.
- ROUTING_CLASS — Unique identifier and primary key for the routing class. Referenced as a foreign key by GMD_ROUTINGS_B.ROUTING_CLASS.
- ROUTING_CLASS_DESC — Descriptive text for the routing class, used in list-of-values displays and reports.
- TEXT_CODE — Foreign key to FM_TEXT_HDR, linking the routing class to extended descriptive text stored in the common text header structure.
- UOM — Unit of measure associated with the routing class.
- ROUTING_CLASS_UOM — The routing-class-specific unit of measure attribute, distinct from the general UOM column.
- FIXED_PROCESS_LOSS — Fixed process loss percentage or quantity applied to routings within this class.
- TRANS_CNT — Transaction or change counter used for concurrency control and audit tracking.
- DELETE_MARK — Logical deletion flag; non-zero values indicate the record is marked for deletion.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture the standard Oracle EBS multi-user audit trail.
Common Use Cases and Queries
The most frequent use of GMD_ROUTING_CLASS_B is as a lookup source when reporting on or validating routing class assignments. Typical reporting joins GMD_ROUTING_CLASS_B to GMD_ROUTINGS_B to list all routings belonging to each class. A representative query pattern:
SELECT rc.routing_class, rc.routing_class_desc, rt.routing_id, rt.routing_name FROM gmd_routing_class_b rc, gmd_routings_b rt WHERE rt.routing_class = rc.routing_class AND NVL(rc.delete_mark, 0) = 0;
Another common scenario is generating a list of active routing classes for LOV validation or setup review, filtering on the DELETE_MARK flag. Extended descriptive text can be retrieved by joining TEXT_CODE to FM_TEXT_HDR. Planners may also use FIXED_PROCESS_LOSS and UOM attributes to review standard loss assumptions per class. Integration and conversion scripts frequently query this table to map legacy class codes to Oracle-defined routing classes.
Related Objects
- GMD_ROUTINGS_B — References GMD_ROUTING_CLASS_B via ROUTING_CLASS. Primary dependent table holding routing header records.
- FM_TEXT_HDR — Referenced by GMD_ROUTING_CLASS_B.TEXT_CODE; stores extended text translations for the description.
- GMD_ROUTING_CLASSES — Related routing class definition view or table in the GMD schema.
- GMD_ROUTING_CLASS_B_PK — Unique index enforcing the routing class primary key.
- GMD_ROUTING_HEADERS / GMD_ROUTING_STEPS — Downstream routing definition objects dependent on routing class groupings through GMD_ROUTINGS_B.
- FM_TEXT_TL — Text translation table joined to FM_TEXT_HDR to resolve TEXT_CODE descriptions in multiple languages.
These relationships make GMD_ROUTING_CLASS_B a foundational reference table for routing administration in Process Manufacturing Product Development.
-
Routing class base table - used to group routings.
-
View: GMD_ROUTING_CLASS_VL 12.2.2
View for Routing Class Base and translation tables
APPS.GMD_ROUTING_CLASS_VL·↳ GMD_ROUTING_CLASS_B·↳ GMD_ROUTING_CLASS_TL·Explore GMD module →
-
Routing class base table - used to group routings.
-
View: GMD_ROUTING_CLASS_VL 12.1.1
View for Routing Class Base and translation tables
APPS.GMD_ROUTING_CLASS_VL·↳ GMD_ROUTING_CLASS_B·↳ GMD_ROUTING_CLASS_TL·Explore GMD module →
-
PACKAGE: APPS.GMD_COMMON_VAL 12.1.1
-
PACKAGE: APPS.GMD_COMMON_VAL 12.2.2
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.