FND Design Data [Home] [Help]

Table: JTF_AUTH_PRINCIPAL_MAPS

Product: JTF - CRM Foundation
Description: This table will be used to grant roles to users by making users [JTF_AUTH_PARENT_PRINCIPAL_ID] parents of the roles [JTF_AUTH_PRINCIPAL_ID] on a domain basis [JTF_AUTH_DOMAIN_ID]
Implementation/DBA Data: TableJTF.JTF_AUTH_PRINCIPAL_MAPS
Primary Key: JTF_AUTH_PRINCIPAL_MAP_PK
  1. ColumnJTF_AUTH_PRINCIPAL_MAPPING_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_AUTH_PRINCIPAL_MAPS FK Joins to TableJTF_AUTH_PRINCIPALS_B JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_PRINCIPAL_MAPS FK Joins to TableJTF_AUTH_PRINCIPALS_B JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_PARENT_PRINCIPAL_ID
JTF_AUTH_PRINCIPAL_MAPS FK Joins to TableJTF_AUTH_DOMAINS_B JTF_AUTH_PRINCIPAL_MAPS.JTF_AUTH_DOMAIN_ID
JTF_AUTH_PRINCIPAL_MAPS FK Joins to TableFND_APPLICATION JTF_AUTH_PRINCIPAL_MAPS.APPLICATION_ID