GR Field Name Codes

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Regulatory Management
Source: Field Name Codes Report (XML)
Short Name: GRRPT009_XML
DB package: GR_GRRPT009_XMLP_PKG
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
Parameter Name SQL text Validation
To Language
 
LOV Oracle
From Language
 
LOV Oracle
To Field Name Code
 
LOV Oracle
From Field Name Code
 
LOV Oracle
To Field Name Class Code
 
LOV Oracle
From Field Name Class Code
 
LOV Oracle
Report Type
 
LOV Oracle