[Home] [Help] [Dependency Information]
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.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJ_ELEM_RELATIONSHIP_T_N1 | NORMAL | NONUNIQUE |
PARENT_VER_ID
DISPLAY_SEQUENCE CHILD_VER_ID |
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 |
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;
PA.PA_PROJ_ELEM_RELATIONSHIP_T does not reference any database object
PA.PA_PROJ_ELEM_RELATIONSHIP_T is referenced by following:
|
|
|