R12_Chart_of_Accounts

/* Formatted on 30-08-2011 13:44:53 (QP5 v5.115.810.9015) */
SELECT   hou.name,
         seg.application_column_name,
         seg.segment_name,
         seg.SEGMENT_NUM,
         seg.flex_value_set_id
  FROM   apps.hr_operating_units hou
  ,apps.gl_ledgers gled
  ,FND_ID_FLEX_SEGMENTS seg
  --,fnd_flex_values_vl ffv
 WHERE       gled.ledger_id = hou.set_of_books_id
         AND seg.id_flex_code = 'GL#'
         AND seg.id_flex_num = gled.CHART_OF_ACCOUNTS_ID
--and hou.organization_id=4

select * from gl_code_combinations_kfv
/* Formatted on 31-08-2011 17:03:27 (QP5 v5.115.810.9015) */
SELECT   *
  FROM   fnd_flex_value_sets
 WHERE   FLEX_VALUE_SET_ID = 1014869


SELECT   ffv.FLEX_VALUE,
         fft.FLEX_VALUE_MEANING,
         fft.DESCRIPTION
         --,kfv.CONCATENATED_SEGMENTS
  FROM   fnd_flex_values ffv,
         fnd_flex_values_tl fft
 WHERE       ffv.FLEX_VALUE_ID = fft.FLEX_VALUE_ID
         --AND kfv.SEGMENT2 = ffv.FLEX_VALUE
         AND FLEX_VALUE_SET_ID = 1014869
        

Select * from fnd_flex_values fft , fnd_flex_values_vl ffv
where    fft.FLEX_VALUE_ID=ffv.FLEX_VALUE_ID
--and rownum <=10
Select * from fnd_flex_values_vl where FLEX_VALUE_SET_ID= '1014874'
Select * from fnd_flex_values where flex_value_id=58331
Select * from fnd_flex_value_sets where FLEX_VALUE_SET_ID= '1014874'