Results for “gr_labels_b”

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

Overview

GR_LABELS_B is the base table in the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite, holding the definition of regulatory label classes used to control how safety, toxicological, and physical-characteristic information is formatted and printed on regulatory documents such as Material Safety Data Sheets. Each row represents a distinct label code — for example a label named BOILING — that determines whether and where a particular data element appears on the output document, including font, size, positioning, and inheritance behaviour. The table is owned by the GR schema and is marked VALID in the 12.1.1 and 12.2.2 ETRM data dictionaries, with 52 documented columns in the 12.2.2 physical schema.

From a Data Vault modelling perspective, the heuristic classification supplied for this object is hub-leaning. GR_LABELS_B therefore behaves principally as a business-key hub: its primary key, the single column LABEL_CODE, is the durable business identifier around which satellite and link structures (GR_LABELS_TL, GR_LABEL_PROPERTIES, GR_LABEL_PROD_CLASSES and the various item and country profile tables) are organised. This classification is a modelling suggestion rather than a stored attribute of the table.

Key Information Stored

The primary key of the table is the unique index GR_LABELS_B_PK, defined on the LABEL_CODE column. LABEL_CODE is consequently both the surrogate row identifier and the business-key candidate — the single natural key that every dependent relationship resolves against. Other significant columns include:

• LABEL_CLASS_CODE — foreign key to GR_LABEL_CLASSES_B, grouping individual labels into label classes.
• SAFETY_CATEGORY_CODE — foreign key to GR_SAFETY_CATEGORIES_B, tying the label to a safety category.
• LABEL_PROPERTIES_FLAG, ITEM_PROPERTIES_FLAG, INGREDIENT_VALUE_FLAG — indicators governing which classes of property data the label draws upon.
• DATA_POSITION_INDICATOR, PRINT_FONT, PRINT_SIZE — control where and how the label text is rendered on the printed document, including typographic formatting.
• INHERIT_FROM_LABEL_CODE, INGREDIENT_LABEL_CODE, VALUE_PROCEDURE — define label inheritance, the ingredient-level label to use, and the procedure that supplies the label value.
• LABEL_VALUE_REQUIRED, ROLLUP_DISCLOSURE_CODE, TECH_PARM — flag whether a value must exist, the roll-up disclosure treatment, and technical parameters.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard EBS descriptive flexfield columns for customer-defined extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include extracting the full label catalogue for a regulatory document build, identifying labels that inherit from another label, and confirming which font and size are used for each label in a printed MSDS. A representative join against the label classes table follows:

SELECT l.LABEL_CODE, l.LABEL_CLASS_CODE, c.LABEL_CLASS_NAME, l.PRINT_FONT, l.PRINT_SIZE, l.LABEL_VALUE_REQUIRED
FROM GR.GR_LABELS_B l, GR.GR_LABEL_CLASSES_B c
WHERE l.LABEL_CLASS_CODE = c.LABEL_CLASS_CODE
AND l.INHERIT_FROM_LABEL_CODE IS NULL
ORDER BY l.LABEL_CLASS_CODE, l.LABEL_CODE;

Additional queries commonly resolve label translations through GR_LABELS_TL on LABEL_CODE, list labels assigned to product classes via GR_LABEL_PROD_CLASSES, or trace which document structures reference a given label through GR_DOCUMENT_STRUCTURES.

Related Objects

GR_LABELS_B participates in a dense foreign-key network. The most significant related objects are:

• GR_LABEL_CLASSES_B — referenced via GR_LABELS_B.LABEL_CLASS_CODE; the parent classification of each label.
• GR_SAFETY_CATEGORIES_B — referenced via GR_LABELS_B.SAFETY_CATEGORY_CODE.
• GR_LABELS_TL — the translation table for labels, joined on LABEL_CODE.
• GR_LABEL_PROPERTIES — properties associated with each label, joined on LABEL_CODE.
• GR_LABEL_PROD_CLASSES — product-class assignments for each label.
• GR_DOCUMENT_STRUCTURES — determines where labels appear on regulatory documents.
• GR_COUNTRY_PROFILES — references LABEL_CODE_EXPOSURE and LABEL_CODE_TOXIC.
• GR_ITEM_EXPOSURE and GR_ITEM_TOXIC — item-level exposure and toxicity assignments by label.
• GR_GENERIC_ML_NAME_TL and GR_MULTILINGUAL_NAME_TL — multilingual naming records resolved on LABEL_CODE.