SELECT hou.organization_id, hou.NAME organization_name, COUNT(*) online_num FROM (SELECT DISTINCT responsibility_id, user_id FROM fnd_signon_audit_view) a, (SELECT * FROM org_access oa) oa, (SELECT * FROM hr_all_organization_units_tl hou WHERE LANGUAGE = 'US') hou WHERE a.responsibility_id = oa.responsibility_id(+) AND oa.organization_id = hou.organization_id(+) GROUP BY hou.NAME, hou.organization_id;
PostRank
2009/08/10
如何取得各組織的線上人數
各組織的線上人數
標籤:
Oracle EBS Developer
Related Posts:
- 如何展開BOM表 - 2009-07-29
- 如何避免下載Word/Excel時被IE開啟 - 2009-06-16
- SQL开发建议 - 2009-05-23
- Oracle內建包DBMS_LOB使用說明 - 2009-05-13
- Oracle内建包UTL_FILE使用说明 - 2009-05-12
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言