VIEW: APPS.BIS_HR_ORGANIZATIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')