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

Object Details

Object Name:	JTF_NOTES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_NOTES_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

MLS view over JTF_NOTES_B and JTF_NOTES_TL. Main view to query up all Notes related to any object.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id from the base table JTF_NOTES_B.
JTF_NOTE_ID	NUMBER		Yes	Unique Note identifier
PARENT_NOTE_ID	NUMBER			Note id of the parent of the current note.
SOURCE_OBJECT_ID	NUMBER		Yes	Primary Key of the source form.
SOURCE_OBJECT_CODE	VARCHAR2	(240)	Yes	Identifies the source. Linked to the lookup code in the fnd lookups table where lookup_type is 'JTF_OBJECT_SOURCE_TYPE'
SOURCE_NUMBER	VARCHAR2	(4000)		The source number of the note.
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).
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_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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.
NOTE_STATUS	VARCHAR2	(1)		This flag determines whether the note is allowed to be published in the web or not. Stored in fnd_lookups for the lookup type of JTF_NOTE_STATUS.
ENTERED_BY	NUMBER	(15)	Yes	The person who entered the note.
ENTERED_BY_NAME	VARCHAR2	(4000)		The name of the person who entered the note.
ENTERED_DATE	DATE		Yes	The date on which the note was entered.
SOURCE_OBJECT_MEANING	VARCHAR2	(30)	Yes	Meaning of source object code
NOTE_TYPE	VARCHAR2	(30)		The type of the note. Normally user defined from the setup screen. Stored in fnd_lookups for the lookup type of JTF_NOTE_TYPE.
NOTE_TYPE_MEANING	VARCHAR2	(80)		Description of note type from FND_LOOKUPS
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
CONTEXT	VARCHAR2	(30)		Standard flex Field Column.
NOTE_STATUS_MEANING	VARCHAR2	(80)	Yes	Note status meaning stored in fnd_lookups for the lookup type of JTF_NOTE_STATUS.
DECODED_SOURCE_CODE	VARCHAR2	(240)		Decoded SOURCE_OBJECT_CODE.
DECODED_SOURCE_MEANING	VARCHAR2	(30)		Decoded SOURCE_OBJECT_MEANING.

Query Text

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


SELECT ROW_ID
,      JTF_NOTE_ID
,      PARENT_NOTE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_CODE
,      SOURCE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NOTES
,      NOTES_DETAIL
,      NOTE_STATUS
,      ENTERED_BY
,      ENTERED_BY_NAME
,      ENTERED_DATE
,      SOURCE_OBJECT_MEANING
,      NOTE_TYPE
,      NOTE_TYPE_MEANING
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      NOTE_STATUS_MEANING
,      DECODED_SOURCE_CODE
,      DECODED_SOURCE_MEANING
FROM APPS.JTF_NOTES_VL;

Dependencies

[top of page]

APPS.JTF_NOTES_VL references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_COMMON_PVT - show dependent code; JTF_NOTES_B; JTF_NOTES_PKG - show dependent code; JTF_NOTES_TL; JTF_OBJECTS_B; JTF_OBJECTS_TL

APPS.JTF_NOTES_VL is referenced by following:

APPS: AHL_MEL_CDL_APPROVALS_PVT - show dependent code; AHL_MEL_CDL_ATA_SEQS_PVT - show dependent code; AHL_MEL_CDL_HEADERS_PVT - show dependent code; AHL_PRD_WO_PUB - show dependent code; AMS_APPROVAL_PVT - show dependent code; ASO_COPY_QUOTE_PVT - show dependent code; CSC_SR_KB_NOTE_LINKS_V; CSD_SPLIT_PKG - show dependent code; CSF_ALERTS_PUB - show dependent code; CSZ_SERVICEREQUEST_UTIL_PVT - show dependent code; CS_INCIDENTS_DIARY_V; CS_KB_KWIC_UTIL - show dependent code; CS_SR_CHILD_AUDIT_PKG - show dependent code; CS_SR_FUL_PKG - show dependent code; CS_SR_LOG_DATA_TEMP_PVT - show dependent code; CS_SR_LOG_PKG - show dependent code; CS_WF_ACTIVITIES_PKG - show dependent code; DPP_REQUEST_STATUS_PVT - show dependent code; JTF_IH_ALL_NOTES_VL; JTF_IH_NOTES_ACT_VL; JTF_IH_NOTES_VL; JTF_NOTES_PUB - show dependent code; JTF_TASKS_PUB - show dependent code; OKC_LAUNCH_COMMGRID_V; OKL_CS_LC_CONTRACT_PVT - show dependent code; OKS_COVERAGES_PVT - show dependent code; OKS_MASS_UPDATE_PVT - show dependent code; OKS_SETUP_UTIL_PUB - show dependent code; OZF_FUND_REQUEST_APR_PVT - show dependent code; OZF_REQUEST_STATUS_PVT - show dependent code; PV_AME_API_W - show dependent code; PV_BENFT_STATUS_CHANGE - show dependent code; PV_GE_HIST_LOG_PVT - show dependent code; PV_WORKFLOW_PUB - show dependent code