/*  Date Created:	Feb 16, 2002
	Created by:		Jerry Smith
	Description:	Return Child Values with Reporting Attributes from Fund Value Set*/

SELECT DISTINCT
	value.FLEX_VALUE as Fund_Value,
	SUBSTR(value.END_DATE_ACTIVE,1,10) AS END_DATE,
	SUBSTR(value.LAST_UPDATE_DATE,1,10) AS LAST_UPDATE,
	descript.DESCRIPTION as Fund_Title,
	SUBSTR(value.CREATION_DATE,1,10) AS CREATION_DATE,
	ATTRIBUTE15 as Entity,
	ATTRIBUTE16 as Entity_Officer,
	ATTRIBUTE17 as Subactivity,
	ATTRIBUTE18 as Subactivity_Officer,
	value.ENABLED_FLAG as Enabled,
	value.SUMMARY_FLAG as Parent,
	SUBSTR(value.START_DATE_ACTIVE,1,10) AS START_DATE_ACTIVE


FROM APPLSYS.FND_FLEX_VALUE_SETS sets, APPLSYS.FND_FLEX_VALUES value, APPLSYS.FND_FLEX_VALUES_TL Descript

where sets.flex_value_set_id = value.flex_value_set_id
    and value.flex_value_id = descript.flex_value_id
	and sets.flex_value_set_id = '1002349'
	and value.enabled_flag = 'Y'
	and value.summary_flag = 'N'
	and not value.flex_value = '0000000'
	and not value.END_DATE_ACTIVE is Null
	--and value.LAST_UPDATE_DATE between '05/15/2002 00:00:00' and '06/30/2002 23:59:59'





