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

SELECT DISTINCT
	value.FLEX_VALUE as Natural_Account_Value,
	descript.DESCRIPTION as Natural_Account_Description,
	value.summary_flag as Parent,
	value.CREATION_DATE,
	value.END_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 = '1002355'
	and value.enabled_flag = 'Y'
	--and value.summary_flag = 'N'
	and not value.flex_value = '00000'








