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_NUMBER or EUROPEAN_INDEX_NUMBER to enrich item-level compliance reports with the CHEMICAL_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.