Query : Get the Account Description

Query : Get the Account Description

select segment1,segment2,segment3,

apps.gl_flexfields_pkg.get_description_sql(&char_of_account_id,1,gcc.segment1) seg1,
apps.gl_flexfields_pkg.get_description_sql(&char_of_account_id,1,gcc.segment2) seg2,
apps.gl_flexfields_pkg.get_description_sql(&char_of_account_id,3,gcc.segment3) seg3
FROM gl_code_combinations gcc
WHERE gcc.code_combination_id = &code_combination_id;

GIVE THE chart of account_id as same value for seg1,seg2 and seg3

and give the  code_combination_id