Skip to content

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

VIEW: PA.PA_PROJ_ROLLUP_OBJ_TEMP#

Object Details
Object Name: PA_PROJ_ROLLUP_OBJ_TEMP#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROCESS_NUMBER NUMBER
Yes
OBJECT_ID NUMBER (15) Yes
OBJECT_TYPE VARCHAR2 (30) Yes
PARENT_OBJECT_ID NUMBER (15)
PARENT_OBJECT_TYPE VARCHAR2 (30)
CALENDAR_ID NUMBER (15)
CONSTRAINT_TYPE VARCHAR2 (30)
CONSTRAINT_DATE DATE

WBS_LEVEL NUMBER
Yes
START_DATE1 DATE

FINISH_DATE1 DATE

DURATION1 NUMBER

TASK_STATUS1 NUMBER

PROGRESS_STATUS_WEIGHT1 NUMBER

PROGRESS_OVERRIDE1 NUMBER

REMAINING_EFFORT1 NUMBER

PERCENT_COMPLETE1 NUMBER

PERCENT_OVERRIDE1 NUMBER

TASK_WEIGHT1 NUMBER

NUMBER_FIELD1 NUMBER

ROLLUP_NODE1_FLAG VARCHAR2 (1)
DIRTY1_FLAG VARCHAR2 (1)
START_DATE2 DATE

FINISH_DATE2 DATE

DURATION2 NUMBER

TASK_STATUS2 NUMBER

PROGRESS_STATUS_WEIGHT2 NUMBER

PROGRESS_OVERRIDE2 NUMBER

REMAINING_EFFORT2 NUMBER

PERCENT_COMPLETE2 NUMBER

PERCENT_OVERRIDE2 NUMBER

TASK_WEIGHT2 NUMBER

NUMBER_FIELD2 NUMBER

ROLLUP_NODE2_FLAG VARCHAR2 (1)
DIRTY2_FLAG VARCHAR2 (1)
START_DATE3 DATE

FINISH_DATE3 DATE

DURATION3 NUMBER

TASK_STATUS3 NUMBER

PROGRESS_STATUS_WEIGHT3 NUMBER

PROGRESS_OVERRIDE3 NUMBER

REMAINING_EFFORT3 NUMBER

PERCENT_COMPLETE3 NUMBER

PERCENT_OVERRIDE3 NUMBER

TASK_WEIGHT3 NUMBER

NUMBER_FIELD3 NUMBER

ROLLUP_NODE3_FLAG VARCHAR2 (1)
DIRTY3_FLAG VARCHAR2 (1)
START_DATE4 DATE

FINISH_DATE4 DATE

DURATION4 NUMBER

TASK_STATUS4 NUMBER

PROGRESS_STATUS_WEIGHT4 NUMBER

PROGRESS_OVERRIDE4 NUMBER

REMAINING_EFFORT4 NUMBER

PERCENT_COMPLETE4 NUMBER

PERCENT_OVERRIDE4 NUMBER

TASK_WEIGHT4 NUMBER

NUMBER_FIELD4 NUMBER

ROLLUP_NODE4_FLAG VARCHAR2 (1)
DIRTY4_FLAG VARCHAR2 (1)
START_DATE5 DATE

FINISH_DATE5 DATE

DURATION5 NUMBER

TASK_STATUS5 NUMBER

PROGRESS_STATUS_WEIGHT5 NUMBER

PROGRESS_OVERRIDE5 NUMBER

REMAINING_EFFORT5 NUMBER

PERCENT_COMPLETE5 NUMBER

PERCENT_OVERRIDE5 NUMBER

TASK_WEIGHT5 NUMBER

NUMBER_FIELD5 NUMBER

ROLLUP_NODE5_FLAG VARCHAR2 (1)
DIRTY5_FLAG VARCHAR2 (1)
START_DATE6 DATE

FINISH_DATE6 DATE

DURATION6 NUMBER

TASK_STATUS6 NUMBER

PROGRESS_STATUS_WEIGHT6 NUMBER

PROGRESS_OVERRIDE6 NUMBER

REMAINING_EFFORT6 NUMBER

PERCENT_COMPLETE6 NUMBER

PERCENT_OVERRIDE6 NUMBER

TASK_WEIGHT6 NUMBER

NUMBER_FIELD6 NUMBER

ROLLUP_NODE6_FLAG VARCHAR2 (1)
DIRTY6_FLAG VARCHAR2 (1)
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# references the following:

SchemaPA
TablePA_PROJ_ROLLUP_OBJ_TEMP
PA.PA_PROJ_ROLLUP_OBJ_TEMP# is referenced by following:

SchemaAPPS
SynonymPA_PROJ_ROLLUP_OBJ_TEMP