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_SCHEDULE_OBJECTS

Object Details

Object Name:	PA_SCHEDULE_OBJECTS
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

Temporary Table Details

PA.PA_SCHEDULE_OBJECTS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
PA_SCHEDULE_OBJECTS_N1	NORMAL	NONUNIQUE	OBJECT_ID
PA_SCHEDULE_OBJECTS_N2	NORMAL	NONUNIQUE	PARENT_OBJECT_ID
PA_SCHEDULE_OBJECTS_N3	NORMAL	NONUNIQUE	PROCESS_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_NUMBER	NUMBER		Yes	Process number for genereate schedule
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type for the processed object
OBJECT_ID	NUMBER		Yes	Object id of the object to be processed
PARENT_OBJECT_TYPE	VARCHAR2	(30)		The parent type for the processed object id
PARENT_OBJECT_ID	NUMBER			The parent id for the processed object id
CALENDAR_ID	NUMBER			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_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
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	VARCHAR2	(1)		The process status flag for the date set 1
DIRTY_FLAG1	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
PROGRESS_STATUS_WEIGHT2	NUMBER			The progress status weight 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
TASK_WEIGHT2	NUMBER			The task weight for the date set 2
NUMBER_FIELD2	NUMBER			The number field for the date set 2
ROLLUP_NODE2	VARCHAR2	(1)		The process status flag for the date set 2
DIRTY_FLAG2	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
PROGRESS_STATUS_WEIGHT3	NUMBER			The progress status weight 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
TASK_WEIGHT3	NUMBER			The task weight for the date set 3
NUMBER_FIELD3	NUMBER			The number field for the date set 3
ROLLUP_NODE3	VARCHAR2	(1)		The process status flag for the date set 3
DIRTY_FLAG3	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
PROGRESS_STATUS_WEIGHT4	NUMBER			The progress status weight 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
TASK_WEIGHT4	NUMBER			The task weight for the date set 4
NUMBER_FIELD4	NUMBER			The number field for the date set 4
ROLLUP_NODE4	VARCHAR2	(1)		The process status flag for the date set 4
DIRTY_FLAG4	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
PROGRESS_STATUS_WEIGHT5	NUMBER			The progress status weight 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
TASK_WEIGHT5	NUMBER			The task weight for the date set 5
NUMBER_FIELD5	NUMBER			The number field for the date set 5
ROLLUP_NODE5	VARCHAR2	(1)		The process status flag for the date set 5
DIRTY_FLAG5	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
PROGRESS_STATUS_WEIGHT6	NUMBER			The progress status weight 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
TASK_WEIGHT6	NUMBER			The task weight for the date set 6
NUMBER_FIELD6	NUMBER			The number field for the date set 6
ROLLUP_NODE6	VARCHAR2	(1)		The process status flag for the date set 6
DIRTY_FLAG6	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_TYPE
,      OBJECT_ID
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      CALENDAR_ID
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_DATE
,      WBS_LEVEL
,      START_DATE1
,      FINISH_DATE1
,      DURATION1
,      PROGRESS_STATUS_WEIGHT1
,      PROGRESS_OVERRIDE1
,      REMAINING_EFFORT1
,      PERCENT_COMPLETE1
,      PERCENT_OVERRIDE1
,      TASK_WEIGHT1
,      NUMBER_FIELD1
,      ROLLUP_NODE1
,      DIRTY_FLAG1
,      START_DATE2
,      FINISH_DATE2
,      DURATION2
,      PROGRESS_STATUS_WEIGHT2
,      REMAINING_EFFORT2
,      PERCENT_COMPLETE2
,      TASK_WEIGHT2
,      NUMBER_FIELD2
,      ROLLUP_NODE2
,      DIRTY_FLAG2
,      START_DATE3
,      FINISH_DATE3
,      DURATION3
,      PROGRESS_STATUS_WEIGHT3
,      REMAINING_EFFORT3
,      PERCENT_COMPLETE3
,      TASK_WEIGHT3
,      NUMBER_FIELD3
,      ROLLUP_NODE3
,      DIRTY_FLAG3
,      START_DATE4
,      FINISH_DATE4
,      DURATION4
,      PROGRESS_STATUS_WEIGHT4
,      REMAINING_EFFORT4
,      PERCENT_COMPLETE4
,      TASK_WEIGHT4
,      NUMBER_FIELD4
,      ROLLUP_NODE4
,      DIRTY_FLAG4
,      START_DATE5
,      FINISH_DATE5
,      DURATION5
,      PROGRESS_STATUS_WEIGHT5
,      REMAINING_EFFORT5
,      PERCENT_COMPLETE5
,      TASK_WEIGHT5
,      NUMBER_FIELD5
,      ROLLUP_NODE5
,      DIRTY_FLAG5
,      START_DATE6
,      FINISH_DATE6
,      DURATION6
,      PROGRESS_STATUS_WEIGHT6
,      REMAINING_EFFORT6
,      PERCENT_COMPLETE6
,      TASK_WEIGHT6
,      NUMBER_FIELD6
,      ROLLUP_NODE6
,      DIRTY_FLAG6
FROM PA.PA_SCHEDULE_OBJECTS;

Dependencies

[top of page]

PA.PA_SCHEDULE_OBJECTS does not reference any database object

PA.PA_SCHEDULE_OBJECTS is referenced by following:

APPS: PA_SCHEDULE_OBJECTS