IGI Operating Unit Dependent Features Status - draft
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- IGI: Operating Unit Dependent Features Status Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- IGILGCCR_XML
- DB package
- IGI_IGILGCCR_XMLP_PKG
SQL 16 lines
SELECT gc.option_name option_name , gc.status_flag , l.description , nvl(gc.org_id, -1) org_id &CP_SELECT FROM igi_gcc_inst_options_all gc , igi_lookups l &CP_FROM WHERE l.lookup_type = 'GCC_DESCRIPTION' AND l.lookup_code = gc.option_name AND gc.option_name between nvl(:P_OPT_NAME_LOW, gc.option_name) and nvl(:P_OPT_NAME_HIGH, gc.option_name) &CP_WHERE ORDER BY &p_orderby_t |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Organization Name From | LOV Oracle | |
| Organization Name To | LOV Oracle | |
| Feature Name From | LOV Oracle | |
| Feature Name To | LOV Oracle | |
| Order By | LOV Oracle |