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

TABLE: ZPB.ZPB_SOLVE_HIER_ORDER

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZPB_SOLVE_HIER_ORDER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOLVE_HIER_ORDER_ID
ZPB_SOLVE_HIER_ORDER_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnANALYSIS_CYCLE_ID
ColumnDIMENSION
ColumnHIERARCHY
Columns
Name Datatype Length Mandatory Comments
SOLVE_HIER_ORDER_ID NUMBER
Yes Surrogate primary key to uniquely identify each record in the table
ANALYSIS_CYCLE_ID NUMBER
Yes Business process identifier
DIMENSION VARCHAR2 (50) Yes Dimension whose hierarchy order is being specified
HIERARCHY VARCHAR2 (50) Yes The hierarchy identifier
HIERARCHY_ORDER NUMBER
Yes The orderof heirarchies in business process solve defintion in which data will be aggregated during solve
FIRST_LAST_FLAG VARCHAR2 (1)
Flag used to indicate first or last record for a dimension in the order
OBJECT_VERSION_NUMBER NUMBER

Unique identifier
CREATED_BY NUMBER
Yes Who Column
CREATION_DATE DATE
Yes Date on which the record was created
LAST_UPDATED_BY NUMBER
Yes Last updated login
LAST_UPDATE_DATE DATE
Yes Last updated date
LAST_UPDATE_LOGIN NUMBER
Yes Last updated user
Query Text

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


SELECT SOLVE_HIER_ORDER_ID
,      ANALYSIS_CYCLE_ID
,      DIMENSION
,      HIERARCHY
,      HIERARCHY_ORDER
,      FIRST_LAST_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZPB.ZPB_SOLVE_HIER_ORDER;

Dependencies

[top of page]

ZPB.ZPB_SOLVE_HIER_ORDER does not reference any database object

ZPB.ZPB_SOLVE_HIER_ORDER is referenced by following:

SchemaAPPS
SynonymZPB_SOLVE_HIER_ORDER