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