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_ELEM_VER_STRUCTURE

Object Details

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

PA_PROJ_ELEM_VER_STRUCTURE stores the structure attributes which are versioned. - For future use

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ELEM_VER_STRUCTURE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PEV_STRUCTURE_ID
PA_PROJ_ELEM_VER_STRUCTURE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID PROJ_ELEMENT_ID NAME
PA_PROJ_ELEM_VER_STRUCTURE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID ELEMENT_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PEV_STRUCTURE_ID	NUMBER	(15)	Yes	The unique identifier for the structure version attributes
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The unique identifier for the element version
VERSION_NUMBER	NUMBER		Yes	Auto-generated structure version number
NAME	VARCHAR2	(240)	Yes	User-defined name of the structure version
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the structure version attributes belong
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element to which the structure version attributes belong
CURRENT_FLAG	VARCHAR2	(1)	Yes	The flag that identifies the current baselined structure version
ORIGINAL_FLAG	VARCHAR2	(1)	Yes	The flag that identifies the original baselined structure version
LATEST_EFF_PUBLISHED_FLAG	VARCHAR2	(1)	Yes	Flag indicating that this structure version is the latest published version of the structure
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
DESCRIPTION	VARCHAR2	(2000)		The description of the structure version
EFFECTIVE_DATE	DATE			The date that the structure version becomes effective
PUBLISHED_DATE	DATE			The date that the structure version was published
PUBLISHED_BY_PERSON_ID	NUMBER	(15)		The identifier of the user who published the structure version
CURRENT_BASELINE_DATE	DATE			The date that the structure version was designated the current baseline
CURRENT_BASELINE_PERSON_ID	NUMBER	(15)		The identifier of the user who set this structure version as the current baseline structure version
ORIGINAL_BASELINE_DATE	DATE			The date that the structure version was designated the original baseline
ORIGINAL_BASELINE_PERSON_ID	NUMBER	(15)		The identifier of the user who set this structure version as the original baseline structure version
LOCK_STATUS_CODE	VARCHAR2	(30)		The lock status of the structure version
LOCKED_BY_PERSON_ID	NUMBER	(15)		The identifier of the user who has locked the structure version
LOCKED_DATE	DATE			The date that the structure version was locked
STATUS_CODE	VARCHAR2	(150)		The status of the structure version
WF_STATUS_CODE	VARCHAR2	(30)		The status of workflow associated with the structure version
RECORD_VERSION_NUMBER	NUMBER	(15)		Sequence number for lock strategy in self-service applications
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PM_SOURCE_CODE	VARCHAR2	(30)		The identifier of the source system from which the element version was created
PM_SOURCE_REFERENCE	VARCHAR2	(25)		The identifier of the element version in the source system from which the element version was imported
WBS_RECORD_VERSION_NUMBER	NUMBER	(15)		Sequence number for lock strategy in self-service applications
CHANGE_REASON_CODE	VARCHAR2	(30)		The change reason for the workplan version.
PROCESS_UPDATE_WBS_FLAG	VARCHAR2	(1)		Indicates whether the work breakdown structure must be processed for changes to the structure.
CONC_REQUEST_ID	NUMBER	(15)		The process ID for the Process Work Breakdown Structure Updates process.
PROCESS_CODE	VARCHAR2	(30)		The status of the Process Work Breakdown Structure process.
CURRENT_WORKING_FLAG	VARCHAR2	(1)		Flag indicating whether or not the selected structure version is current working version.
SCHEDULE_DIRTY_FLAG	VARCHAR2	(1)		Flag indicating whether or not the structure version needs to synchronize with schedule on third party software.
DATE_PROG_APPLIED_ON_WVER	DATE			Time stamp for last time the latest progress applied on working 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 PEV_STRUCTURE_ID
,      ELEMENT_VERSION_ID
,      VERSION_NUMBER
,      NAME
,      PROJECT_ID
,      PROJ_ELEMENT_ID
,      CURRENT_FLAG
,      ORIGINAL_FLAG
,      LATEST_EFF_PUBLISHED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DESCRIPTION
,      EFFECTIVE_DATE
,      PUBLISHED_DATE
,      PUBLISHED_BY_PERSON_ID
,      CURRENT_BASELINE_DATE
,      CURRENT_BASELINE_PERSON_ID
,      ORIGINAL_BASELINE_DATE
,      ORIGINAL_BASELINE_PERSON_ID
,      LOCK_STATUS_CODE
,      LOCKED_BY_PERSON_ID
,      LOCKED_DATE
,      STATUS_CODE
,      WF_STATUS_CODE
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      PM_SOURCE_CODE
,      PM_SOURCE_REFERENCE
,      WBS_RECORD_VERSION_NUMBER
,      CHANGE_REASON_CODE
,      PROCESS_UPDATE_WBS_FLAG
,      CONC_REQUEST_ID
,      PROCESS_CODE
,      CURRENT_WORKING_FLAG
,      SCHEDULE_DIRTY_FLAG
,      DATE_PROG_APPLIED_ON_WVER
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE
FROM PA.PA_PROJ_ELEM_VER_STRUCTURE;

Dependencies

[top of page]

PA.PA_PROJ_ELEM_VER_STRUCTURE does not reference any database object

PA.PA_PROJ_ELEM_VER_STRUCTURE is referenced by following:

APPS: PA_PROJ_ELEM_VER_STRUCTURE