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

TABLE: ZPB.ZPB_STATUS_SQL

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


This table stores the Status Sql for Beans queries, so that we can limit down AW dimensions from the PL/SQL layer. The identification for the SQL is broken up into two parts, the query full name (the query path + "/" + query name), and the dimension which the SQL is limiting down. The actual SQL is stored in the CLOB.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QUERY_DIM_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_PATH
ColumnDIMENSION_NAME
ColumnROW_NUM
ZPB_STATUS_SQL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_SQL_ID
ColumnROW_NUM
Columns
Name Datatype Length Mandatory Comments
STATUS_SQL_ID NUMBER
Yes The Unique ID of the Status SQL
STATUS_SQL VARCHAR2 (4000) Yes The SQL of the query and dimension
QUERY_PATH VARCHAR2 (240) Yes The full name of the query in the Beans. It is the query path + "/" + the query name
DIMENSION_NAME VARCHAR2 (100) Yes The AW object name of the dimension
ROW_NUM NUMBER
Yes Row identifier
HIERARCHY_NAME VARCHAR2 (100)
Hierarchy name
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
Query Text

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


SELECT STATUS_SQL_ID
,      STATUS_SQL
,      QUERY_PATH
,      DIMENSION_NAME
,      ROW_NUM
,      HIERARCHY_NAME
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM ZPB.ZPB_STATUS_SQL;

Dependencies

[top of page]

ZPB.ZPB_STATUS_SQL does not reference any database object

ZPB.ZPB_STATUS_SQL is referenced by following:

SchemaAPPS
SynonymZPB_STATUS_SQL