GL Account Description

Below is the query for getting description of GL Account, change your Org_ID, Account_Code, Segment & CCID accordingly.

f

select gcc1.segment2||'.'||
(select gl_flexfields_pkg.get_description_sql
                                     ((select distinct ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id = 141),--- chart of account id
                                      2,----- Position of segment
                                      '404007'--gcc.segment2 ---- Segment value
                                     )
from gl_code_combinations gcc
where gcc.code_combination_id = 1013)
from gl_code_combinations gcc1
where gcc1.code_combination_id = 1013

Kindly Bookmark this Post using your favorite Bookmarking service: