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

TABLE: ZPB.ZPB_INTF_CALC_DEFN

Object Details
Object Name: ZPB_INTF_CALC_DEFN
Object Type: TABLE
Owner: ZPB
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000410943C00017$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
ZPB_INTF_CALC_DEFN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALC_ID
Columns
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)
Query Text

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;

Dependencies

[top of page]

ZPB.ZPB_INTF_CALC_DEFN does not reference any database object

ZPB.ZPB_INTF_CALC_DEFN is referenced by following:

SchemaAPPS
SynonymZPB_INTF_CALC_DEFN