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.PV_ENTITY_ATTRS_V

Object Details

Object Name:	PV_ENTITY_ATTRS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_ENTITY_ATTRS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

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
ATTRIBUTE_ID	NUMBER	(15)	Yes	Attribute identifier
ENTITY	VARCHAR2	(30)	Yes	Type of entity (ex: partner,lead)
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)		Item style to be used while rendering the attribute
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Flag to restrict the contents based on the roles
LOCATOR_FLAG	VARCHAR2	(1)
ENTITY_TYPE	VARCHAR2	(30)

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
,      SQL_TEXT
,      ATTR_DATA_TYPE
,      LOV_STRING
,      ENABLED_FLAG
,      ITEM_STYLE
,      SELECTION_TYPE
,      DISPLAY_FLAG
,      LOCATOR_FLAG
,      ENTITY_TYPE
FROM APPS.PV_ENTITY_ATTRS_V;

Dependencies

[top of page]

APPS.PV_ENTITY_ATTRS_V references the following:

APPS: PV_ENTITY_ATTRS

APPS.PV_ENTITY_ATTRS_V is not referenced by any database object