SELECT fvlt.DESCRIPTION
       --INTO v_description
        FROM  fnd_id_flex_structures fis
        ,fnd_id_flex_segments fisg
        ,fnd_flex_value_sets fvs
        ,fnd_flex_values fvl
        ,fnd_flex_values_tl fvlt
        WHERE fisg.application_id=101 
        AND fis.id_flex_code='GL#'
        AND fis.enabled_flag='Y'
        AND fis.application_id=fisg.application_id
        AND fisg.id_flex_num=fis.id_flex_num
        AND fis.id_flex_code=fisg.id_flex_code
        AND fis.ID_FLEX_STRUCTURE_CODE='ACCOUNTING_FLEXFIELD'
        AND fvs.flex_value_set_id=fisg.flex_value_set_id
        AND fvl.flex_value_set_id=fvs.flex_value_set_id
        AND fvl.flex_value_id=fvlt.flex_value_id
        and fisg.APPLICATION_COLUMN_NAME='SEGMENT4'
        
        AND fvl.flex_value=01; --VALUE OF SEGMENT1