Home / AppsDBA Scripts / 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, 
       ( 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.segment_num ASC; 



About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Application Report Queries


Leave a Reply