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]

VIEW: APPS.QPR_DIM_ATTRIBUTES_V

Object Details

Object Name:	QPR_DIM_ATTRIBUTES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is on table qpr_dim_attributes which contains the dimension attribute details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIM_ATTR_ID	NUMBER		Yes	Unique Identifier for an attribute associated with a plan dimension.
PRICE_PLAN_DIM_ID	NUMBER		Yes	Identifies the dimension to which the attribute is associated.
PRICE_PLAN_ID	NUMBER		Yes	Unique identifier of the price plan.
ATTR_PPA_CODE	VARCHAR2	(30)	Yes	Unique code to identify an attribute. This code is same across plans for a given attribute.
DIM_CODE	VARCHAR2	(60)	Yes	Unique code of the dimension in a price plan, to which the attribute is associated.
ATTR_SHORT_NAME	VARCHAR2	(30)		Short name of the Attribute.
ATTR_LONG_NAME	VARCHAR2	(240)		Long name of the attribute.
ATTR_PLURAL_NAME	VARCHAR2	(240)		Plural name of the Attribute.
ATTR_DATA_TYPE	VARCHAR2	(30)		Indicates the data type of an attribute. Possible values are TEXT, DATE and NUMBER.
ATTR_CLASSIFICATION	VARCHAR2	(100)		Indicates the type of attribute. Possible values are MEMBER_LONG_DESCRIPTION, MEMBER_SHORT_DESCRIPTION, TIME_SPAN and END_DATE.
DEFAULT_ORDER_FLAG	VARCHAR2	(1)		Indicates if the dimension values must be sorted based on the attribute value or not. Takes values 'Y'/'N'.

Query Text

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


SELECT DIM_ATTR_ID
,      PRICE_PLAN_DIM_ID
,      PRICE_PLAN_ID
,      ATTR_PPA_CODE
,      DIM_CODE
,      ATTR_SHORT_NAME
,      ATTR_LONG_NAME
,      ATTR_PLURAL_NAME
,      ATTR_DATA_TYPE
,      ATTR_CLASSIFICATION
,      DEFAULT_ORDER_FLAG
FROM APPS.QPR_DIM_ATTRIBUTES_V;

Dependencies

[top of page]

APPS.QPR_DIM_ATTRIBUTES_V references the following:

APPS: QPR_DIMENSIONS; QPR_DIM_ATTRIBUTES

APPS.QPR_DIM_ATTRIBUTES_V is referenced by following:

APPS: QPR_LVL_ATTRIBUTES_V