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]

VIEW: PA.PA_PROJ_ROLLUP_TEMP#

Object Details

Object Name:	PA_PROJ_ROLLUP_TEMP#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

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# references the following:

PA: PA_PROJ_ROLLUP_TEMP

PA.PA_PROJ_ROLLUP_TEMP# is referenced by following:

APPS: PA_PROJ_ROLLUP_TEMP