page_feature_parameter_v.sql

来自「用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）」· SQL 代码 · 共 26 行

CREATE OR REPLACE VIEW PAGE_FEATURE_PARAMETER_V AS
SELECT USR.USER_ID,
       USR.USER_CODE,
       FEA.APPFEATURE_ID,
       FEA.APPFEATURE_CODE,
       PPT.REFERENCEUI,
       PPT.UICOMPONENT_TYPE,
       FPT.PAGEPARAMETER_VKEY,
       FPT.VALUE,
       FPT.LOOKUP_ENABLED,
       FPT.UPDATE_ENABLED,
       FPT.LOOKUP_UPDATE_ENABLED
  FROM SYS_USER                 USR,
       SYS_APPGROUP_FEATURE  APG,
       SYS_APPFEATURE           FEA,
       SYS_FEATURE_PARAMETER FPT,
       SYS_PAGE_PARAMETER       PPT
 WHERE USR.USERSTATUS_CODE = 'ACTIVE'
   AND USR.APPGROUP_ID = APG.APPGROUP_ID
   AND APG.ISVALID = 'Y'
   AND APG.APPFEATURE_CODE = FEA.APPFEATURE_CODE
   AND FEA.ISVALID = 'Y'
   AND FEA.APPFEATURE_ID = FPT.FEATURE_ID
   AND FPT.PAGEPARAMETER_VKEY = PPT.PAGEPARAMETER_VKEY