FND Design Data [Home] [Help]

Table: JTF_AUTH_ROLE_PERMS

Product: JTF - CRM Foundation
Description: This table groups roles [which are a type of principals] to permissions. Permissions can be positive or negative, based on the column POSITIVE_FLAG.
Implementation/DBA Data: TableJTF.JTF_AUTH_ROLE_PERMS
Primary Key: JTF_AUTH_ROLE_PERMS_PK
  1. ColumnJTF_AUTH_ROLE_PERMISSION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_AUTH_ROLE_PERMS FK Joins to TableFND_APPLICATION JTF_AUTH_ROLE_PERMS.APPLICATION_ID
JTF_AUTH_ROLE_PERMS FK Joins to TableJTF_AUTH_PRINCIPALS_B JTF_AUTH_ROLE_PERMS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_ROLE_PERMS FK Joins to TableJTF_AUTH_PERMISSIONS_B JTF_AUTH_ROLE_PERMS.JTF_AUTH_PERMISSION_ID