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