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

SELECT DISTINCT
	value.FLEX_VALUE as Object_Value,
	descript.DESCRIPTION as Object_Description,
	value.summary_flag as Parent,
	value.CREATION_DATE,
	value.END_DATE_ACTIVE,
	ATTRIBUTE20 as SAMS_Major,
	ATTRIBUTE21 as SAMS_Detail,
	ATTRIBUTE22 as Tax_Reportable,
	ATTRIBUTE23 as Track_as_Asset


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 = '1002356'
	and value.enabled_flag = 'Y'
	--and value.summary_flag = 'N'
	and not value.flex_value = '0000'






