Search Results po_hazard_classes_b




Overview
Explore in AI Chat

Overview

The PO_HAZARD_CLASSES_B table is a core reference table within the Oracle E-Business Suite Purchasing (PO) module. It serves as the master repository for hazardous material classification codes. This table is essential for organizations that procure, store, or transport materials regulated under health, safety, and environmental (HSE) guidelines, such as those defined by the United Nations (UN) model regulations. Its primary role is to provide a standardized list of hazard classes that can be assigned to items in the inventory system and referenced throughout the procurement lifecycle, ensuring compliance and safety information is consistently maintained.

Key Information Stored

While the provided metadata does not list specific columns, the structure of Oracle EBS tables and the context indicate typical key attributes. The primary identifier is the HAZARD_CLASS_ID, a unique system-generated key. The table likely stores a CODE (e.g., '3' for flammable liquids) and a DESCRIPTION or NAME for the hazard class (e.g., 'Flammable Liquids'). Additional columns may include ENABLED_FLAG, START_DATE_ACTIVE, and END_DATE_ACTIVE to control the usage of the classification. The '_B' suffix denotes it is the base table for a translatable entity, meaning descriptive information is stored in a corresponding table, typically PO_HAZARD_CLASSES_TL, to support multiple languages.

Common Use Cases and Queries

The primary use case is the association of hazard classifications with inventory items and purchase documents. When defining an item in the MTL_SYSTEM_ITEMS_B table, a value from PO_HAZARD_CLASSES_B can be assigned to its HAZARD_CLASS_ID column. This classification then propagates to purchase requisitions, purchase orders, and their archival records. Common queries include generating safety reports for shipped items or validating procurement compliance. A typical SQL pattern to list all active hazard classes is:

  • SELECT HAZARD_CLASS_ID, CODE, DESCRIPTION FROM PO_HAZARD_CLASSES_B WHERE ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);

Another frequent query joins this table to item master or purchase order lines to report on hazardous materials being ordered.

Related Objects

As indicated by the foreign key relationships, PO_HAZARD_CLASSES_B is centrally referenced by numerous transactional and interface tables in Purchasing and Inventory. Key related objects include:

  • MTL_SYSTEM_ITEMS_B: Inventory items are linked to a hazard class via the HAZARD_CLASS_ID column.
  • PO_LINES_ALL / PO_REQUISITION_LINES_ALL: Purchase order and requisition lines inherit the hazard classification from the associated inventory item.
  • PO_LINES_DRAFT_ALL / PO_LINES_ARCHIVE_ALL: Draft and archived purchasing documents maintain referential integrity to this table.
  • PO_REQUISITIONS_INTERFACE_ALL: The Open Interface for requisitions can populate the HAZARD_CLASS_ID.
  • PO_UN_NUMBERS_B: This table, which stores specific UN identification numbers for dangerous goods, references a broader hazard class, establishing a hierarchical relationship within the hazardous materials data model.