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


TABLE: PJI.PJI_REP_XTD_MEASURES_TMP

Object Details
Object Name: PJI_REP_XTD_MEASURES_TMP
Object Type: TABLE
Owner: PJI
Subobject Name:
Status: VALID

Temporary Table Details

PJI.PJI_REP_XTD_MEASURES_TMP 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
MEASURE_SET_CODE VARCHAR2 (30)
MEASURE_TYPE VARCHAR2 (30)
MEASURE_LABEL VARCHAR2 (240)
PTD_VALUE VARCHAR2 (80)
QTD_VALUE VARCHAR2 (80)
YTD_VALUE VARCHAR2 (80)
ITD_VALUE VARCHAR2 (80)
AC_VALUE VARCHAR2 (80)
PRP_VALUE VARCHAR2 (80)
PTD_HTML VARCHAR2 (2000)
QTD_HTML VARCHAR2 (2000)
YTD_HTML VARCHAR2 (2000)
ITD_HTML VARCHAR2 (2000)
AC_HTML VARCHAR2 (2000)
PRP_HTML VARCHAR2 (2000)
PTD_TRANS_ID VARCHAR2 (80)
QTD_TRANS_ID VARCHAR2 (80)
YTD_TRANS_ID VARCHAR2 (80)
ITD_TRANS_ID VARCHAR2 (80)
AC_TRANS_ID VARCHAR2 (80)
PRP_TRANS_ID VARCHAR2 (80)
PTD_MEANING VARCHAR2 (80)
QTD_MEANING VARCHAR2 (80)
YTD_MEANING VARCHAR2 (80)
ITD_MEANING VARCHAR2 (80)
AC_MEANING VARCHAR2 (80)
PRP_MEANING VARCHAR2 (80)
Query Text

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


SELECT MEASURE_SET_CODE
,      MEASURE_TYPE
,      MEASURE_LABEL
,      PTD_VALUE
,      QTD_VALUE
,      YTD_VALUE
,      ITD_VALUE
,      AC_VALUE
,      PRP_VALUE
,      PTD_HTML
,      QTD_HTML
,      YTD_HTML
,      ITD_HTML
,      AC_HTML
,      PRP_HTML
,      PTD_TRANS_ID
,      QTD_TRANS_ID
,      YTD_TRANS_ID
,      ITD_TRANS_ID
,      AC_TRANS_ID
,      PRP_TRANS_ID
,      PTD_MEANING
,      QTD_MEANING
,      YTD_MEANING
,      ITD_MEANING
,      AC_MEANING
,      PRP_MEANING
FROM PJI.PJI_REP_XTD_MEASURES_TMP;

Dependencies

[top of page]

PJI.PJI_REP_XTD_MEASURES_TMP does not reference any database object

PJI.PJI_REP_XTD_MEASURES_TMP is referenced by following:

SchemaAPPS
SynonymPJI_REP_XTD_MEASURES_TMP