oracle+查看锁定账号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

oracle账号

 

WHERE 1 = 1

 

AND hou.organization_id = hoi.organization_id

 

AND hoi.org_information_context = 'Operating Unit Information'

 

org_information3