【结贴】关于账簿表gl_sets_of_books的探索

skaizhenzhen

gl_sets_of_books表账簿表
SET_OF_BOOKS_ID字段是账簿ID，NAME字段是账簿名称
CHART_OF_ACCOUNTS_ID账簿科目体系ID
在Oracle11i里面一个账簿下是有多个实体单位的账务信息的，但是在这张表里面似乎看不到和单位相关的任何信息
我用这条SQL能够查到所有有GL数据的单位，但是就一个问题无法解决，找不到单位和账簿的关系
select distinct a.description,a.flex_value_meaning from fnd_flex_values_tl AS A
INNER join fnd_flex_values as b on a.FLEX_VALUE_ID=b.FLEX_VALUE_ID and a.FLEX_VALUE_MEANING=b.FLEX_VALUE
inner join fnd_id_flex_segments as c on b.FLEX_VALUE_SET_ID=c.FLEX_VALUE_SET_ID
INNER JOIN gl_code_combinations d ON d.SEGMENT1=a.flex_value_meaning
where LANGUAGE='ZHS' and b.FLEX_VALUE='1001' and c.application_column_name = 'SEGMENT1' AND c.id_flex_code = 'GL#'

结论：
Oracle一家单位可以在多个账簿中出现
遗留问题：
一个账簿是不是会包含多个单位的账务数据呢？

jojoz

SELECT sob.NAME sob_name, hou.NAME ou_name
FROM hr_all_organization_units hou
,HR_ORGANIZATION_INFORMATION HOI
,gl_sets_of_books sob
WHERE hou.organization_id = hoi.organization_id
AND   hoi.org_information_context='Operating Unit Information'
AND   sob.set_of_books_id = hoi.org_information3

skaizhenzhen

谢谢斑竹，解决啦！