Query to get functional currency of Business 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;
No comments:
Post a Comment