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_ROLLUP_TEMP

Object Details

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

This table is used to generate schedules for sets of dates in a project. Records are deleted from the table at the end of the user session.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ROLLUP_TEMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PROCESS_NUMBER OBJECT_TYPE OBJECT_ID
PA_PROJ_ROLLUP_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OBJECT_TYPE OBJECT_ID
PA_PROJ_ROLLUP_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARENT_OBJECT_TYPE PARENT_OBJECT_ID
PA_PROJ_ROLLUP_TEMP_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_NUMBER PARENT_OBJECT_TYPE PARENT_OBJECT_ID
PA_PROJ_ROLLUP_TEMP_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_NUMBER	NUMBER		Yes	Process number for genereate schedule
OBJECT_ID	NUMBER	(15)	Yes	Object id of the object to be processed
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type for the processed object
PARENT_OBJECT_ID	NUMBER	(15)		The parent id for the processed object id
PARENT_OBJECT_TYPE	VARCHAR2	(30)		The parent type for the processed object id
CALENDAR_ID	NUMBER	(15)		The calendar id for the processed object
CONSTRAINT_TYPE_CODE	VARCHAR2	(1)		The constraint type for the processed object
CONSTRAINT_DATE	DATE			The constraint date for the processed object
WBS_LEVEL	NUMBER		Yes	The WBS level for the processed object
START_DATE	DATE			The start date
START_DATE_OVERRIDE	DATE			The Override start date
FINISH_DATE	DATE			The finish date
DURATION	NUMBER			The duration
TASK_STATUS	NUMBER			The task status
PROGRESS_STATUS_WEIGHT	NUMBER			The progress status weight
PROGRESS_OVERRIDE	NUMBER			The progress status override
REMAINING_EFFORT	NUMBER			The estimated remaining effort
PERCENT_COMPLETE	NUMBER			The percent complete
PERCENT_OVERRIDE	NUMBER			The percent complete override
TASK_WEIGHT	NUMBER			The task weight
NUMBER_FIELD	NUMBER			The number field
ROLLUP_NODE	VARCHAR2	(1)		The Rollup Node flag
DIRTY_FLAG	VARCHAR2	(1)		The process dirty flag
ETC_COST	NUMBER			ETC Cost
PPL_ETC_COST	NUMBER			People ETC Cost
EQPMT_ETC_COST	NUMBER			Equipment ETC Cost
PPL_UNPLAND_EFFORT	NUMBER			People Unplanned Effort
EQPMT_ETC_EFFORT	NUMBER			Equipment ETC Effort
SUB_PRJ_ETC_COST	NUMBER			Sub Project ETC Cost
SUB_PRJ_PPL_ETC_COST	NUMBER			Sub Project People ETC Cost
SUB_PRJ_EQPMT_ETC_COST	NUMBER			Sub Project Equipment ETC Cost
SUB_PRJ_PPL_ETC_EFFORT	NUMBER			Sub Project People ETC Effort
SUB_PRJ_EQPMT_ETC_EFFORT	NUMBER			Sub Project Equipment ETC Effort
EARNED_VALUE	NUMBER			Actual or Earned Value
BAC_VALUE	NUMBER			Planned or BAC Value
PERC_COMP_DERIVATIVE_CODE	VARCHAR2	(30)		Percentage Derivative Code

Query Text

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


SELECT PROCESS_NUMBER
,      OBJECT_ID
,      OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_TYPE
,      CALENDAR_ID
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_DATE
,      WBS_LEVEL
,      START_DATE
,      START_DATE_OVERRIDE
,      FINISH_DATE
,      DURATION
,      TASK_STATUS
,      PROGRESS_STATUS_WEIGHT
,      PROGRESS_OVERRIDE
,      REMAINING_EFFORT
,      PERCENT_COMPLETE
,      PERCENT_OVERRIDE
,      TASK_WEIGHT
,      NUMBER_FIELD
,      ROLLUP_NODE
,      DIRTY_FLAG
,      ETC_COST
,      PPL_ETC_COST
,      EQPMT_ETC_COST
,      PPL_UNPLAND_EFFORT
,      EQPMT_ETC_EFFORT
,      SUB_PRJ_ETC_COST
,      SUB_PRJ_PPL_ETC_COST
,      SUB_PRJ_EQPMT_ETC_COST
,      SUB_PRJ_PPL_ETC_EFFORT
,      SUB_PRJ_EQPMT_ETC_EFFORT
,      EARNED_VALUE
,      BAC_VALUE
,      PERC_COMP_DERIVATIVE_CODE
FROM PA.PA_PROJ_ROLLUP_TEMP;

Dependencies

[top of page]

PA.PA_PROJ_ROLLUP_TEMP does not reference any database object

PA.PA_PROJ_ROLLUP_TEMP is referenced by following:

PA: PA_PROJ_ROLLUP_TEMP#