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: PV.PV_ATTRIBUTES_B

Object Details

Object Name:	PV_ATTRIBUTES_B
Object Type:	TABLE
Owner:	PV
FND Design Data:	PV.PV_ATTRIBUTES_B
Subobject Name:
Status:	VALID

PV_ATTRIBUTES_B stores additional lead/partner attribute identifiers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_ATTRIBUTES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_ID	NUMBER	(15)	Yes	Attribute identifier
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
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object version number
SECURITY_GROUP_ID	NUMBER	(15)		Security group identifier
ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to enable or disable the Attribute
ATTRIBUTE_TYPE	VARCHAR2	(30)		Attribute display type, text or lov or dropdown etc.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category, number or date or text type
SEEDED_FLAG	VARCHAR2	(1)		Whether the attribute is seeded or not
LOV_FUNCTION_NAME	VARCHAR2	(30)		Function name for the List of values, if any
RETURN_TYPE	VARCHAR2	(30)		If the attribute is a function attribute, it specifies the return type
MAX_VALUE_FLAG	VARCHAR2	(1)		Attribute value is Max or not
DISPLAY_STYLE	VARCHAR2	(30)		Attribute Dsplay Style(text,Dropdown etc)
EXPOSE_TO_PARTNER_FLAG	VARCHAR2	(1)		Exposed to Partner or Not
CHARACTER_WIDTH	NUMBER			Character Width of the attribute
DECIMAL_POINTS	NUMBER			Decimal Points for number attribute
NO_OF_LINES	NUMBER			Number of Lines
VALUE_EXTN_RETURN_TYPE	VARCHAR2	(30)		Value of External Return Type if any
ENABLE_MATCHING_FLAG	VARCHAR2	(1)		Matching Flag enabled if Y else, N
PERFORMANCE_FLAG	VARCHAR2	(1)		Indicates whether this attribute is a performance attribute.
ADDITIVE_FLAG	VARCHAR2	(1)		Indicates whether the attribute value of this attribute can be added across time.
SEQUENCE_NUMBER	NUMBER			The column is used to specify ther placement of the attribute on the appropriate UI.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ATTRIBUTE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      ENABLED_FLAG
,      ATTRIBUTE_TYPE
,      ATTRIBUTE_CATEGORY
,      SEEDED_FLAG
,      LOV_FUNCTION_NAME
,      RETURN_TYPE
,      MAX_VALUE_FLAG
,      DISPLAY_STYLE
,      EXPOSE_TO_PARTNER_FLAG
,      CHARACTER_WIDTH
,      DECIMAL_POINTS
,      NO_OF_LINES
,      VALUE_EXTN_RETURN_TYPE
,      ENABLE_MATCHING_FLAG
,      PERFORMANCE_FLAG
,      ADDITIVE_FLAG
,      SEQUENCE_NUMBER
,      ZD_EDITION_NAME
FROM PV.PV_ATTRIBUTES_B;

Dependencies

[top of page]

PV.PV_ATTRIBUTES_B does not reference any database object

PV.PV_ATTRIBUTES_B is referenced by following:

PV: PV_ATTRIBUTES_B#