API: GL_FLEXFIELDS _PKG to get the description of GL Account

apps.gl_flexfields_pkg.get_description_sql( gcc.chart_of_accounts_id,5,gcc.segment5) Segment5_desc. from gl_code_combinations gcc. API:GL_FLEXFIELDS_PKGtogetthedescriptionofGLAccount API:GL_FLEXFIELDS_PKGtogetthedescriptionofGLAccount Ifyouwishtodisplaytheaccountdescription,OracleprovidesanAPIforthatinsteadofhittingtheValueSettablesforeachofthesegment.Belowisanexampleofthesame. Parameters: 1.ChartofAccountid 2.NumberoftheSegment 3.Segmentvalueforwhichyouneedthedescription 12345678 SELECTgcc.code_combination_id,apps.gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,1,gcc.segment1)Segment1_desc,apps.gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,2,gcc.segment2)Segment2_desc,apps.gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,3,gcc.segment3)Segment3_desc,apps.gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,4,gcc.segment4)Segment4_desc,apps.gl_flexfields_pkg.get_description_sql(gcc.chart_of_accounts_id,5,gcc.segment5)Segment5_descfromgl_code_combinationsgccwheregcc.code_combination_id=12854—codecombinationid April20,2014 Prudhvi GLAPI AccountDescription,GL_FLEXFIELDS_PKG