View: IBE_BI_MSITES_V

Product:	IBE - iStore
Description:	DBI view to get list of stores
Implementation/DBA Data:	APPS.IBE_BI_MSITES_V

View Text

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

Columns