FND Design Data [Home] [Help]

Table: PA_PROJECT_ASSET_ASSIGNMENTS

Product: PA - Projects
Description: Relationship between projects or tasks and assets used to summarize CIP costs
Implementation/DBA Data: TablePA.PA_PROJECT_ASSET_ASSIGNMENTS
Primary Key: PA_PROJECT_ASSET_ASSIGN_PK
  1. ColumnPROJECT_ID
  2. ColumnTASK_ID
  3. ColumnPROJECT_ASSET_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJECT_ASSET_ASSIGNMENTS FK Joins to TablePA_PROJECT_ASSETS_ALL PA_PROJECT_ASSET_ASSIGNMENTS.PROJECT_ASSET_ID
PA_PROJECT_ASSET_ASSIGNMENTS FK Joins to TablePA_PROJECTS_ALL PA_PROJECT_ASSET_ASSIGNMENTS.PROJECT_ID
PA_PROJECT_ASSET_ASSIGNMENTS FK Joins to TablePA_TASKS PA_PROJECT_ASSET_ASSIGNMENTS.TASK_ID