How to get segment description in oracle apps

How to get segment description in oracle apps

In this post , We will be discuss about the sql query to get segment description in oracle apps. This SQL query will help to extract the Chart of Account Segment values description in oracle apps. We can get the description of any Chart of Account segment value. we just need to know the Right segment name created for under Chart of Account in oracle apps. In this query we need to pass two important things to get the segment description in oracle and that is Right Segment Name and the Value under that Segment for which we want to get the description.

3 Important Tables to  get segment description in oracle apps

1.fnd_flex_values_tl

2.fnd_flex_values

3.fnd_id_flex_segments

SQL Query to get segment description in oracle apps

Here below , We are trying to get segment description in oracle apps. In this case , I know my First segment Name in the Chart of accounts is 'Company' and the value '456'  for which i want to see the description.

SELECT description

FROM fnd_flex_values_tl ffvt,

fnd_flex_values ffv,

fnd_id_flex_segments fifs
  WHERE ffv.flex_value_id = ffvt.flex_value_id

AND fifs.flex_value_set_id = ffv.flex_value_set_id

AND fifs.segment_name = 'Company' --need to give the right segment name-----

AND fifs.id_flex_code = 'GL#'

AND ffv.flex_value = '456'  ---- Need to pass the right Segment Value for Company Segment--

How to get segment description in oracle apps