[Home] [Help]
View: OKC_KOL_K_ACCESSES_V
Product: | OKC - Contracts Core |
Description: | Displays contracts with their related user and/or group resources, as well as their respective access level. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT KAC.ID ID
, KAC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KAC.CHR_ID CHR_ID
, KAC.RESOURCE_ID RESOURCE_OR_GROUP_ID
, KAC.ACCESS_LEVEL ACCESS_LEVEL
, RES.NAME NAME
, DECODE(KAC.RESOURCE_ID
, NULL
, NULL
, 'RESOURCE') ID_TYPE
FROM OKC_K_ACCESSES_V KAC
, OKC_RESOURCE_USERS_V RES
WHERE RES.ID = KAC.RESOURCE_ID UNION SELECT KAC.ID ID
, KAC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KAC.CHR_ID CHR_ID
, KAC.GROUP_ID RESOURCE_OR_GROUP_ID
, KAC.ACCESS_LEVEL ACCESS_LEVEL
, RES.NAME NAME
, DECODE(KAC.GROUP_ID
, NULL
, NULL
, 'GROUP') ID_TYPE
FROM OKC_K_ACCESSES_V KAC
, OKC_RESOURCE_GROUPS_V RES
WHERE RES.GROUP_ID = KAC.GROUP_ID
Columns
Name |
ID |
OBJECT_VERSION_NUMBER |
CHR_ID |
RESOURCE_OR_GROUP_ID |
ACCESS_LEVEL |
NAME |
ID_TYPE |