FND Design Data [Home] [Help]

View: IBE_BI_MSITE_DIMN_V

Product: IBE - iStore
Description: DBI view to get list of stores
Implementation/DBA Data: ViewAPPS.IBE_BI_MSITE_DIMN_V
View Text

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

Columns

Name
ID
VALUE