FND Design Data [Home] [Help]

Table: PA_PROJ_ELEMENTS

Product: PA - Projects
Description: PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use
Implementation/DBA Data: TablePA.PA_PROJ_ELEMENTS
Primary Key: PA_PROJ_ELEMENTS_PK
  1. ColumnPROJ_ELEMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJ_ELEMENTS FK Joins to TablePA_PROJECTS_ALL PA_PROJ_ELEMENTS.PROJECT_ID
PA_PROJ_ELEMENTS FK Joins to TablePA_PROJ_ELEMENT_VERSIONS PA_PROJ_ELEMENTS.PHASE_VERSION_ID
PA_PROJ_ELEMENTS FK Joins to TablePA_PROJECT_STATUSES PA_PROJ_ELEMENTS.PHASE_CODE
PA_PROJ_ELEMENTS FK Joins to TablePA_LOCATIONS PA_PROJ_ELEMENTS.LOCATION_ID
PA_PROJ_ELEMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID
PA_PROJ_ELEMENTS FK Joins to TablePA_PAGE_LAYOUTS PA_PROJ_ELEMENTS.TASK_PROGRESS_ENTRY_PAGE_ID
PA_PROJ_ELEMENTS FK Joins to TablePA_PROJ_ELEMENTS PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID
PA_PROJ_ELEMENTS FK Joins to TablePA_TASK_TYPES PA_PROJ_ELEMENTS.TYPE_ID
TablePA_LIFECYCLE_USAGES FK Joins to PA_PROJ_ELEMENTS PA_LIFECYCLE_USAGES.LIFECYCLE_ID
TablePA_PERCENT_COMPLETES FK Joins to PA_PROJ_ELEMENTS PA_PERCENT_COMPLETES.OBJECT_ID
TablePA_PROGRESS_ROLLUP FK Joins to PA_PROJ_ELEMENTS PA_PROGRESS_ROLLUP.OBJECT_ID
TablePA_PROGRESS_ROLLUP FK Joins to PA_PROJ_ELEMENTS PA_PROGRESS_ROLLUP.PROJ_ELEMENT_ID
TablePA_PROJECTS_ERP_EXT_B FK Joins to PA_PROJ_ELEMENTS PA_PROJECTS_ERP_EXT_B.PROJ_ELEMENT_ID
TablePA_PROJECTS_ERP_EXT_TL FK Joins to PA_PROJ_ELEMENTS PA_PROJECTS_ERP_EXT_TL.PROJ_ELEMENT_ID
TablePA_PROJ_ELEMENTS FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID
TablePA_PROJ_ELEMENT_VERSIONS FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID
TablePA_PROJ_ELEM_VER_SCHEDULE FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID
TablePA_PROJ_ELEM_VER_STRUCTURE FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ELEM_VER_STRUCTURE.PROJ_ELEMENT_ID
TablePA_PROJ_PROGRESS_ATTR FK Joins to PA_PROJ_ELEMENTS PA_PROJ_PROGRESS_ATTR.OBJECT_ID
TablePA_PROJ_ROLLUP_OBJ_TEMP FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ROLLUP_OBJ_TEMP.OBJECT_ID
TablePA_PROJ_ROLLUP_OBJ_TEMP FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ROLLUP_OBJ_TEMP.PARENT_OBJECT_ID
TablePA_PROJ_ROLLUP_TEMP FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ROLLUP_TEMP.OBJECT_ID
TablePA_PROJ_ROLLUP_TEMP FK Joins to PA_PROJ_ELEMENTS PA_PROJ_ROLLUP_TEMP.PARENT_OBJECT_ID
TablePA_PROJ_STRUCTURE_TYPES FK Joins to PA_PROJ_ELEMENTS PA_PROJ_STRUCTURE_TYPES.PROJ_ELEMENT_ID
TablePA_PROJ_WORKPLAN_ATTR FK Joins to PA_PROJ_ELEMENTS PA_PROJ_WORKPLAN_ATTR.PROJ_ELEMENT_ID
TablePA_RESOURCE_ASSIGNMENTS FK Joins to PA_PROJ_ELEMENTS PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID
TablePA_XBS_DENORM FK Joins to PA_PROJ_ELEMENTS PA_XBS_DENORM.SUP_ID
TablePA_XBS_DENORM FK Joins to PA_PROJ_ELEMENTS PA_XBS_DENORM.SUB_ID
TablePJI_AC_XBS_ACCUM_F FK Joins to PA_PROJ_ELEMENTS PJI_AC_XBS_ACCUM_F.PROJECT_ELEMENT_ID
TablePJI_FM_EXTR_PLAN_LINES FK Joins to PA_PROJ_ELEMENTS PJI_FM_EXTR_PLAN_LINES.PROJECT_ELEMENT_ID
TablePJI_FP_XBS_ACCUM_F FK Joins to PA_PROJ_ELEMENTS PJI_FP_XBS_ACCUM_F.PROJECT_ELEMENT_ID