GL_SETS_OF_BOOKS帐簿表

GL_SETS_OF_BOOKS帐簿表
 
GL_SETS_OF_BOOKS 账簿表
 
SET_OF_BOOKS_ID 账簿ID
 
NAME 账簿名称
 
CHART_OF_ACCOUNTS_ID 账簿科目体系ID
 
-- 单位OU与帐簿SOB关系。一个帐簿可对多个单位
 
-- 一个单位可在多个帐簿
 
SELECT sob.name sob_name,
 
count(sob.name) over(partition by sob.name order by sob.name) sob_qty,
 
hou.name ou_name
 
FROM hr_all_organization_units hou,
 
hr_organization_information hoi,
 
gl_sets_of_books sob
 
WHERE 1 = 1
 
AND hou.organization_id = hoi.organization_id
 
AND hoi.org_information_context = 'Operating Unit Information'
 
org_information3
 

上一个：Oracle trunc影响效率的问题
下一个：oracle求时间差的常用函数