DBA Data[Home] [Help] [Dependency Information]


TABLE: PA.PA_PPR_OBJ_TMP_VIEW

Object Details
Object Name: PA_PPR_OBJ_TMP_VIEW
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PPR_OBJ_TMP_VIEW
Subobject Name:
Status: VALID

Temporary Table Details

PA.PA_PPR_OBJ_TMP_VIEW 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$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
PA_PPR_OBJ_TMP_VIEW_U1 NORMAL UNIQUE Tablespace ColumnOBJECT_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

PARENT_OBJECT_ID NUMBER

WBS_RBS_LEVEL NUMBER

CONNECT_PATH VARCHAR2 (240)
LEAF_NODE NUMBER

Query Text

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


SELECT OBJECT_ID
,      PARENT_OBJECT_ID
,      WBS_RBS_LEVEL
,      CONNECT_PATH
,      LEAF_NODE
FROM PA.PA_PPR_OBJ_TMP_VIEW;

Dependencies

[top of page]

PA.PA_PPR_OBJ_TMP_VIEW does not reference any database object

PA.PA_PPR_OBJ_TMP_VIEW is referenced by following:

SchemaAPPS
SynonymPA_PPR_OBJ_TMP_VIEW