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_SOURCE_TYPE_MAP_V

Object Details

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

View Type

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

View over JTF_OBJECT_MAPPINGS_V

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id from the base table JTF_OBJECT_MAPPINGS.
NOTE_SOURCE_TYPE_MAP_ID	NUMBER		Yes	Mapping Identifier from the base table JTF_OBJECT_MAPPINGS.
SOURCE_OBJECT_CODE	VARCHAR2	(30)	Yes	Identifies the source. Linked to the lookup code in the fnd lookups table where lookup_type is 'JTF_OBJECT_SOURCE_TYPE'.
SOURCE_MEANING	VARCHAR2	(30)	Yes	Identifies the source object meaning. Linked to the lookup code in the fnd lookups table where lookup_type is 'JTF_OBJECT_SOURCE_TYPE'.
NOTE_TYPE	VARCHAR2	(30)	Yes	The type of the note. Normally user defined from the setup screen. Stored in fnd_lookups for the lookup type of JTF_NOTE_TYPE.
TYPE_MEANING	VARCHAR2	(80)	Yes	Note type meaning stored in fnd_lookups for the lookup type of JTF_NOTE_TYPE.
END_DATE	DATE			Source object end date defined in base table JTF_OBJECT_MAPPINGS.
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).
APPLICATION_ID	NUMBER	(15)		Application identifier
SEEDED_FLAG	VARCHAR2	(1)		Seeded record identifier.
OBJECT_CODE	CHAR	(13)		Stored as 'JTF_NOTE_TYPE'.

Query Text

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


SELECT ROW_ID
,      NOTE_SOURCE_TYPE_MAP_ID
,      SOURCE_OBJECT_CODE
,      SOURCE_MEANING
,      NOTE_TYPE
,      TYPE_MEANING
,      END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      SEEDED_FLAG
,      OBJECT_CODE
FROM APPS.JTF_NOTES_SOURCE_TYPE_MAP_V;

Dependencies

[top of page]

APPS.JTF_NOTES_SOURCE_TYPE_MAP_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_OBJECTS_PVT - show dependent code; JTF_OBJECTS_VL; JTF_OBJECT_MAPPINGS_V

APPS.JTF_NOTES_SOURCE_TYPE_MAP_V is not referenced by any database object