[Home] [Help] [Dependency Information]
Object Name: | PV_ENTITY_ATTR_TRENDS |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_ENTITY_ATTR_TRENDS |
Subobject Name: | |
Status: | VALID |
PV_ENTITY_ATTR_TRENDS 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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_ENTITY_ATTR_TRENDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_TREND_ID |
PV_ENTITY_ATTR_TRENDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ENTITY_ID
ATTRIBUTE_ID TREND_TIMELINE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_TREND_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_ID | NUMBER | (30) | Yes | Depends on entity, this identifier can be partner, lead, or sales lead identifier |
ENTITY | VARCHAR2 | (30) | Yes | Type of entity (ex: partner,lead) |
ATTR_VALUE | NUMBER | Yes | Attribute value | |
TREND_TIMELINE | DATE | Yes | The starting date of this trending period | |
TIME_UOM | VARCHAR2 | (30) | Time unit of measure used for trending | |
CURRENCY_CODE | VARCHAR2 | (3) | Currency code | |
CURRENCY_DATE | DATE | Currency conversion date | ||
SECURITY_GROUP_ID | NUMBER | (15) | Security group identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_TREND_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_ID
, ENTITY_ID
, ENTITY
, ATTR_VALUE
, TREND_TIMELINE
, TIME_UOM
, CURRENCY_CODE
, CURRENCY_DATE
, SECURITY_GROUP_ID
FROM PV.PV_ENTITY_ATTR_TRENDS;
PV.PV_ENTITY_ATTR_TRENDS does not reference any database object
PV.PV_ENTITY_ATTR_TRENDS is referenced by following:
|
|
|