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: TableIMC.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: TablespaceAPPS_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:

SchemaIMC
ViewIMC_RECENT_ACCESSED_OBJ#