/*  Date Created:	October 7, 2004
	Created by:		Loren Cook
	Description:	Return Child Values with Reporting Attributes from Department Activity 2 Value Set*/

SELECT DISTINCT
	value.FLEX_VALUE as "Department Activity 2",
	descript.DESCRIPTION as "Department Activity 2 Title",
	value.ENABLED_FLAG as "Enabled Y/N",
	SUBSTR(value.CREATION_DATE,1,10) AS "Creation Date",
	SUBSTR(value.END_DATE_ACTIVE,1,10) AS "End Date",
	SUBSTR(value.LAST_UPDATE_DATE,1,10) AS "Last Update"

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 = '1002353'
	--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'





