DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_IH_ALL_NOTES_VL

Object Details
Object Name: JTF_IH_ALL_NOTES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_IH_ALL_NOTES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Allows to view JTF notes attached to Interactions


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
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.
NOTE_CONTEXT_TYPE VARCHAR2 (240) Yes
NOTE_CONTEXT_TYPE_ID NUMBER
Yes The corresponding ID. Can be party id, site_use_id and employee id and so on
ACTIVITY_ID NUMBER (15) Yes Activity Identifier
LAST_UPDATE_DATE DATE
Yes Standard who column - operating system login of user when last updated this row
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - operating system login of user who last updated this row
CREATION_DATE DATE
Yes Standard who column - operating system login of user when created this row
CREATED_BY NUMBER (15) Yes Standard who column - operating system login of user who created this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row
Query Text

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


SELECT ROW_ID
,      NOTES
,      NOTE_CONTEXT_TYPE
,      NOTE_CONTEXT_TYPE_ID
,      ACTIVITY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.JTF_IH_ALL_NOTES_VL;

Dependencies

[top of page]

APPS.JTF_IH_ALL_NOTES_VL references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageJTF_COMMON_PVT - show dependent code
SynonymJTF_IH_ACTIVITIES
PL/SQL PackageJTF_NOTES_PKG - show dependent code
ViewJTF_NOTES_VL
SynonymJTF_NOTE_CONTEXTS

APPS.JTF_IH_ALL_NOTES_VL is not referenced by any database object