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: IMC.IMC_RECENT_ACCESSED_OBJ

Object Details

Object Name:	IMC_RECENT_ACCESSED_OBJ
Object Type:	TABLE
Owner:	IMC
FND Design Data:	IMC.IMC_RECENT_ACCESSED_OBJ
Subobject Name:
Status:	VALID

The IMC_RECENTLY_ACCESSED_OBJECTS table keeps track of all the IMC objects (person, organization, contact) that a user has viewed via the Overview screens.
For example, when the user clicks on a Bookmarked Person to look at the details, an entry is made into this table to record the access.
This table is used to create the list of Recent Items on the IMC Home and other pages.
The primary key is ACCESS_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER	(15)	Yes	Access unique identifier
USER_ID	NUMBER	(15)	Yes	CRM user id for which the object access is being recorded.
OBJECT_TYPE	VARCHAR2	(50)	Yes	Type of object: PERSON, ORGANIZATION, PARTY_RELATIONSHIP.
OBJECT_ID	NUMBER	(15)	Yes	Object identifier
OBJECT_NAME	VARCHAR2	(360)		User-friendly name of the object.
APPLICATION_ID	NUMBER	(15)		Id of the application that created this entry.
DATE_CREATED	DATE		Yes	Date of object access.
ADDITIONAL_VALUE1	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE2	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE3	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE4	VARCHAR2	(150)		Placeholder for future additional values.
ADDITIONAL_VALUE5	VARCHAR2	(150)		Placeholder for future additional values.
OBJECT_VERSION_NUMBER	NUMBER	(15)		Version number for concurrency control purposes.
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT ACCESS_ID
,      USER_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJECT_NAME
,      APPLICATION_ID
,      DATE_CREATED
,      ADDITIONAL_VALUE1
,      ADDITIONAL_VALUE2
,      ADDITIONAL_VALUE3
,      ADDITIONAL_VALUE4
,      ADDITIONAL_VALUE5
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IMC.IMC_RECENT_ACCESSED_OBJ;

Dependencies

[top of page]

IMC.IMC_RECENT_ACCESSED_OBJ does not reference any database object

IMC.IMC_RECENT_ACCESSED_OBJ is referenced by following:

APPS: IMC_RECENT_ACCESSED_OBJ