eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_CONTROL_ITEMS

Product:	PA - Projects
Description:	PA_CONTROL_ITEMS stores user-defined control items in a project. Each item is of an item type as specified by the CI_TYPE_ID column. The items are categorized using the Classification, Reason and Priority attributes
Implementation/DBA Data:	PA.PA_CONTROL_ITEMS

Primary Key: PA_CONTROL_ITEMS_PK

CI_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_CONTROL_ITEMS	PA_PROJECTS_ALL	PA_CONTROL_ITEMS.PROJECT_ID
PA_CONTROL_ITEMS	PA_CI_TYPES_B	PA_CONTROL_ITEMS.CI_TYPE_ID
PA_CONTROL_ITEMS	PA_PROJECT_STATUSES	PA_CONTROL_ITEMS.STATUS_CODE
PA_CONTROL_ITEMS	PA_PROJECT_STATUSES	PA_CONTROL_ITEMS.PROGRESS_STATUS_CODE
PA_CONTROL_ITEMS	HZ_PARTIES	PA_CONTROL_ITEMS.OWNER_ID
PA_CONTROL_ITEMS	HZ_PARTIES	PA_CONTROL_ITEMS.LAST_MODIFIED_BY_ID
PA_CONTROL_ITEMS	HZ_PARTIES	PA_CONTROL_ITEMS.CLOSED_BY_ID
PA_CONTROL_ITEMS	FND_CURRENCIES	PA_CONTROL_ITEMS.PRICE_CURRENCY_CODE
PA_BUDGET_VERSIONS	PA_CONTROL_ITEMS	PA_BUDGET_VERSIONS.CI_ID
PA_CI_ACTIONS	PA_CONTROL_ITEMS	PA_CI_ACTIONS.CI_ID
PA_CI_COMMENTS	PA_CONTROL_ITEMS	PA_CI_COMMENTS.CI_ID
PA_CI_IMPACTS	PA_CONTROL_ITEMS	PA_CI_IMPACTS.CI_ID
PA_CI_SUPPLIER_DETAILS	PA_CONTROL_ITEMS	PA_CI_SUPPLIER_DETAILS.CI_ID
PA_OBJECT_RELATIONSHIPS	PA_CONTROL_ITEMS	PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1
PA_OBJECT_RELATIONSHIPS	PA_CONTROL_ITEMS	PA_OBJECT_RELATIONSHIPS.OBJECT_ID_FROM1
PA_OBJ_STATUS_CHANGES	PA_CONTROL_ITEMS	PA_OBJ_STATUS_CHANGES.PCM_CI_ID