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

TABLE: PA.PA_PERF_TEMP_OBJ_MEASURE

Object Details
Object Name: PA_PERF_TEMP_OBJ_MEASURE
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Global temporary table to store the measure values.

Temporary Table Details

PA.PA_PERF_TEMP_OBJ_MEASURE 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
OBJECT_TYPE VARCHAR2 (30) Yes Object Type
OBJECT_ID NUMBER
Yes Object Identifier.
MEASURE_ID NUMBER
Yes Measure ID.
MEASURE_VALUE NUMBER

Measure Value.
RULE_ID NUMBER
Yes Rule ID.
CALENDAR_TYPE VARCHAR2 (30)
Calendar Type.
CURRENCY_TYPE VARCHAR2 (30)
Currency Type.
PERIOD_NAME VARCHAR2 (15)
Period Name.
BZ_ENT_CODE VARCHAR2 (30)
Business Event Code.
Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_ID
,      MEASURE_ID
,      MEASURE_VALUE
,      RULE_ID
,      CALENDAR_TYPE
,      CURRENCY_TYPE
,      PERIOD_NAME
,      BZ_ENT_CODE
FROM PA.PA_PERF_TEMP_OBJ_MEASURE;

Dependencies

[top of page]

PA.PA_PERF_TEMP_OBJ_MEASURE does not reference any database object

PA.PA_PERF_TEMP_OBJ_MEASURE is referenced by following:

SchemaAPPS
SynonymPA_PERF_TEMP_OBJ_MEASURE