View: BIS_SECURED_BUSINESS_GROUPS_V

View Text

SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE))) ORGANIZATION_ID
, O.NAME NAME
, V.LEVEL_VALUE RESPONSIBILITY_ID
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V
, HR_ALL_ORGANIZATION_UNITS O
WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID'
AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
AND V.LEVEL_ID = 10003
AND TO_CHAR(O.ORGANIZATION_ID) = V.PROFILE_OPTION_VALUE UNION SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE))) ORGANIZATION_ID
, O.NAME NAME
, R.RESPONSIBILITY_ID RESPONSIBILITY_ID
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V
, FND_RESPONSIBILITY R
, HR_ALL_ORGANIZATION_UNITS O
WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID'
AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
AND V.LEVEL_ID = 10001
AND TO_CHAR(O.ORGANIZATION_ID) = V.PROFILE_OPTION_VALUE
AND NOT EXISTS (SELECT 1
FROM FND_PROFILE_OPTION_VALUES V1
WHERE V1.PROFILE_OPTION_ID = P.PROFILE_OPTION_ID
AND V1.LEVEL_ID = 10003
AND V1.LEVEL_VALUE = R.RESPONSIBILITY_ID)

Columns