Query To Find The Details of The Accounting Flexfield Structure

Query To find the details of the Accounting Flexfield structure

SELECT gls.name,
idfs.id_flex_num chart_of_accounts_id,
idfs.segment_num,
idfs.flex_value_set_id,
fvs.flex_value_set_name,
idfs.application_id,
idfs.id_flex_code,
idfs.application_column_name,
idfs.segment_name,
fvs.security_enabled_flag,
( CASE
WHEN fvs.validation_type = ‘F’ THEN ‘Table’
WHEN fvs.validation_type = ‘I’ THEN ‘Independent’
WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’
WHEN fvs.validation_type = ‘N’ THEN ‘None’
WHEN fvs.validation_type = ‘P’ THEN ‘Pair’
WHEN fvs.validation_type = ‘U’ THEN ‘Special’
ELSE ‘Unknown Type’
END ) validation_type,
( CASE
WHEN fvs.validation_type = ‘F’ THEN fvt.application_table_name
ELSE ‘Not Applicable’
END ) validation_table_name
FROM gl_ledgers gls,
fnd_id_flex_segments idfs,
fnd_flex_value_sets fvs,
fnd_flex_validation_tables fvt
WHERE gls.chart_of_accounts_id (+) = idfs.id_flex_num
AND fvs.flex_value_set_id = idfs.flex_value_set_id
AND gls.ledger_id = &ledgerid
AND idfs.application_id = 101
AND idfs.id_flex_code IN ( ‘GL#’, ‘GLLE’ )
AND fvs.flex_value_set_id = fvt.flex_value_set_id (+)
ORDER BY idfs.id_flex_code,
idfs.id_flex_num,
idfs.segment_num ASC;