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_PROJ_ELEMENT_VERSIONS

Object Details

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

PA_PROJ_ELEMENT_VERSIONS stores the common versioned information related to tasks and structures. - For future use

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ELEMENT_VERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELEMENT_VERSION_ID
PA_PROJ_ELEMENT_VERSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJ_ELEMENT_ID
PA_PROJ_ELEMENT_VERSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_STRUCTURE_VERSION_ID
PA_PROJ_ELEMENT_VERSIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
PA_PROJ_ELEMENT_VERSIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE15
PA_PROJ_ELEMENT_VERSIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE PRG_GROUP

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The unique identifier for the element version
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element (structure or task) to which the element version belongs
OBJECT_TYPE	VARCHAR2	(30)	Yes	The type of the object for the element. The value can be TASK or STRUCTURE.
PROJECT_ID	NUMBER		Yes	The identifier of the project to which the structure version or task version belongs
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)		The identifier of the structure version to which the task version belongs
DISPLAY_SEQUENCE	NUMBER	(15)		Identifies the display order of the task version within a structure version. This is a task-specific attribute.
WBS_LEVEL	NUMBER	(3)		Identifies the hierarchical level of the task version within a structure version. This is a task-specific attribute.
WBS_NUMBER	VARCHAR2	(240)		System-generated formatted number for a task version, which indicates the exact position of a task version in a structure version. This is a task-specific attribute.
RECORD_VERSION_NUMBER	NUMBER	(15)		Sequence number for lock strategy in self-service applications
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
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
TASK_UNPUB_VER_STATUS_CODE	VARCHAR2	(30)		The unpublished task version status code.
FINANCIAL_TASK_FLAG	VARCHAR2	(1)		To indicate a task can be used for financial management.
PRG_GROUP	NUMBER	(15)		The unique identifier given to each connected sub-graph of projects
PRG_LEVEL	NUMBER	(15)		The relative level of a project within a program group
PRG_COUNT	NUMBER	(15)		The number of project structure versions that roll up into a task version
SOURCE_OBJECT_ID	NUMBER	(15)		Identifier of the object
SOURCE_OBJECT_TYPE	VARCHAR2	(30)		Type of the object

Query Text

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


SELECT ELEMENT_VERSION_ID
,      PROJ_ELEMENT_ID
,      OBJECT_TYPE
,      PROJECT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PARENT_STRUCTURE_VERSION_ID
,      DISPLAY_SEQUENCE
,      WBS_LEVEL
,      WBS_NUMBER
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TASK_UNPUB_VER_STATUS_CODE
,      FINANCIAL_TASK_FLAG
,      PRG_GROUP
,      PRG_LEVEL
,      PRG_COUNT
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE
FROM PA.PA_PROJ_ELEMENT_VERSIONS;

Dependencies

[top of page]

PA.PA_PROJ_ELEMENT_VERSIONS does not reference any database object

PA.PA_PROJ_ELEMENT_VERSIONS is referenced by following:

APPS: PA_PROJ_ELEMENT_VERSIONS