View: BIS_ORGANIZATIONS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_ORGANIZATIONS_V

View Text

SELECT TO_CHAR(O.ORGANIZATION_ID)
, HRTL.NAME
, O.RESPONSIBILITY_ID
FROM ORG_ACCESS O
, HR_ALL_ORGANIZATION_UNITS HR
, HR_ALL_ORGANIZATION_UNITS_TL HRTL
WHERE HR.ORGANIZATION_ID = O.ORGANIZATION_ID
AND HR.ORGANIZATION_ID = HRTL.ORGANIZATION_ID
AND HRTL.LANGUAGE = USERENV('LANG') UNION SELECT TO_CHAR(ORG.ORGANIZATION_ID)
, HRTL.NAME
, R.RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL R
, HR_ALL_ORGANIZATION_UNITS HR
, HR_ALL_ORGANIZATION_UNITS_TL HRTL
, MTL_PARAMETERS ORG
WHERE HR.ORGANIZATION_ID = HRTL.ORGANIZATION_ID
AND HRTL.LANGUAGE = USERENV('LANG')
AND HR.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID NOT IN ( SELECT ORA.ORGANIZATION_ID
FROM ORG_ACCESS ORA)

Columns