GR — Process Manufacturing Regulatory Management
132 documented tables · 92 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
GR_ITEM_GENERAL |
Stores regulatory information that further identifies the item. It also stores flags that govern what data di | hub-leaning |
GR_EXPOSURE_AUTHS |
satellite-leaning | |
GR_HAZARD_GROUPS |
Contains the Hazard Group Code and Description. | hub-leaning |
GR_RISK_PHRASES_B |
Stores the code and name of acceptable phrases in multiple languages. | hub-leaning |
GR_EUROHAZARDS_B |
Contains European Hazard Classification description information. | hub-leaning |
GR_ITEM_GROUPS_B |
Contains the item Group Code and Description and Consolidated Toxicity and Exposure Data. | hub-leaning |
GR_PRODUCT_CLASSES |
Contains the classifications of products with similar requirements or properties, such as solids or acid-based | hub-leaning |
GR_DOCUMENT_CODES |
Contains the date format and determines whether detailed ingredient, toxic, and exposure information displays | hub-leaning |
GR_LABELS_B |
Contains many label classes, each containing many rows that define the format and text for each line on the do | hub-leaning |
GR_PHRASES_B |
Contains the high-level information about the Phrase, the Label Code, and the wording that identifies where on | hub-leaning |
GR_MAIN_HEADINGS_B |
Contains the Main Heading Code where the heading text is located and where the Glossary heading text is locate | hub-leaning |
GR_SUB_HEADINGS_B |
Contains the Sub Heading Code for the sub heading text. | hub-leaning |
GR_LABEL_CLASSES_B |
The LABEL CLASS groups the label codes together into like areas such as HEADER, PHYSICAL and TRANSPORT. Altho | hub-leaning |
GR_SAFETY_CATEGORIES_B |
The safety category code that is used in the European classification process. | hub-leaning |
GR_SAFETY_PHRASES_B |
Stores the code and name of acceptable phrases in multiple languages. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
GR_WF_UTIL_PUB |
PUB | 4 | 6 packages |
GR_DISPATCH_HISTORY_PUB |
PUB | 1 | 1 packages |
GR_RISK_SAFETY_PHRASES_PUB |
PUB | 1 | 0 packages |
GR_ITEM_PROPERTIES_PUB |
PUB | 1 | 0 packages |
GR_FIELD_NAME_CLASSES_PUB |
PUB | 1 | 0 packages |
GR_FIELD_NAME_PROPERTIES_PUB |
PUB | 1 | 0 packages |
GR_FIELD_NAMES_PUB |
PUB | 1 | 0 packages |