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: JTF.JTF_ACT_ACTIVITY_LOGS

Object Details

Object Name:	JTF_ACT_ACTIVITY_LOGS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_ACT_ACTIVITY_LOGS
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.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_ACT_ACTIVITY_LOGS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	JTF_ACT_ACTIVITY_LOGS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
JTF_ACT_ACTIVITY_LOGS_ID	NUMBER		Yes	the id of each row in this table
ACTIVITY_NAME_ID	NUMBER		Yes	activity type id
APPLICATION_ID	NUMBER		Yes	application id which logs this activity
COMPONENT	VARCHAR2	(255)		which application that this activity is logged
COLUMN1	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN2	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN3	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN4	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN5	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN6	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN7	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN8	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN9	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN10	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN11	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN12	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN13	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN14	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN15	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN16	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN17	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN18	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN19	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN20	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN21	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN22	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN23	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN24	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN25	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN26	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN27	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN28	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN29	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN30	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN31	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN32	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN33	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN34	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN35	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN36	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN37	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN38	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN39	VARCHAR2	(255)		the columns which stores the values of activities.
COLUMN40	VARCHAR2	(255)		the columns which stores the values of activities.
OBJECT_VERSION_NUMBER	NUMBER			Standard object version numbers
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
JTF_ACT_ACTIVITY_LOGS_USER_ID	NUMBER	(15)	Yes	Foreign Key Column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT JTF_ACT_ACTIVITY_LOGS_ID
,      ACTIVITY_NAME_ID
,      APPLICATION_ID
,      COMPONENT
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
,      COLUMN13
,      COLUMN14
,      COLUMN15
,      COLUMN16
,      COLUMN17
,      COLUMN18
,      COLUMN19
,      COLUMN20
,      COLUMN21
,      COLUMN22
,      COLUMN23
,      COLUMN24
,      COLUMN25
,      COLUMN26
,      COLUMN27
,      COLUMN28
,      COLUMN29
,      COLUMN30
,      COLUMN31
,      COLUMN32
,      COLUMN33
,      COLUMN34
,      COLUMN35
,      COLUMN36
,      COLUMN37
,      COLUMN38
,      COLUMN39
,      COLUMN40
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      JTF_ACT_ACTIVITY_LOGS_USER_ID
,      SECURITY_GROUP_ID
FROM JTF.JTF_ACT_ACTIVITY_LOGS;