Get Segment Description Oracle R12

SELECT SUBSTR(gl_flexfields_pkg.get_description_sql( :chart_of_account_id,:segment_number,:segment_value),1,500) segment_desc from dual
/