View: BIS_HR_ORGANIZATIONS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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