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_RELATIONSHIP_T

Object Details

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

This is a temporary table used for performance improvement.

Temporary Table Details

PA.PA_PROJ_ELEM_RELATIONSHIP_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ELEM_RELATIONSHIP_T_N1	NORMAL	NONUNIQUE		PARENT_VER_ID DISPLAY_SEQUENCE CHILD_VER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)		The identifier of the structure version to which the task version belongs
CHILD_VER_ID	NUMBER	(15)	Yes	Element version Id for child task
PARENT_VER_ID	NUMBER	(15)	Yes	Element version Id for parent task
DISPLAY_SEQUENCE	NUMBER	(15)		Identifies the display order of the task within a structure version. This is a task-specific attribute.
OBJECT_ID_TO1	NUMBER			The identifier of the predecessor
OBJECT_TYPE_TO	VARCHAR2	(30)	Yes	The type of the successor such as PA_PROJECTS or PA_TASKS
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The type of relationship between the two objects
OBJECT_ID_FROM1	NUMBER			The identifier of the predecessor such as PROJECT_ID if the object_type is PA_PROJECTS
OBJECT_TYPE_FROM	VARCHAR2	(30)	Yes	The type of the predecessor such as PA_PROJECTS or PA_TASKS

Query Text

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


SELECT PARENT_STRUCTURE_VERSION_ID
,      CHILD_VER_ID
,      PARENT_VER_ID
,      DISPLAY_SEQUENCE
,      OBJECT_ID_TO1
,      OBJECT_TYPE_TO
,      RELATIONSHIP_TYPE
,      OBJECT_ID_FROM1
,      OBJECT_TYPE_FROM
FROM PA.PA_PROJ_ELEM_RELATIONSHIP_T;

Dependencies

[top of page]

PA.PA_PROJ_ELEM_RELATIONSHIP_T does not reference any database object

PA.PA_PROJ_ELEM_RELATIONSHIP_T is referenced by following:

APPS: PA_PROJ_ELEM_RELATIONSHIP_T