VIEW: APPS.IBE_BIS_LIST_MSITES_V

Source

View Text - Preformatted

SELECT distinct b.msite_id id, b.msite_name value from ibe_bi_msiteorg_mv a, ibe_msites_vl b where a.msite_id = b.msite_id and 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 B.MSITE_ID ID
, B.MSITE_NAME VALUE
FROM IBE_BI_MSITEORG_MV A
, IBE_MSITES_VL B
WHERE A.MSITE_ID = B.MSITE_ID
AND 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'))