Query to get Account Segment Description

https://generalledger-gl.blogspot.com/2018/11/blog-post.html


SELECT gl_flexfields_pkg.get_description_sql 

 
(

chart_of_accounts_id,--- chart of account id
1,----- Position of segment
segment1 ---- Segment value
) 

 
FROM gl_code_combinations