VIEW: APPS.BIS_SETS_OF_BOOKS_V

Source

View Text - Preformatted

SELECT /*+ ORDERED */ TO_CHAR(o.set_of_books_id) , o.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 = 'GL_SET_OF_BKS_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, gl_sets_of_Books o WHERE o.set_of_books_id = to_number(v.profile_option_value) union SELECT /*+ ORDERED */ TO_CHAR(o.set_of_books_id) , o.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 = 'GL_SET_OF_BKS_ID') v, gl_sets_of_Books o WHERE o.set_of_books_id = to_number(v.profile_option_value)

View Text - HTML Formatted

SELECT /*+ ORDERED */ TO_CHAR(O.SET_OF_BOOKS_ID)
, O.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 = 'GL_SET_OF_BKS_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
, GL_SETS_OF_BOOKS O
WHERE O.SET_OF_BOOKS_ID = TO_NUMBER(V.PROFILE_OPTION_VALUE) UNION SELECT /*+ ORDERED */ TO_CHAR(O.SET_OF_BOOKS_ID)
, O.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 = 'GL_SET_OF_BKS_ID') V
, GL_SETS_OF_BOOKS O
WHERE O.SET_OF_BOOKS_ID = TO_NUMBER(V.PROFILE_OPTION_VALUE)