GR Field Name Class Codes

Description

Categories
BI Publisher
Application
Process Manufacturing Regulatory Management
Source
Field Name Class Codes Report (XML)
Short Name
GRRPT005_XML
DB package
GR_GRRPT005_XMLP_PKG

SQL 9 lines

SELECT  LABEL_CLASS_CODE, LANGUAGE,
            LABEL_CLASS_DESCRIPTION
            FROM GR_LABEL_CLASSES_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