eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QPR.QPR_CUBES

Object Details

Object Name:	QPR_CUBES
Object Type:	TABLE
Owner:	QPR
Subobject Name:
Status:	VALID

This table contains the cube definitions of the price plan.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_CUBES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CUBE_ID
QPR_CUBES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRICE_PLAN_ID CUBE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CUBE_ID	NUMBER		Yes	Unique Identifier for a price plan cube.
CUBE_CODE	VARCHAR2	(60)	Yes	Unique code for a price plan cube.
PRICE_PLAN_ID	NUMBER		Yes	Identifies the price plan.
CUBE_PPA_CODE	VARCHAR2	(30)	Yes	Unique code to identify a cube. This value is same across plans for a given cube value.
TEMPLATE_FLAG	VARCHAR2	(1)		Indicates if the rows belong to plan template. Takes values 'Y'/'N'.
SEEDED_FLAG	VARCHAR2	(1)		Indicates if the record is seeded or not. Takes values 'Y'/'N'.
CUBE_SHORT_NAME	VARCHAR2	(30)		Short name of the cube.
CUBE_LONG_NAME	VARCHAR2	(240)		Long name of the cube.
CUBE_PLURAL_NAME	VARCHAR2	(240)		Plural name of the cube.
CUBE_AUTO_SOLVE_FLAG	VARCHAR2	(1)		Indicates if the aggregation solving must be run automatically when building the cube or not. Takes values 'Y'/'N'.
DEFAULT_DATA_TYPE	VARCHAR2	(30)		Indicates the default data type for the measures of the cube.
PARTITION_HIER	VARCHAR2	(30)		Indicates the hierarchy that will be used for partitioning the cube data. All the dimension members belonging to the hierarchy will be saved to same partition.
PARTITION_LEVEL	VARCHAR2	(30)		Identifies the level code of the mentioned hierarchy that will be used to partition the cube. All the dimension members of this level and the dimension members of its sublevels will also tbe stroed in a partition.
SPARSE_TYPE_CODE	VARCHAR2	(3)		Specifies the type of composite to manage sparsity.
USE_GLOBAL_INDEX_FLAG	VARCHAR2	(1)		Indicates if a single composite/index is used for all measures of the cube or not. Takes values 'Y'/'N'. Select 'Y' only when the measures share the same sparsity and regular composites are used.
AGGMAP_NAME	VARCHAR2	(30)		Name of the aggregation map for the measures, which contains a set of rules for distributing data throughout the levels of a dimension hierarchy. Aggmaps can be used either for aggregation or allocation.
AGGMAP_CACHE_STORE	VARCHAR2	(10)		Indicates if the aggregated values are cached or not. Takes values 'STORE'/ 'NOSTORE' indicating caching and no caching respectively.
AGGMAP_CACHE_NA	VARCHAR2	(5)		Indicates if 'NA' values resulting from aggregation operation are cached or not. Takes values 'NA'/'NONA' indicating caching and nocaching respectively.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applicaitons Consurrent Program Login ID
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned the consurrent program
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned the concurrent program

Query Text

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


SELECT CUBE_ID
,      CUBE_CODE
,      PRICE_PLAN_ID
,      CUBE_PPA_CODE
,      TEMPLATE_FLAG
,      SEEDED_FLAG
,      CUBE_SHORT_NAME
,      CUBE_LONG_NAME
,      CUBE_PLURAL_NAME
,      CUBE_AUTO_SOLVE_FLAG
,      DEFAULT_DATA_TYPE
,      PARTITION_HIER
,      PARTITION_LEVEL
,      SPARSE_TYPE_CODE
,      USE_GLOBAL_INDEX_FLAG
,      AGGMAP_NAME
,      AGGMAP_CACHE_STORE
,      AGGMAP_CACHE_NA
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM QPR.QPR_CUBES;

Dependencies

[top of page]

QPR.QPR_CUBES does not reference any database object

QPR.QPR_CUBES is referenced by following:

APPS: QPR_CUBES