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

TABLE: PJI.PJI_PJP_WBS_HEADER_T

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

This is an temporary table that is
used to store temporary data required for WBS Rollup by the Refresh/Update
Project Performance Data. This is a global temporary table.

Temporary Table Details

PJI.PJI_PJP_WBS_HEADER_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
PROJECT_ID NUMBER (15)
PLAN_VERSION_ID NUMBER (15)
WBS_VERSION_ID NUMBER (15)
WP_FLAG VARCHAR2 (1)
CB_FLAG VARCHAR2 (1)
CO_FLAG VARCHAR2 (1)
LOCK_FLAG VARCHAR2 (1)
PLAN_TYPE_ID NUMBER (15)
MIN_TXN_DATE DATE

MAX_TXN_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PLAN_TYPE_CODE VARCHAR2 (1)
Query Text

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


SELECT PROJECT_ID
,      PLAN_VERSION_ID
,      WBS_VERSION_ID
,      WP_FLAG
,      CB_FLAG
,      CO_FLAG
,      LOCK_FLAG
,      PLAN_TYPE_ID
,      MIN_TXN_DATE
,      MAX_TXN_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_TYPE_CODE
FROM PJI.PJI_PJP_WBS_HEADER_T;

Dependencies

[top of page]

PJI.PJI_PJP_WBS_HEADER_T does not reference any database object

PJI.PJI_PJP_WBS_HEADER_T is referenced by following:

SchemaAPPS
SynonymPJI_PJP_WBS_HEADER_T