VIEW: APPS.OKE_K_ACCESS_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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