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
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
Blitz Report™