GR Safety Phrases

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Process Manufacturing Regulatory Management
Source
Safety Phrases Report (XML)
Short Name
GRRPT007_XML
DB package
GR_GRRPT007_XMLP_PKG

SQL 9 lines

SELECT safety_phrase_code, language,
            safety_phrase_description
            from gr_safety_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

Parameters 2

ParameterTypeList of values SQL
From LanguageLOV Oracle
To LanguageLOV Oracle