[Home] [Help] [Dependency Information]
Object Name: | PA_PERF_TEMP_OBJ_MEASURE |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Global temporary table to store the measure values.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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. |
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;
PA.PA_PERF_TEMP_OBJ_MEASURE does not reference any database object
PA.PA_PERF_TEMP_OBJ_MEASURE is referenced by following:
|
|
|