eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIS_BUSINESS_GROUPS_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')