Results for “primary_cas_number”
47 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The GR_EIN_NUMBERS_B_V view resides in the APPS schema and belongs to the Oracle Process Manufacturing (OPM) Regulatory Management module, identified by the product code GR. It is a lightweight, read-oriented projection whose documented purpose is to contain one row for each European Index Number (EIN), the numeric identifier assigned under the European Union's regulatory framework for chemical substances. Because the object is classified as a VIEW and is marked VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2, it is intended to be queried rather than maintained directly. In practice, the view acts as the reporting and integration surface for European chemical identification data, allowing external regulatory reports, product safety documents, and interfaces to retrieve substance identifiers without touching the base table directly.
Underlying Base Objects
According to the documented ETRM metadata, GR_EIN_NUMBERS_B_V is defined over a single referenced base object: the synonym GR_EIN_NUMBERS_B. The view text confirms this, issuing a straightforward SELECT over that object using the alias B, with no joins, unions, or aggregations. This one-to-one relationship means the row count and row identity of the view mirror the base table exactly. The view is a pure column-level projection that additionally materializes the physical ROWID of the base row as ROW_ID, a common Oracle EBS pattern that gives consumers a stable handle on the underlying record. No WHERE clause or filter is applied, so all EIN records in the base table—including disabled or historical entries, if any—are exposed.
Key Columns
The view exposes ten columns, all taken from GR_EIN_NUMBERS_B:
ROW_ID— the base-table ROWID, serving as a unique address for each row.EUROPEAN_INDEX_NUMBER— the European Index Number itself, the primary regulatory key used in EU classification and labelling.EEC_NUMBER— the European Economic Community number associated with the substance.PRIMARY_CAS_NUMBER— the primary Chemical Abstracts Service registry number, the most widely recognized global substance identifier.CHEMICAL_FORMULA— the molecular formula of the substance, stored as descriptive text; this is the column matching the user's search term.CREATED_BY,CREATION_DATE— standard audit columns recording row creation.LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard audit columns recording the most recent modification.
Common Use Cases and Queries
The view is typically used to resolve or display chemical identity data in regulatory reporting, MSDS/safety documentation generation, and substance master-data validation. A direct lookup by European Index Number or CAS number is the most frequent access pattern:
SELECT european_index_number, primary_cas_number, chemical_formula FROM apps.gr_ein_numbers_b_v WHERE primary_cas_number = :cas;SELECT * FROM apps.gr_ein_numbers_b_v WHERE european_index_number = :ein;SELECT COUNT(*) FROM apps.gr_ein_numbers_b_v;to validate the load of EIN reference data.- Joins to inventory or regulatory item tables on
PRIMARY_CAS_NUMBERorEUROPEAN_INDEX_NUMBERto enrich item-level compliance reports with theCHEMICAL_FORMULA.
Because the view adds no filtering or logic, it is safe for high-volume reporting, though it should be treated as read-only reference data and joined only on indexed identifier columns where possible.
-
View: GR_EIN_NUMBERS_B_V 12.1.1
Contains a row for each european index number
APPS.GR_EIN_NUMBERS_B_V·↳ GR_EIN_NUMBERS_B·Explore GR module →
-
Contains a row for each european index number
-
Contains a row for each european index number
-
View: GR_EIN_NUMBERS_B_V 12.2.2
Contains a row for each european index number
APPS.GR_EIN_NUMBERS_B_V·↳ GR_EIN_NUMBERS_B·Explore GR module →
-
Stores regulatory information that further identifies the item. It also stores flags that govern what data displays on the MSDS.
-
View: GR_ITEM_GENERAL_V 12.1.1
View of Regulatory Item details, includes the items details for Regulatory Items with regard to the Convergence model
APPS.GR_ITEM_GENERAL_V·↳ GR_ITEM_EXPLOSION_PROPERTIES·↳ MTL_SYSTEM_ITEMS_KFV·Explore GR module →
-
Stores regulatory information that further identifies the item. It also stores flags that govern what data displays on the MSDS.
-
View: GR_ITEM_GENERAL_V 12.2.2
View of Regulatory Item details, includes the items details for Regulatory Items with regard to the Convergence model
APPS.GR_ITEM_GENERAL_V·↳ GR_ITEM_EXPLOSION_PROPERTIES·↳ MTL_SYSTEM_ITEMS_KFV·Explore GR module →
-
VIEW: GR.GR_EIN_NUMBERS_B# 12.2.2
-
TABLE: GR.GR_EIN_NUMBERS_B 12.1.1
-
VIEW: GR.GR_EIN_NUMBERS_B# 12.2.2
-
TABLE: GR.GR_EIN_NUMBERS_B 12.2.2
-
VIEW: APPS.GR_ITEM_GENERAL_V 12.1.1
-
VIEW: APPS.GR_ITEM_GENERAL_V 12.1.1
-
VIEW: APPS.GR_ITEM_GENERAL_V 12.2.2
-
VIEW: APPS.GR_ITEM_GENERAL_V 12.2.2
-
TABLE: GR.GR_ITEM_GENERAL 12.2.2
-
TABLE: GR.GR_ITEM_GENERAL 12.1.1
-
eTRM - GR Tables and Views 12.2.2
GR XML mapping table
-
eTRM - GR Tables and Views 12.1.1
GR XML mapping table