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

TABLE: PJI.PJI_PA_XBS_DENORM_T

Object Details
Object Name: PJI_PA_XBS_DENORM_T
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_PA_XBS_DENORM_T
Subobject Name:
Status: VALID

This is an temporary table that is used
to store XBS denorm data by the Refresh/Update Project Performance Data.
This is a global temporary table.

Temporary Table Details

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

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
STRUCT_TYPE VARCHAR2 (30) Yes
PRG_GROUP NUMBER (15)
STRUCT_VERSION_ID NUMBER (15)
SUP_PROJECT_ID NUMBER (15) Yes
SUP_ID NUMBER (15) Yes
SUP_EMT_ID NUMBER (15) Yes
SUBRO_ID NUMBER (15)
SUB_ID NUMBER (15) Yes
SUB_EMT_ID NUMBER (15) Yes
SUP_LEVEL NUMBER (15) Yes
SUB_LEVEL NUMBER (15) Yes
SUB_ROLLUP_ID NUMBER (15)
SUB_LEAF_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
STRUCT_EMT_ID NUMBER (15)
RELATIONSHIP_TYPE VARCHAR2 (2)
Query Text

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


SELECT STRUCT_TYPE
,      PRG_GROUP
,      STRUCT_VERSION_ID
,      SUP_PROJECT_ID
,      SUP_ID
,      SUP_EMT_ID
,      SUBRO_ID
,      SUB_ID
,      SUB_EMT_ID
,      SUP_LEVEL
,      SUB_LEVEL
,      SUB_ROLLUP_ID
,      SUB_LEAF_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STRUCT_EMT_ID
,      RELATIONSHIP_TYPE
FROM PJI.PJI_PA_XBS_DENORM_T;

Dependencies

[top of page]

PJI.PJI_PA_XBS_DENORM_T does not reference any database object

PJI.PJI_PA_XBS_DENORM_T is referenced by following:

SchemaAPPS
SynonymPJI_PA_XBS_DENORM_T