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

ParameterTypeList of values SQL
From LanguageLOV Oracle
To LanguageLOV Oracle