[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_ROLLUP_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
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_CODE | VARCHAR2 | (1) | ||
CONSTRAINT_DATE | DATE | |||
WBS_LEVEL | NUMBER | Yes | ||
START_DATE | DATE | |||
START_DATE_OVERRIDE | DATE | |||
FINISH_DATE | DATE | |||
DURATION | NUMBER | |||
TASK_STATUS | NUMBER | |||
PROGRESS_STATUS_WEIGHT | NUMBER | |||
PROGRESS_OVERRIDE | NUMBER | |||
REMAINING_EFFORT | NUMBER | |||
PERCENT_COMPLETE | NUMBER | |||
PERCENT_OVERRIDE | NUMBER | |||
TASK_WEIGHT | NUMBER | |||
NUMBER_FIELD | NUMBER | |||
ROLLUP_NODE | VARCHAR2 | (1) | ||
DIRTY_FLAG | VARCHAR2 | (1) | ||
ETC_COST | NUMBER | |||
PPL_ETC_COST | NUMBER | |||
EQPMT_ETC_COST | NUMBER | |||
PPL_UNPLAND_EFFORT | NUMBER | |||
EQPMT_ETC_EFFORT | NUMBER | |||
SUB_PRJ_ETC_COST | NUMBER | |||
SUB_PRJ_PPL_ETC_COST | NUMBER | |||
SUB_PRJ_EQPMT_ETC_COST | NUMBER | |||
SUB_PRJ_PPL_ETC_EFFORT | NUMBER | |||
SUB_PRJ_EQPMT_ETC_EFFORT | NUMBER | |||
EARNED_VALUE | NUMBER | |||
BAC_VALUE | NUMBER | |||
PERC_COMP_DERIVATIVE_CODE | VARCHAR2 | (30) |
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#;
|
|
|