Oracle EBS 获取公司段的本位币

SELECT gls.currency_code
  FROM hr_organization_information_v t,
       gl_sets_of_books              gls
 WHERE t.org_information_context = 'Operating Unit Information'
   AND t.org_information5 = '10052'
   AND gls.set_of_books_id = t.org_information3

 

posted on 2018-11-23 12:38  Jenrry  阅读(667)  评论(0编辑  收藏  举报