FND Design Data [Home] [Help]

Table: PA_PROJ_PERIODS_DENORM

Product: PA - Projects
Description: This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity.
Implementation/DBA Data: TablePA.PA_PROJ_PERIODS_DENORM
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_BUDGET_VERSIONS PA_PROJ_PERIODS_DENORM.BUDGET_VERSION_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_RESOURCE_ASSIGNMENTS PA_PROJ_PERIODS_DENORM.RESOURCE_ASSIGNMENT_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_RESOURCE_ASSIGNMENTS PA_PROJ_PERIODS_DENORM.OBJECT_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_ORG_FCST_ELEMENTS PA_PROJ_PERIODS_DENORM.OBJECT_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_AMOUNT_TYPES_B PA_PROJ_PERIODS_DENORM.AMOUNT_TYPE_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_AMOUNT_TYPES_B PA_PROJ_PERIODS_DENORM.AMOUNT_SUBTYPE_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_PROJECTS_ALL PA_PROJ_PERIODS_DENORM.PROJECT_ID
PA_PROJ_PERIODS_DENORM FK Joins to TablePA_RESOURCE_ASSIGNMENTS PA_PROJ_PERIODS_DENORM.PARENT_ASSIGNMENT_ID