[Home] [Help] [Dependency Information]
Object Name: | ZPB_INTF_CALC_DEFN |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000410943C00017$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
ZPB_INTF_CALC_DEFN_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALC_ID | VARCHAR2 | (32) | Yes | |
DIMENSION | VARCHAR2 | (16) | Yes | |
NAME | VARCHAR2 | (256) | ||
DESCRIPTION | VARCHAR2 | (768) | Yes | |
LONGNAME | VARCHAR2 | (256) | Yes | |
MEDNAME | VARCHAR2 | (256) | Yes | |
SHORTNAME | VARCHAR2 | (256) | Yes | |
CALCSOURCE | VARCHAR2 | (10) | Yes | |
OPERATOR | VARCHAR2 | (15) | Yes | |
NUMFORMAT | VARCHAR2 | (20) | ||
OPERAND1 | VARCHAR2 | (332) | ||
OPERAND2 | VARCHAR2 | (332) | ||
OPERAND2_TYPE | VARCHAR2 | (3) | ||
OPERAND3 | VARCHAR2 | (332) | ||
OPERAND3_TYPE | VARCHAR2 | (3) | ||
HIERARCHY | VARCHAR2 | (21) | ||
MEMBERS | CLOB | (4000) | ||
EQUATION | VARCHAR2 | (1024) | ||
EPB_CALC_ID | VARCHAR2 | (256) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CALC_ID
, DIMENSION
, NAME
, DESCRIPTION
, LONGNAME
, MEDNAME
, SHORTNAME
, CALCSOURCE
, OPERATOR
, NUMFORMAT
, OPERAND1
, OPERAND2
, OPERAND2_TYPE
, OPERAND3
, OPERAND3_TYPE
, HIERARCHY
, MEMBERS
, EQUATION
, EPB_CALC_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ZPB.ZPB_INTF_CALC_DEFN;
ZPB.ZPB_INTF_CALC_DEFN does not reference any database object
ZPB.ZPB_INTF_CALC_DEFN is referenced by following:
|
|
|