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_ENTITY_ATTRS

Object Details

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

PV_ENTITY_ATTRS stores the information about the entity attribute relationships used for
deciding partner selection based on the rank. The rank is determined based on the partner experties defined in the PV_ATTRIBUTE_CODES

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_ENTITY_ATTRS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENTITY_ATTR_ID
PV_ENTITY_ATTRS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID ENTITY
PV_ENTITY_ATTRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY

Columns

Name	Datatype	Length	Mandatory	Comments
ENTITY_ATTR_ID	NUMBER	(15)	Yes	Entity 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		Yes	Object version number
ATTRIBUTE_ID	NUMBER	(15)	Yes	Attribute identifier
ENTITY	VARCHAR2	(30)	Yes	Type of entity (ex: partner,lead)
SRC_TABLE_NAME	VARCHAR2	(50)
SRC_PKCOL_NAME	VARCHAR2	(100)
SQL_TEXT	VARCHAR2	(2000)		Contains a sql text that returns values associated with a lead or partner
ATTR_DATA_TYPE	VARCHAR2	(30)		Data source from which the entity is defined
LOV_STRING	VARCHAR2	(2000)		Contains a sql text that is used in displaying LOV on mannual matching screens
ENABLED_FLAG	VARCHAR2	(1)	Yes	The entity-attributes row is enabled or not
ITEM_STYLE	VARCHAR2	(30)		Item style to be used while rendering the attribute
SELECTION_TYPE	VARCHAR2	(1)		Based on the value, matching partner screen field can be single select or multi select
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Flag to restrict the contents based on the roles
RANK	NUMBER	(3)
AUTO_ASSIGN_FLAG	VARCHAR2	(1)
SECURITY_GROUP_ID	NUMBER	(15)		Security group identifier
LOCATOR_FLAG	VARCHAR2	(1)		Attribute Locator Flag
ENTITY_TYPE	VARCHAR2	(30)		Entity type for categarization
REQUIRE_VALIDATION_FLAG	VARCHAR2	(1)		Require Validation Flag, if Yes it is Y else it is N
EXTERNAL_UPDATE_TEXT	VARCHAR2	(2000)		External Update Text
BATCH_SQL_TEXT	VARCHAR2	(2000)		Same as sql_text but the predicate of the SQL is not qualified by an entity_id (e.g. partner_id or lead_id).
REFRESH_FREQUENCY	NUMBER			Refresh frequency of the attribute
REFRESH_FREQUENCY_UOM	VARCHAR2	(20)		Refresh frequency unit of measure (e.g. DAY, HOUR MONTH)
LAST_REFRESH_DATE	DATE			The date the attribute is last refreshed.
DISPLAY_EXTERNAL_VALUE_FLAG	VARCHAR2	(1)		For performance and derived attributes of 'PARTNER' entity, if display_external_value_flag is 'Y', then the attribute value is stored in pv_search_attr_values. Otherwise, the attribute value is stored in pv_enty_attr_values.

Query Text

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


SELECT ENTITY_ATTR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_ID
,      ENTITY
,      SRC_TABLE_NAME
,      SRC_PKCOL_NAME
,      SQL_TEXT
,      ATTR_DATA_TYPE
,      LOV_STRING
,      ENABLED_FLAG
,      ITEM_STYLE
,      SELECTION_TYPE
,      DISPLAY_FLAG
,      RANK
,      AUTO_ASSIGN_FLAG
,      SECURITY_GROUP_ID
,      LOCATOR_FLAG
,      ENTITY_TYPE
,      REQUIRE_VALIDATION_FLAG
,      EXTERNAL_UPDATE_TEXT
,      BATCH_SQL_TEXT
,      REFRESH_FREQUENCY
,      REFRESH_FREQUENCY_UOM
,      LAST_REFRESH_DATE
,      DISPLAY_EXTERNAL_VALUE_FLAG
FROM PV.PV_ENTITY_ATTRS;

Dependencies

[top of page]

PV.PV_ENTITY_ATTRS does not reference any database object

PV.PV_ENTITY_ATTRS is referenced by following:

APPS: PV_ENTITY_ATTRS