GR Field Name Codes

Description

Categories
BI Publisher
Application
Process Manufacturing Regulatory Management
Source
Field Name Codes Report (XML)
Short Name
GRRPT009_XML
DB package
GR_GRRPT009_XMLP_PKG

SQL 12 lines

Select label_class_code, language, label_class_description
            From gr_label_classes_tl
            Where (:P_label_class_select1 IS NULL OR
                         label_class_code >= :P_label_class_select1)
            and      (:P_label_class_select2 IS NULL OR
                        label_class_code <= :P_label_class_select2)
            and     (: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 7

ParameterTypeList of values SQL
Report TypeLOV Oracle
From Field Name Class CodeLOV Oracle
To Field Name Class CodeLOV Oracle
From Field Name CodeLOV Oracle
To Field Name CodeLOV Oracle
From LanguageLOV Oracle
To LanguageLOV Oracle