View: OKE_K_ACCESS_RULES_V

Product:	OKE - Project Contracts
Description:	Contract security access rules view
Implementation/DBA Data:	APPS.OKE_K_ACCESS_RULES_V

View Text

SELECT KAR.ROWID
, KAR.ACCESS_RULE_ID
, KAR.CREATION_DATE
, KAR.CREATED_BY
, KAR.LAST_UPDATE_DATE
, KAR.LAST_UPDATED_BY
, KAR.LAST_UPDATE_LOGIN
, KAR.ROLE_ID
, KAR.SECURED_OBJECT_NAME
, KAR.ATTRIBUTE_GROUP_TYPE
, KAR.ATTRIBUTE_GROUP_CODE
, AG.ATTRIBUTE_GROUP_NAME
, KAR.ATTRIBUTE_CODE
, OA.ATTRIBUTE_NAME
, KAR.ACCESS_LEVEL
FROM OKE_K_ACCESS_RULES KAR
, OKE_OBJECT_ATTRIBUTES_TL OA
, OKE_ATTRIBUTE_GROUPS_V AG
WHERE OA.ATTRIBUTE_CODE (+) = KAR.ATTRIBUTE_CODE
AND OA.LANGUAGE (+) = USERENV('LANG')
AND OA.DATABASE_OBJECT_NAME (+) = KAR.SECURED_OBJECT_NAME
AND AG.ATTRIBUTE_GROUP_CODE (+) = KAR.ATTRIBUTE_GROUP_CODE
AND AG.ATTRIBUTE_GROUP_TYPE (+) = KAR.ATTRIBUTE_GROUP_TYPE

Columns