用SQL查询各Profile的设置情况

coco1 · 发表于 2006-11-15 09:08

select ood.SET_OF_BOOKS_ID SOB
   ,gl_sob.name SOB_NAME
   ,ood.BUSINESS_GROUP_ID BG
   ,hbg1.name BG_NAME
   ,ood.LEGAL_ENTITY LE
   ,hle.name LE_NAME
   ,ood.OPERATING_UNIT OU
   ,hou.name OU_NAME
   ,ood.organization_id ID
   ,ood.organization_code code
   ,ood.organization_name
  from org_organization_definitions ood
   ,HR_ALL_ORGANIZATION_UNITS hou
   ,HR_ALL_ORGANIZATION_UNITS hle
   ,gl_sets_of_books gl_sob
   ,(select hbg.name,hbg.organization_id,hbg.business_group_id
      from hr_all_organization_units hbg
      where hbg.organization_id = hbg.business_group_id) hbg1
where ood.operating_unit = hou.organization_id
  and ood.legal_entity = hle.organization_id
  and gl_sob.set_of_books_id = ood.set_of_books_id
  and hbg1.organization_id = ood.business_group_id
order by ood.business_group_id
      ,ood.set_of_books_id
      ,ood.legal_entity
      ,ood.operating_unit
      ,ood.organization_id

xingyun1975 · 发表于 2006-11-15 13:22

学习一下

jsj2002 · 发表于 2006-11-22 10:55

好贴！

lvzhaoqiang · 发表于 2006-11-23 15:47

收下了！辛苦了！多谢了！

yft · 发表于 2006-12-11 16:52

3Q!好东东啊，up

lveamy · 发表于 2006-12-11 19:09

谢谢............

joe_xuqj · 发表于 2006-12-12 09:29

好东西

small_star · 发表于 2006-12-12 09:34

good!!!

liuzm0207 · 发表于 2006-12-12 15:15

Thank you much!

hotwish · 发表于 2007-2-3 17:27

GOOD

[精华] 用SQL查询各Profile的设置情况

给个帐本查询SQL

浏览过的版块