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
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
Run
IGI Operating Unit Dependent Features Status - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Name From |
|
LOV Oracle | |
Organization Name To |
|
LOV Oracle | |
Feature Name From |
|
LOV Oracle | |
Feature Name To |
|
LOV Oracle | |
Order By |
|
LOV Oracle |