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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_PROJ_PERIODS_DENORM

Object Details

Object Name:	PA_PROJ_PERIODS_DENORM
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJ_PERIODS_DENORM
Subobject Name:
Status:	VALID

This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity. Plan amounts for different levels are held in the 52 period buckets that is used to report the plans in a matrix format. One row is held for every amount type (like Raw Cost, Burdened Cost).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_PERIODS_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID RESOURCE_ASSIGNMENT_ID OBJECT_TYPE_CODE OBJECT_ID CURRENCY_TYPE CURRENCY_CODE AMOUNT_TYPE_CODE AMOUNT_SUBTYPE_CODE
PA_PROJ_PERIODS_DENORM_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ASSIGNMENT_ID CURRENCY_TYPE AMOUNT_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	Identifier of the Plan Version
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the Project that the plan belongs to
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier of the resource assignment
OBJECT_ID	NUMBER	(15)	Yes	Identifier of the object for which such denormalized plan amounts are held. Examples would be forecast element id and fin_plan_adj_line_id
OBJECT_TYPE_CODE	VARCHAR2	(30)	Yes	Stores the Object Type Code
PERIOD_PROFILE_ID	NUMBER	(15)	Yes	Indicates the period profile to which this denormalized amounts correspond to
AMOUNT_TYPE_CODE	VARCHAR2	(30)	Yes	Stores the Amount Type Code
AMOUNT_SUBTYPE_CODE	VARCHAR2	(30)	Yes	Stores the component of the Amount Type Code
AMOUNT_TYPE_ID	NUMBER	(15)	Yes	Stores the Amount Type ID
AMOUNT_SUBTYPE_ID	NUMBER	(15)	Yes	Stores the Amount Subtype ID
CURRENCY_TYPE	VARCHAR2	(30)	Yes	Stores the Currency Type
CURRENCY_CODE	VARCHAR2	(15)	Yes	Stores the currency code
PRECEDING_PERIODS_AMOUNT	NUMBER			Stores the preceding periods amount
SUCCEEDING_PERIODS_AMOUNT	NUMBER			Stores the succeeding periods amount
PRIOR_PERIOD_AMOUNT	NUMBER			Stores the Prior periods amount
PERIOD_AMOUNT1	NUMBER			Stores the period amount
PERIOD_AMOUNT2	NUMBER			Stores the period amount
PERIOD_AMOUNT3	NUMBER			Stores the period amount
PERIOD_AMOUNT4	NUMBER			Stores the period amount
PERIOD_AMOUNT5	NUMBER			Stores the period amount
PERIOD_AMOUNT6	NUMBER			Stores the period amount
PERIOD_AMOUNT7	NUMBER			Stores the period amount
PERIOD_AMOUNT8	NUMBER			Stores the period amount
PERIOD_AMOUNT9	NUMBER			Stores the period amount
PERIOD_AMOUNT10	NUMBER			Stores the period amount
PERIOD_AMOUNT11	NUMBER			Stores the period amount
PERIOD_AMOUNT12	NUMBER			Stores the period amount
PERIOD_AMOUNT13	NUMBER			Stores the period amount
PERIOD_AMOUNT14	NUMBER			Stores the period amount
PERIOD_AMOUNT15	NUMBER			Stores the period amount
PERIOD_AMOUNT16	NUMBER			Stores the period amount
PERIOD_AMOUNT17	NUMBER			Stores the period amount
PERIOD_AMOUNT18	NUMBER			Stores the period amount
PERIOD_AMOUNT19	NUMBER			Stores the period amount
PERIOD_AMOUNT20	NUMBER			Stores the period amount
PERIOD_AMOUNT21	NUMBER			Stores the period amount
PERIOD_AMOUNT22	NUMBER			Stores the period amount
PERIOD_AMOUNT23	NUMBER			Stores the period amount
PERIOD_AMOUNT24	NUMBER			Stores the period amount
PERIOD_AMOUNT25	NUMBER			Stores the period amount
PERIOD_AMOUNT26	NUMBER			Stores the period amount
PERIOD_AMOUNT27	NUMBER			Stores the period amount
PERIOD_AMOUNT28	NUMBER			Stores the period amount
PERIOD_AMOUNT29	NUMBER			Stores the period amount
PERIOD_AMOUNT30	NUMBER			Stores the period amount
PERIOD_AMOUNT31	NUMBER			Stores the period amount
PERIOD_AMOUNT32	NUMBER			Stores the period amount
PERIOD_AMOUNT33	NUMBER			Stores the period amount
PERIOD_AMOUNT34	NUMBER			Stores the period amount
PERIOD_AMOUNT35	NUMBER			Stores the period amount
PERIOD_AMOUNT36	NUMBER			Stores the period amount
PERIOD_AMOUNT37	NUMBER			Stores the period amount
PERIOD_AMOUNT38	NUMBER			Stores the period amount
PERIOD_AMOUNT39	NUMBER			Stores the period amount
PERIOD_AMOUNT40	NUMBER			Stores the period amount
PERIOD_AMOUNT41	NUMBER			Stores the period amount
PERIOD_AMOUNT42	NUMBER			Stores the period amount
PERIOD_AMOUNT43	NUMBER			Stores the period amount
PERIOD_AMOUNT44	NUMBER			Stores the period amount
PERIOD_AMOUNT45	NUMBER			Stores the period amount
PERIOD_AMOUNT46	NUMBER			Stores the period amount
PERIOD_AMOUNT47	NUMBER			Stores the period amount
PERIOD_AMOUNT48	NUMBER			Stores the period amount
PERIOD_AMOUNT49	NUMBER			Stores the period amount
PERIOD_AMOUNT50	NUMBER			Stores the period amount
PERIOD_AMOUNT51	NUMBER			Stores the period amount
PERIOD_AMOUNT52	NUMBER			Stores the period amount
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
PARENT_ASSIGNMENT_ID	NUMBER	(15)		Unique identifier of the parent resource assignment

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      RESOURCE_ASSIGNMENT_ID
,      OBJECT_ID
,      OBJECT_TYPE_CODE
,      PERIOD_PROFILE_ID
,      AMOUNT_TYPE_CODE
,      AMOUNT_SUBTYPE_CODE
,      AMOUNT_TYPE_ID
,      AMOUNT_SUBTYPE_ID
,      CURRENCY_TYPE
,      CURRENCY_CODE
,      PRECEDING_PERIODS_AMOUNT
,      SUCCEEDING_PERIODS_AMOUNT
,      PRIOR_PERIOD_AMOUNT
,      PERIOD_AMOUNT1
,      PERIOD_AMOUNT2
,      PERIOD_AMOUNT3
,      PERIOD_AMOUNT4
,      PERIOD_AMOUNT5
,      PERIOD_AMOUNT6
,      PERIOD_AMOUNT7
,      PERIOD_AMOUNT8
,      PERIOD_AMOUNT9
,      PERIOD_AMOUNT10
,      PERIOD_AMOUNT11
,      PERIOD_AMOUNT12
,      PERIOD_AMOUNT13
,      PERIOD_AMOUNT14
,      PERIOD_AMOUNT15
,      PERIOD_AMOUNT16
,      PERIOD_AMOUNT17
,      PERIOD_AMOUNT18
,      PERIOD_AMOUNT19
,      PERIOD_AMOUNT20
,      PERIOD_AMOUNT21
,      PERIOD_AMOUNT22
,      PERIOD_AMOUNT23
,      PERIOD_AMOUNT24
,      PERIOD_AMOUNT25
,      PERIOD_AMOUNT26
,      PERIOD_AMOUNT27
,      PERIOD_AMOUNT28
,      PERIOD_AMOUNT29
,      PERIOD_AMOUNT30
,      PERIOD_AMOUNT31
,      PERIOD_AMOUNT32
,      PERIOD_AMOUNT33
,      PERIOD_AMOUNT34
,      PERIOD_AMOUNT35
,      PERIOD_AMOUNT36
,      PERIOD_AMOUNT37
,      PERIOD_AMOUNT38
,      PERIOD_AMOUNT39
,      PERIOD_AMOUNT40
,      PERIOD_AMOUNT41
,      PERIOD_AMOUNT42
,      PERIOD_AMOUNT43
,      PERIOD_AMOUNT44
,      PERIOD_AMOUNT45
,      PERIOD_AMOUNT46
,      PERIOD_AMOUNT47
,      PERIOD_AMOUNT48
,      PERIOD_AMOUNT49
,      PERIOD_AMOUNT50
,      PERIOD_AMOUNT51
,      PERIOD_AMOUNT52
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PARENT_ASSIGNMENT_ID
FROM PA.PA_PROJ_PERIODS_DENORM;

Dependencies

[top of page]

PA.PA_PROJ_PERIODS_DENORM does not reference any database object

PA.PA_PROJ_PERIODS_DENORM is referenced by following:

PA: PA_PROJ_PERIODS_DENORM#