Query : GL - COA

COA VALUES

___________________________________________________________________

1.fnd_flex_value_sets

2.fnd_flex_values

3.fnd_flex_values_tl

_____________________________________________________________________

SELECT ffvs.flex_value_set_id ,

ffvs.flex_value_set_name ,

ffvs.description set_description ,

ffvs.validation_type,

ffv.flex_value,

ffvt.description value_description,

ffv.enabled_flag, 

ffv.start_date_active, 

ffv.end_date_active

FROM fnd_flex_value_sets ffvs ,

fnd_flex_values ffv ,

fnd_flex_values_tl ffvt

WHERE 1=1

and ffvs.flex_value_set_id = ffv.flex_value_set_id

and ffv.flex_value_id = ffvt.flex_value_id

AND ffvt.language = USERENV('LANG')

and flex_value_set_name in ('Acct', 'LE', 'Emp', 'Dept', 'Proj', 'IC', 'Vendor', 'Fut1', 'Fut2')

ORDER BY flex_value asc, flex_value_set_name asc

______________________________________________________________________

select 

hou.name BU_NAME,

led.NAME Ledger_Name,

Str.STRUCTURE_CODE CHART_OF_ACCOUNTS_Name,

SegInSt.SEGMENT_CODE COA_SEGMENT_NAME,

vs.value_set_code,

vs.description value_set_desc

from 

hr_operating_units hou,

xla_gl_ledgers led ,

fnd_kf_structures_b Str,

fnd_kf_str_instances_b StrInSt,

fnd_kf_segment_instances SegInSt,

fnd_vs_value_sets vs

where 1=1

and led.ledger_id = hou.set_of_books_id

AND led.CHART_OF_ACCOUNTS_ID = Str.Structure_id

AND Str.KEY_FLEXFIELD_CODE = ‘GL#’

AND Str.Structure_id = StrInSt.Structure_id

and SegInSt.Structure_inStance_id = StrInSt.Structure_inStance_id 

and vs.VALUE_SET_ID = SegInSt.VALUE_SET_ID