Search Results gr_label_properties




Overview
Explore in AI Chat

Overview

The GR_LABEL_PROPERTIES table is a core data structure within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a configuration table that defines the permissible display properties for specific regulatory labels associated with items. In essence, it establishes the rules for how a particular piece of regulatory information, such as "Color" or "Boiling Point," can be captured and presented on a label. This table is fundamental for ensuring that item labeling complies with regulatory requirements by controlling the data entry format and validation rules for each label attribute.

Key Information Stored

The table's structure centers on linking a label to its applicable properties. Its primary key is a composite of three columns, indicating a unique relationship between them. The LABEL_CODE identifies the specific regulatory label (e.g., from GR_LABELS_B). The PROPERTY_ID references a valid display property (e.g., from GR_PROPERTIES_B), such as "Text," "Phrase Entry," "Low Range," "High Range," or "Temperature Scale." The SEQUENCE_NUMBER likely dictates the order in which these properties are applied or displayed for a given label. For example, a single label like "Boiling Point" can have multiple associated properties (text, low range, high range, scale), each stored as a separate record in this table.

Common Use Cases and Queries

This table is primarily accessed during the configuration of regulatory item data and the subsequent generation of compliant labels. A common operational query would retrieve all configurable properties for a specific label to populate a user interface for data entry. For instance, when an analyst defines regulatory data for a chemical item, the application would query this table to determine that the "Flash Point" label requires entries for a value and a temperature unit. A typical SQL pattern for such a lookup is:

  • SELECT lp.sequence_number, p.property_name FROM gr_label_properties lp, gr_properties_b p WHERE lp.property_id = p.property_id AND lp.label_code = 'FLASH_POINT' ORDER BY lp.sequence_number;

Reporting use cases often involve validating label configuration completeness or auditing the properties assigned across all labels for a given regulatory regime.

Related Objects

GR_LABEL_PROPERTIES sits at the center of several key relationships, as defined by its foreign keys. It is directly dependent on the GR_LABELS_B table (for valid label codes) and the GR_PROPERTIES_B table (for valid property definitions). Most importantly, it has a defining relationship with the GR_ITEM_PROPERTIES table. The primary key of GR_LABEL_PROPERTIES (SEQUENCE_NUMBER, PROPERTY_ID, LABEL_CODE) is referenced by GR_ITEM_PROPERTIES. This means that the actual property values stored for a specific item (in GR_ITEM_PROPERTIES) must correspond to a property configuration predefined for that item's label in GR_LABEL_PROPERTIES, enforcing data integrity and compliance.