Select Fifs.Flex_Value_Set_Id From apps.Fnd_Id_Flex_Segments Fifs
Where Fifs.Id_Flex_Code = 'GL#'
And Fifs.Id_Flex_Num = 101 And Fifs.Application_Column_Name = 'SEGMENT3'
Select Ffv.Description, Ffv.* From apps.Fnd_Flex_Values_Vl Ffv Where Ffv.Flex_Value_Set_Id = 1004899 And FFV.FLEX_VALUE = '6512'
Select * From gl_code_combinations gcc Where gcc.code_combination_id=1113