Search Results gr_property_values_tl




Overview
Explore in AI Chat

Overview

The GR_PROPERTY_VALUES_TL table is a core data validation and translation table within the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. It serves as the master repository for the allowable values, their descriptive meanings, and translated descriptions for properties defined within the regulatory framework. Its primary role is to enforce data integrity by providing a controlled list of valid entries for user-defined or system-defined properties, such as hazard classifications or regulatory flags, ensuring consistency in regulatory reporting and substance management across multilingual implementations.

Key Information Stored

The table stores the language-specific descriptions for predefined property values. Its structure is defined by a composite primary key and supports multilingual data through the Translation Layer (TL) convention. Key columns include:

  • PROPERTY_ID: Foreign key to GR_PROPERTIES_B, identifying the specific property for which this value is valid.
  • VALUE: The stored code or abbreviation for the property value (e.g., 'N', 'P', 'PP').
  • LANGUAGE: The language code (e.g., 'US', 'F') for the translated description, referencing FND_LANGUAGES.
  • DESCRIPTION: The translated, user-facing description of the value for the specified LANGUAGE.
  • MEANING: A concise explanation of the value's significance, often used in lists of values (LOVs).
  • SOURCE_LANG: The original language in which the data was entered, also referencing FND_LANGUAGES.

Common Use Cases and Queries

This table is central to generating accurate lists of values (LOVs) in regulatory forms and validating data imports. A typical use case involves populating a LOV for a "Marine Pollutant" property field. The following query retrieves all valid, translated values for a specific property:

SELECT gv.value, gv.meaning, gv.description
FROM gr_property_values_tl gv
WHERE gv.property_id = (SELECT property_id FROM gr_properties_b WHERE property_name = 'MARINE_POLLUTANT')
AND gv.language = USERENV('LANG')
ORDER BY gv.value;

For reporting, it is commonly joined to GR_PROPERTIES_B to include property context, and to transactional tables like GR_ITEM_PROPERTIES to decode stored value codes into human-readable descriptions for regulatory compliance reports.

Related Objects

The table maintains strict referential integrity through documented foreign key relationships. Key related objects include:

  • GR_PROPERTIES_B (Table): The base table defining the property itself. Joined via GR_PROPERTY_VALUES_TL.PROPERTY_ID = GR_PROPERTIES_B.PROPERTY_ID.
  • FND_LANGUAGES (Table): The application standard languages table. Referenced twice: for the LANGUAGE column and the SOURCE_LANG column.
  • GR_ITEM_PROPERTIES / Similar Transactional Tables: While not listed in the provided FKs, child tables storing actual property assignments for items or substances will reference the allowed VALUE codes defined in this table, using PROPERTY_ID and VALUE.