Wednesday, 20 December 2017

Query to get functional currency of Bussiness Unit

SELECT
  gs.currency_code,
  ho.name
FROM
  gl_sets_of_books gs,
  ar_system_parameters_all os,
  hr_operating_units ho
WHERE
  OS.SET_OF_BOOKS_ID = GS.SET_OF_BOOKS_ID
  and HO.name = '<BUSSINESS UNIT NAME>'
  AND ho.organization_id = os.org_id;

1 comment:

  1. This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. OrbitEx

    ReplyDelete