View: BIS_SECURED_BUSINESS_GROUPS1_V

View Text

SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE)))
, V.LEVEL_VALUE
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V
WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID'
AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
AND V.LEVEL_ID = 10003 UNION SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE))) ORGANIZATION_ID
, R.RESPONSIBILITY_ID RESPONSIBILITY_ID
FROM FND_PROFILE_OPTIONS P
, FND_PROFILE_OPTION_VALUES V
, FND_RESPONSIBILITY R
WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID'
AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
AND V.LEVEL_ID = 10001
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