VIEW: APPS.IBE_BI_MSITES_V

Source

View Text - Preformatted

SELECT distinct a.msite_id id from ibe_bi_msiteorg_mv a where not exists (select b.org_id from ibe_bi_msiteorg_mv b where b.msite_id = a.msite_id MINUS select a.organization_id from per_organization_list a where a.security_profile_id = fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL'))

View Text - HTML Formatted

SELECT DISTINCT A.MSITE_ID ID
FROM IBE_BI_MSITEORG_MV A
WHERE NOT EXISTS (SELECT B.ORG_ID
FROM IBE_BI_MSITEORG_MV B
WHERE B.MSITE_ID = A.MSITE_ID MINUS SELECT A.ORGANIZATION_ID
FROM PER_ORGANIZATION_LIST A
WHERE A.SECURITY_PROFILE_ID = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL'))