SQL Query to find ledger id, chart of account id from Business unit name in Oracle Fusion

 Use the below query:

SELECT bu.bu_id,
       bu.bu_name,
       fs.set_code          bu_short_code,
       bu.primary_ledger_id ledger_id,
       gl.name              ledger_name,
       gl.chart_of_accounts_id,
       fls.id_flex_structure_code,
       fs.set_id
FROM   fun_all_business_units_v bu,
       fnd_setid_sets fs,
       gl_ledgers gl,
       fnd_id_flex_structures fls
WHERE  1 = 1
       AND fs.set_id = bu.default_set_id
       AND bu.primary_ledger_id = gl.ledger_id
       AND fls.id_flex_num = gl.chart_of_accounts_id
       AND fls.id_flex_code = 'GL#'
       AND fls.application_id = '101'
       AND fs.set_code = :pBusinessUnit