FND Design Data [Home] [Help]

Table: JTF_UM_APPROVERS

Product: JTF - CRM Foundation
Description: Defines the individual approvers for an approval (JTF_UM_APPROVAL_B). The approvers can be defined globally, as well as overridden for a given organization (HZ_PARTIES). Approvers don't necessarily have to be specified as fnd_user, we will
Implementation/DBA Data: TableJTF.JTF_UM_APPROVERS
Primary Key: JTF_UM_APPROVERS_PK
  1. ColumnAPPROVER_ID
Primary Key: JTF_UM_APPROVERS_U1
  1. ColumnAPPROVAL_ID
  2. ColumnAPPROVER_SEQ
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnORG_PARTY_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_UM_APPROVERS FK Joins to TableJTF_UM_APPROVALS_B JTF_UM_APPROVERS.APPROVAL_ID
JTF_UM_APPROVERS FK Joins to TableHZ_PARTIES JTF_UM_APPROVERS.ORG_PARTY_ID
JTF_UM_APPROVERS FK Joins to TableFND_USER JTF_UM_APPROVERS.USER_ID