View: BIS_BUSINESS_GROUPS_V

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

View Text

SELECT /*+ ORDERED */ TO_CHAR(O.ORGANIZATION_ID)
, OTL.NAME
, V.RESPONSIBILITY_ID
FROM (SELECT V1.PROFILE_OPTION_VALUE
, V1.LEVEL_VALUE
, R2.RESPONSIBILITY_ID
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V1
, FND_RESPONSIBILITY R2
WHERE P.PROFILE_OPTION_ID=V1.PROFILE_OPTION_ID
AND V1.LEVEL_ID=10001
AND P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID'
AND NOT EXISTS (SELECT 1
FROM FND_PROFILE_OPTION_VALUES V2
WHERE V2.PROFILE_OPTION_ID = P.PROFILE_OPTION_ID
AND V2.LEVEL_ID = 10003
AND V2.LEVEL_VALUE = R2.RESPONSIBILITY_ID ) ) V
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE O.ORGANIZATION_ID = TO_NUMBER(V.PROFILE_OPTION_VALUE)
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG') UNION SELECT /*+ ORDERED */ TO_CHAR(O.ORGANIZATION_ID)
, OTL.NAME
, V.LEVEL_VALUE
FROM (SELECT V1.PROFILE_OPTION_VALUE
, V1.LEVEL_VALUE
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V1
WHERE P.PROFILE_OPTION_ID=V1.PROFILE_OPTION_ID
AND V1.LEVEL_ID=10003
AND P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID') V
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE O.ORGANIZATION_ID = TO_NUMBER(V.PROFILE_OPTION_VALUE)
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')

Columns