?? page_feature_parameter_v.sql
字號(hào):
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
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -