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_PERCENT_COMPLETES

Object Details

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

PA_PERCENT_COMPLETES stores estimated percentage
completions of lowest level tasks at a point in time
that users determine. Oracle Projects does
not calculate these values, and it uses these
percentage completion values for reporting purposes
only.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PERCENT_COMPLETES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERCENT_COMPLETE_ID
PA_PERCENT_COMPLETES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID STRUCTURE_TYPE DATE_COMPUTED
PA_PERCENT_COMPLETES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID STRUCTURE_TYPE CURRENT_FLAG
PA_PERCENT_COMPLETES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE STRUCTURE_TYPE PROJECT_ID TASK_ID PUBLISHED_FLAG
PA_PERCENT_COMPLETES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PUBLISHED_BY_PARTY_ID
PA_PERCENT_COMPLETES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_VERSION_ID PROJECT_ID
PA_PERCENT_COMPLETES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID OBJECT_ID OBJECT_TYPE STRUCTURE_TYPE PUBLISHED_FLAG DATE_COMPUTED

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of project for which the percent complete information is entered
TASK_ID	NUMBER	(15)	Yes	The identifier of the lowest level task for which the work is estimated by the percent completion
DATE_COMPUTED	DATE		Yes	The date on which the percentage of work is complete
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
COMPLETED_PERCENTAGE	NUMBER			The percentage of work complete on the task
DESCRIPTION	VARCHAR2	(250)		Description of the work completed
PM_PRODUCT_CODE	VARCHAR2	(30)		The code identifying the external Project Management tool
CURRENT_FLAG	VARCHAR2	(1)	Yes	The flag indicating whether the row is current or not
PERCENT_COMPLETE_ID	NUMBER	(15)		Percent_complete_id generated in sequence from pa_percent_completes_s
OBJECT_ID	NUMBER	(15)		Identifier of the object
OBJECT_VERSION_ID	NUMBER	(15)		Identifier of the object version
OBJECT_TYPE	VARCHAR2	(30)		Type of the object . For example 'PA_TASKS' or 'PA_STRUCTURES'
STATUS_CODE	VARCHAR2	(150)		Life cycle status code of the object
PROGRESS_STATUS_CODE	VARCHAR2	(150)		Progress Status code of the object
ESTIMATED_START_DATE	DATE			Estimated Start Date of the object
ESTIMATED_FINISH_DATE	DATE			Estimated Finish Date of the object
ACTUAL_START_DATE	DATE			Actual Start Date of the object
ACTUAL_FINISH_DATE	DATE			Actual Finish Date of the object
PUBLISHED_FLAG	VARCHAR2	(1)		Flag indicating whether the progress record is published
PUBLISHED_BY_PARTY_ID	NUMBER	(15)		Identifier of the person who published the progress record
RECORD_VERSION_NUMBER	NUMBER			Number used for record locking in self service applications
PROGRESS_COMMENT	VARCHAR2	(4000)		Progress comment
HISTORY_FLAG	VARCHAR2	(1)		Flag to indicate whether or not the record existed before upgrading to the new progress model
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
STRUCTURE_TYPE	VARCHAR2	(30)		Structure Type
CBS_ELEMENT_ID	NUMBER	(15)		This is the unique identifier of the cost code element.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      TASK_ID
,      DATE_COMPUTED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMPLETED_PERCENTAGE
,      DESCRIPTION
,      PM_PRODUCT_CODE
,      CURRENT_FLAG
,      PERCENT_COMPLETE_ID
,      OBJECT_ID
,      OBJECT_VERSION_ID
,      OBJECT_TYPE
,      STATUS_CODE
,      PROGRESS_STATUS_CODE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      PUBLISHED_FLAG
,      PUBLISHED_BY_PARTY_ID
,      RECORD_VERSION_NUMBER
,      PROGRESS_COMMENT
,      HISTORY_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STRUCTURE_TYPE
,      CBS_ELEMENT_ID
FROM PA.PA_PERCENT_COMPLETES;

Dependencies

[top of page]

PA.PA_PERCENT_COMPLETES does not reference any database object

PA.PA_PERCENT_COMPLETES is referenced by following:

PA: PA_PERCENT_COMPLETES#