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;
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;
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