GR Risk Phrases

Description

Categories
BI Publisher
Application
Process Manufacturing Regulatory Management
Source
Risk Phrases Report (XML)
Short Name
GRRTP006_XML
DB package
GR_GRRPT006_XMLP_PKG

SQL 9 lines

SELECT risk_phrase_code, language,
            risk_description
            from gr_risk_phrases_tl
            where (:P_language_select1 is null OR
                        language >= :P_language_select1)
             and    (:P_language_select2 is null OR
                        language <= :P_language_select2)
            order by 1, 2

Parameters 2

ParameterTypeList of values SQL
From LanguageLOV Oracle
To LanguageLOV Oracle