FND Design Data [Home] [Help]

Table: PA_CI_ACTIONS

Product: PA - Projects
Description: This table stores the action log for each control item. Each entry stores the complete requesting information and response.
Implementation/DBA Data: TablePA.PA_CI_ACTIONS
Primary Key: PA_CI_ACTIONS_PK
  1. ColumnCI_ACTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_CI_ACTIONS FK Joins to TablePA_CONTROL_ITEMS PA_CI_ACTIONS.CI_ID
PA_CI_ACTIONS FK Joins to TablePA_PROJECT_STATUSES PA_CI_ACTIONS.STATUS_CODE
PA_CI_ACTIONS FK Joins to TableHZ_PARTIES PA_CI_ACTIONS.ASSIGNED_TO
PA_CI_ACTIONS FK Joins to TablePA_CI_ACTIONS PA_CI_ACTIONS.SOURCE_CI_ACTION_ID
TablePA_CI_COMMENTS FK Joins to PA_CI_ACTIONS PA_CI_COMMENTS.CI_ACTION_ID
TablePA_CI_ACTIONS FK Joins to PA_CI_ACTIONS PA_CI_ACTIONS.SOURCE_CI_ACTION_ID
TablePA_CI_COMMENTS FK Joins to PA_CI_ACTIONS PA_CI_COMMENTS.CI_ACTION_ID