[Home] [Help] [Dependency Information]
Object Name: | ZPB_MEASURES |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
EPB Measures include Business Process Run Instance Measures - Data, Format, Annotation, Calculated Measures, and Security Measures. Striped by the cube that the measures belong to
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_MEASURES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MEASURE_ID |
ZPB_MEASURES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INSTANCE_ID |
ZPB_MEASURES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUBE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AW_NAME | VARCHAR2 | (30) | Name of Measure in the Workspace | |
COLUMN_ID | NUMBER | Yes | Foreign Key into the zpb_columns table | |
CUBE_ID | NUMBER | Yes | Foreign Key into zpb_cubes table | |
CURRENCY_TYPE | VARCHAR2 | (30) | Currency type of measure (Local, Selected, or Functional) | |
CURR_INST_FLAG | VARCHAR2 | (3) | YES if this measure is the current instance measure of its business process | |
CWM_NAME | VARCHAR2 | (60) | CWM name of measure | |
EPB_ID | VARCHAR2 | (30) | EPB id of measure | |
INSTANCE_ID | NUMBER | Instance id of measure. Each instance may have more than one measure associated with it (Data, Format, Annotation, Write Security) | ||
MEASURE_ID | NUMBER | Yes | Primary key of this table | |
TEMPLATE_ID | NUMBER | Template id for worksheets | ||
APPROVEE_ID | VARCHAR2 | (240) | Approvee id for worksheets | |
TYPE | VARCHAR2 | (64) | Type of measure (SHARED_DATA, SHARED_CALC, SHARED_WRITE_SECURITY etc) | |
SELECTED_CUR | VARCHAR2 | (30) | If the currency_type column is set to Selected, this column specified the selected currency | |
NAME | VARCHAR2 | (255) | Name of measure | |
CURRENCY_REL | VARCHAR2 | (240) | Currency code for the currency of this measure's data | |
CPR_MEASURE | VARCHAR2 | (3) | True if this is a currently processing run measure, or a calculation measure based on a CPR | |
CREATION_DATE | DATE | Yes | Bookkeeping Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Bookkeeping Column |
LAST_UPDATE_DATE | DATE | Yes | Bookkeeping Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Bookkeeping Column |
CREATED_BY | NUMBER | (15) | Yes | Bookkeeping Column |
Cut, paste (and edit) the following text to query this object:
SELECT AW_NAME
, COLUMN_ID
, CUBE_ID
, CURRENCY_TYPE
, CURR_INST_FLAG
, CWM_NAME
, EPB_ID
, INSTANCE_ID
, MEASURE_ID
, TEMPLATE_ID
, APPROVEE_ID
, TYPE
, SELECTED_CUR
, NAME
, CURRENCY_REL
, CPR_MEASURE
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
FROM ZPB.ZPB_MEASURES;
ZPB.ZPB_MEASURES does not reference any database object
ZPB.ZPB_MEASURES is referenced by following:
|
|
|