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
| Parameter | Type | List of values SQL |
|---|---|---|
| Report Type | LOV Oracle | |
| From Field Name Class Code | LOV Oracle | |
| To Field Name Class Code | LOV Oracle | |
| From Field Name Code | LOV Oracle | |
| To Field Name Code | LOV Oracle | |
| From Language | LOV Oracle | |
| To Language | LOV Oracle |