[Home] [Help]
View: BIS_HR_ORGANIZATIONS_V
View Text
SELECT TO_CHAR(H.ORGANIZATION_ID)
, HTL.NAME||' : '||B.VALUE
, B.RESPONSIBILITY_ID
, H.ORGANIZATION_ID
, HTL.NAME
, TO_NUMBER(B.ID)
, B.VALUE
FROM HR_ALL_ORGANIZATION_UNITS H
, HR_ALL_ORGANIZATION_UNITS_TL HTL
, BIS_BUSINESS_GROUPS_V B
WHERE H.BUSINESS_GROUP_ID = B.ID
AND HTL.ORGANIZATION_ID = H.ORGANIZATION_ID
AND HTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ID |
VALUE |
RESPONSIBILITY_ID |
ORGANIZATION_ID |
ORGANIZATION_NAME |
BUSINESS_GROUP_ID |
BUSINESS_GROUP_NAME |