GR Hazard Classification Code Details
Description
- Categories
- BI Publisher
- Application
- Process Manufacturing Regulatory Management
- Source
- Hazard Classification Code Details Report (XML)
- Short Name
- GRRPT931_XML
- DB package
- GR_GRRPT931_XMLP_PKG
SQL 8 lines
select a.hazard_classification_code,a.calculation_hierarchy,a.hazard_group_code , b.hazard_description,b.language from gr_eurohazards_b a , gr_eurohazards_tl b where a.hazard_classification_code = b.hazard_classification_code and (:P_language_select1 is null or b.language >= :P_language_select1) and (:P_language_select2 is null or b.language <= :P_language_select2) order by 1, b.language |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| From Language | LOV Oracle | |
| To Language | LOV Oracle |