Search Results pobv_hazard_classes




Overview
Explore in AI Chat

Overview

POBV_HAZARD_CLASSES is a read-only view owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Purchasing (PO) product family and is documented in ETRM as VALID with the description "Retrofitted." The view presents hazard class reference data used in purchasing and inventory operations, exposing the classification codes that describe the physical, chemical, or regulatory hazards associated with purchased items and materials.

The "BV" designation in the object name follows Oracle's convention for a view layered over a base table, here the PO_HAZARD_CLASSES synonym. The view's role in EBS reporting and integration is to provide a stable, read-only interface to hazard class definitions without exposing direct write access to the underlying table. The WITH READ ONLY clause in the view definition enforces this constraint at the database level, ensuring that any consumer — whether a concurrent program, an OBIEE/BIP report, a custom form, or an external integration — cannot inadvertently modify reference data through the view.

Underlying Base Objects

The documented metadata identifies a single referenced base object: PO_HAZARD_CLASSES (SYNONYM). The view definition confirms this relationship directly:

SELECT HC.HAZARD_CLASS_ID, HC.HAZARD_CLASS, HC.DESCRIPTION, HC.INACTIVE_DATE, HC.CREATION_DATE, HC.CREATED_BY, HC.LAST_UPDATE_DATE, HC.LAST_UPDATED_BY FROM PO_HAZARD_CLASSES HC WITH READ ONLY

The synonym resolves to the hazard class table in the PO schema, which stores the master list of hazard classifications available to the Purchasing application. Because the view is a straightforward projection with no joins, filters, or transformations, it returns one row per hazard class record present in the base table. The WITH READ ONLY clause is the only behavioral modification applied.

Key Columns

  • HAZARD_CLASS_ID — Primary identifier for the hazard class record; used as the foreign key in related purchasing and item attribute tables.
  • HAZARD_CLASS — The short code or name of the hazard classification, displayed on purchasing documents and item setups.
  • DESCRIPTION — Free-text description of the hazard class, providing detail on the nature of the hazard.
  • INACTIVE_DATE — Date on which the hazard class was deactivated. A null value indicates the class is currently active and available for selection.
  • CREATION_DATE / CREATED_BY — Audit columns recording when and by whom the record was created.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — Audit columns recording the most recent modification, standard in EBS reference tables.

Common Use Cases and Queries

Typical usage includes validating hazard class assignments on items, populating LOVs in custom forms, and reporting on the full hazard class catalog for regulatory or compliance review. Because INACTIVE_DATE controls availability, most queries filter on active records. For example, to retrieve all currently active hazard classes ordered by code:

SELECT hazard_class_id, hazard_class, description FROM apps.pobv_hazard_classes WHERE inactive_date IS NULL ORDER BY hazard_class;

To audit recently changed or newly added classifications:

SELECT hazard_class, description, creation_date, last_update_date FROM apps.pobv_hazard_classes WHERE last_update_date >= SYSDATE - 90 ORDER BY last_update_date DESC;

These queries are safe for reporting because the read-only view cannot alter the underlying PO_HAZARD_CLASSES data. All DML must be performed through the Purchasing application forms or through the base table with appropriate privileges.