CREATE OR REPLACE VIEW APP_LIST_V AS
SELECT app.APP_ID,
       app.APP_CODE,
       app.APPDESC,
       app.VERSION,
       app.VERSIONDATE,
       app.APPTYPE_CODE,
       app.APPSTATUS_CODE,
       page.PAGE_CODE,
       page.PAGEDESC,
       NVL(appf.MENUNAME,'NOT DEFINE') AS APPNAME
FROM SYS_APP app,
     SYS_PAGE page,
     SYS_APPFEATURE appf
WHERE appf.PAGE_ID=page.PAGE_ID
  AND app.APP_CODE = appf.APP_CODE(+)
  AND appf.Appfeature_Code= appf.Parentappfeature_Code
  AND appf.APPFEATURE_CODE != 'WB_PORTAL_HOME'
  AND app.APPSTATUS_CODE = 'ACTIVE'
  AND app.APPTYPE_CODE = 'ASP.NET'