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_OBJ_TEMP

Object Details

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

PA_PROJ_ROLLUP_OBJ_TEMP temporarily holds the data to be processed by the scheduling API

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ROLLUP_OBJ_TEMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PROCESS_NUMBER OBJECT_ID
PA_PROJ_ROLLUP_OBJ_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	OBJECT_ID
PA_PROJ_ROLLUP_OBJ_TEMP_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARENT_OBJECT_ID
PA_PROJ_ROLLUP_OBJ_TEMP_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_NUMBER PARENT_OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_NUMBER	NUMBER		Yes	Process number for generating 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	VARCHAR2	(30)		The constraint type for the processed object. For future use.
CONSTRAINT_DATE	DATE			The constraint date for the processed object. For future use.
WBS_LEVEL	NUMBER		Yes	The WBS level for the processed object
START_DATE1	DATE			The start date for the date set 1
FINISH_DATE1	DATE			The finish date for the date set 1
DURATION1	NUMBER			The duration for the date set 1
TASK_STATUS1	NUMBER			The task status for the date set 1
PROGRESS_STATUS_WEIGHT1	NUMBER			The progress status weight for the date set 1
PROGRESS_OVERRIDE1	NUMBER			The progress status override for the date set 1
REMAINING_EFFORT1	NUMBER			The estimated remaining effort for the date set 1
PERCENT_COMPLETE1	NUMBER			The percent complete for the date set 1
PERCENT_OVERRIDE1	NUMBER			The percent complete override for the date set 1
TASK_WEIGHT1	NUMBER			The task weight for the date set 1
NUMBER_FIELD1	NUMBER			The number field for the date set 1
ROLLUP_NODE1_FLAG	VARCHAR2	(1)		The process status flag for the date set 1
DIRTY1_FLAG	VARCHAR2	(1)		The process status flag for the date set 1
START_DATE2	DATE			The start date for the date set 2
FINISH_DATE2	DATE			The finish date for the date set 2
DURATION2	NUMBER			The duration for the date set 2
TASK_STATUS2	NUMBER			The task status for the date set 2
PROGRESS_STATUS_WEIGHT2	NUMBER			The progress status weight for the date set 2
PROGRESS_OVERRIDE2	NUMBER			The progress status override for the date set 2
REMAINING_EFFORT2	NUMBER			The estimated remaining effort for the date set 2
PERCENT_COMPLETE2	NUMBER			The percent complete for the date set 2
PERCENT_OVERRIDE2	NUMBER			The percent complete override for the date set 2
TASK_WEIGHT2	NUMBER			The task weight for the date set 2
NUMBER_FIELD2	NUMBER			The number field for the date set 2
ROLLUP_NODE2_FLAG	VARCHAR2	(1)		The process status flag for the date set 2
DIRTY2_FLAG	VARCHAR2	(1)		The process status flag for the date set 2
START_DATE3	DATE			The start date for the date set 3
FINISH_DATE3	DATE			The finish date for the date set 3
DURATION3	NUMBER			The duration for the date set 3
TASK_STATUS3	NUMBER			The task status for the date set 3
PROGRESS_STATUS_WEIGHT3	NUMBER			The progress status weight for the date set 3
PROGRESS_OVERRIDE3	NUMBER			The progress status override for the date set 3
REMAINING_EFFORT3	NUMBER			The estimated remaining effort for the date set 3
PERCENT_COMPLETE3	NUMBER			The percent complete for the date set 3
PERCENT_OVERRIDE3	NUMBER			The percent complete override for the date set 3
TASK_WEIGHT3	NUMBER			The task weight for the date set 3
NUMBER_FIELD3	NUMBER			The number field for the date set 3
ROLLUP_NODE3_FLAG	VARCHAR2	(1)		The process status flag for the date set 3
DIRTY3_FLAG	VARCHAR2	(1)		The process status flag for the date set 3
START_DATE4	DATE			The start date for the date set 4
FINISH_DATE4	DATE			The finish date for the date set 4
DURATION4	NUMBER			The duration for the date set 4
TASK_STATUS4	NUMBER			The task status for the date set 4
PROGRESS_STATUS_WEIGHT4	NUMBER			The progress status weight for the date set 4
PROGRESS_OVERRIDE4	NUMBER			The progress status override for the date set 4
REMAINING_EFFORT4	NUMBER			The estimated remaining effort for the date set 4
PERCENT_COMPLETE4	NUMBER			The percent complete for the date set 4
PERCENT_OVERRIDE4	NUMBER			The percent complete override for the date set 4
TASK_WEIGHT4	NUMBER			The task weight for the date set 4
NUMBER_FIELD4	NUMBER			The number field for the date set 4
ROLLUP_NODE4_FLAG	VARCHAR2	(1)		The process status flag for the date set 4
DIRTY4_FLAG	VARCHAR2	(1)		The process status flag for the date set 4
START_DATE5	DATE			The start date for the date set 5
FINISH_DATE5	DATE			The finish date for the date set 5
DURATION5	NUMBER			The duration for the date set 5
TASK_STATUS5	NUMBER			The task status for the date set 5
PROGRESS_STATUS_WEIGHT5	NUMBER			The progress status weight for the date set 5
PROGRESS_OVERRIDE5	NUMBER			The progress status override for the date set 5
REMAINING_EFFORT5	NUMBER			The estimated remaining effort for the date set 5
PERCENT_COMPLETE5	NUMBER			The percent complete for the date set 5
PERCENT_OVERRIDE5	NUMBER			The percent complete override for the date set 5
TASK_WEIGHT5	NUMBER			The task weight for the date set 5
NUMBER_FIELD5	NUMBER			The number field for the date set 5
ROLLUP_NODE5_FLAG	VARCHAR2	(1)		The process status flag for the date set 5
DIRTY5_FLAG	VARCHAR2	(1)		The process status flag for the date set 5
START_DATE6	DATE			The start date for the date set 6
FINISH_DATE6	DATE			The finish date for the date set 6
DURATION6	NUMBER			The duration for the date set 6
TASK_STATUS6	NUMBER			The task status for the date set 6
PROGRESS_STATUS_WEIGHT6	NUMBER			The progress status weight for the date set 6
PROGRESS_OVERRIDE6	NUMBER			The progress status override for the date set 6
REMAINING_EFFORT6	NUMBER			The estimated remaining effort for the date set 6
PERCENT_COMPLETE6	NUMBER			The percent complete for the date set 6
PERCENT_OVERRIDE6	NUMBER			The percent complete override for the date set 6
TASK_WEIGHT6	NUMBER			The task weight for the date set 6
NUMBER_FIELD6	NUMBER			The number field for the date set 6
ROLLUP_NODE6_FLAG	VARCHAR2	(1)		The process status flag for the date set 6
DIRTY6_FLAG	VARCHAR2	(1)		The process status flag for the date set 6

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
,      CONSTRAINT_DATE
,      WBS_LEVEL
,      START_DATE1
,      FINISH_DATE1
,      DURATION1
,      TASK_STATUS1
,      PROGRESS_STATUS_WEIGHT1
,      PROGRESS_OVERRIDE1
,      REMAINING_EFFORT1
,      PERCENT_COMPLETE1
,      PERCENT_OVERRIDE1
,      TASK_WEIGHT1
,      NUMBER_FIELD1
,      ROLLUP_NODE1_FLAG
,      DIRTY1_FLAG
,      START_DATE2
,      FINISH_DATE2
,      DURATION2
,      TASK_STATUS2
,      PROGRESS_STATUS_WEIGHT2
,      PROGRESS_OVERRIDE2
,      REMAINING_EFFORT2
,      PERCENT_COMPLETE2
,      PERCENT_OVERRIDE2
,      TASK_WEIGHT2
,      NUMBER_FIELD2
,      ROLLUP_NODE2_FLAG
,      DIRTY2_FLAG
,      START_DATE3
,      FINISH_DATE3
,      DURATION3
,      TASK_STATUS3
,      PROGRESS_STATUS_WEIGHT3
,      PROGRESS_OVERRIDE3
,      REMAINING_EFFORT3
,      PERCENT_COMPLETE3
,      PERCENT_OVERRIDE3
,      TASK_WEIGHT3
,      NUMBER_FIELD3
,      ROLLUP_NODE3_FLAG
,      DIRTY3_FLAG
,      START_DATE4
,      FINISH_DATE4
,      DURATION4
,      TASK_STATUS4
,      PROGRESS_STATUS_WEIGHT4
,      PROGRESS_OVERRIDE4
,      REMAINING_EFFORT4
,      PERCENT_COMPLETE4
,      PERCENT_OVERRIDE4
,      TASK_WEIGHT4
,      NUMBER_FIELD4
,      ROLLUP_NODE4_FLAG
,      DIRTY4_FLAG
,      START_DATE5
,      FINISH_DATE5
,      DURATION5
,      TASK_STATUS5
,      PROGRESS_STATUS_WEIGHT5
,      PROGRESS_OVERRIDE5
,      REMAINING_EFFORT5
,      PERCENT_COMPLETE5
,      PERCENT_OVERRIDE5
,      TASK_WEIGHT5
,      NUMBER_FIELD5
,      ROLLUP_NODE5_FLAG
,      DIRTY5_FLAG
,      START_DATE6
,      FINISH_DATE6
,      DURATION6
,      TASK_STATUS6
,      PROGRESS_STATUS_WEIGHT6
,      PROGRESS_OVERRIDE6
,      REMAINING_EFFORT6
,      PERCENT_COMPLETE6
,      PERCENT_OVERRIDE6
,      TASK_WEIGHT6
,      NUMBER_FIELD6
,      ROLLUP_NODE6_FLAG
,      DIRTY6_FLAG
FROM PA.PA_PROJ_ROLLUP_OBJ_TEMP;

Dependencies

[top of page]

PA.PA_PROJ_ROLLUP_OBJ_TEMP does not reference any database object

PA.PA_PROJ_ROLLUP_OBJ_TEMP is referenced by following:

PA: PA_PROJ_ROLLUP_OBJ_TEMP#