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_NOTES_TL

Object Details

Object Name:	JTF_NOTES_TL
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_NOTES_TL
Subobject Name:
Status:	VALID

JTF_NOTES_TL stores translated information about Notes. Notes may be created for any object mapped for object usage in JTF_OBJECTS; the JTF_OBJECT that the note is linked to is stored as the source_object_code and source_object_id. The actual text of the note, which is stored in the JTF_NOTES_TL, is split into two parts under columns NOTES and NOTE_DETAILS. Typically, the NOTES should hold the short form or the first part of the note. NOTE_DETAILS for added details, or whenever the note is longer than the 2000 character limit for the NOTES column.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_NOTES_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	JTF_NOTE_ID LANGUAGE
SYS_IL0000084548C00003$$	LOB	UNIQUE	APPS_TS_TX_DATA
JTF_NOTES_TL_C1	DOMAIN	NONUNIQUE		NOTES

Columns

Name	Datatype	Length	Mandatory	Comments
JTF_NOTE_ID	NUMBER		Yes	Primary key
NOTES	VARCHAR2	(2000)	Yes	Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long.
NOTES_DETAIL	CLOB	(4000)		Additional detailed text for the note. Will typically hold the remainder of the note beyond the first 2000 characters.
LANGUAGE	VARCHAR2	(4)	Yes	Language.
SOURCE_LANG	VARCHAR2	(4)	Yes	The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created 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_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT JTF_NOTE_ID
,      NOTES
,      NOTES_DETAIL
,      LANGUAGE
,      SOURCE_LANG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM JTF.JTF_NOTES_TL;

Dependencies

[top of page]

JTF.JTF_NOTES_TL does not reference any database object

JTF.JTF_NOTES_TL is referenced by following:

APPS: JTF_NOTES_TL