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
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 | |
|---|---|---|---|
| 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 |