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_FM_AMV_ATTACH_VL

Object Details

Object Name:	JTF_FM_AMV_ATTACH_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_FM_AMV_ATTACH_VL
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		The Row Identifier of the AMV Item Attachments
ATTACHMENT_ID	NUMBER		Yes	The Attachment Identifier of the AMV Item Attachments
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)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	NUMBER	(9)		The Object Version Number of the AMV Item Attachments
OWNER_USER_ID	NUMBER	(15)		The Owner User Identifier of the AMV Item Attachments
ATTACHMENT_USED_BY_ID	NUMBER		Yes	The Attachment Used By Identifier of the AMV Item Attachments
ATTACHMENT_USED_BY	VARCHAR2	(30)	Yes	The Attachment Used By of the AMV Item Attachments
VERSION	VARCHAR2	(20)		The Version of the AMV Item Attachments
ENABLED_FLAG	VARCHAR2	(1)		The Enabled Flag of the AMV Item Attachments
CAN_FULFILL_ELECTRONIC_FLAG	VARCHAR2	(1)		The Can Fulfill Electronic Flag of the AMV Item Attachments
FILE_ID	NUMBER			The File Identifier of the AMV Item Attachments
FILE_NAME	VARCHAR2	(240)		The File Name of the AMV Item Attachments
FILE_EXTENSION	VARCHAR2	(20)		The File Extension of the AMV Item Attachments
KEYWORDS	VARCHAR2	(240)		The Keywords of the AMV Item Attachments
DISPLAY_WIDTH	NUMBER	(15)		The Display Width of the AMV Item Attachments
DISPLAY_HEIGHT	NUMBER	(15)		The Display Height of the AMV Item Attachments
DISPLAY_LOCATION	VARCHAR2	(2000)		The Display Location of the AMV Item Attachments
LINK_TO	VARCHAR2	(2000)		The Link To of the AMV Item Attachments
LINK_URL	VARCHAR2	(2000)		The Link Url of the AMV Item Attachments
SEND_FOR_PREVIEW_FLAG	VARCHAR2	(1)		The Send For Preview Flag of the AMV Item Attachments
ATTACHMENT_TYPE	VARCHAR2	(30)		The Attachment Type of the AMV Item Attachments
LANGUAGE_CODE	VARCHAR2	(4)		The Language Code of the AMV Item Attachments
APPLICATION_ID	NUMBER		Yes	The Application Identifier of the AMV Item Attachments
DESCRIPTION	VARCHAR2	(2000)		The Description of the AMV Item Attachments
DEFAULT_STYLE_SHEET	VARCHAR2	(240)		The Default Style Sheet of the AMV Item Attachments
DISPLAY_URL	VARCHAR2	(1024)		The Display Url of the AMV Item Attachments
DISPLAY_RULE_ID	NUMBER			The Display Rule Identifier of the AMV Item Attachments
DISPLAY_PROGRAM	VARCHAR2	(240)		The Display Program of the AMV Item Attachments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
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
F_DELETEDFLAG	VARCHAR2	(0)		The F Deletedflag of the AMV Item Attachments

Query Text

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


SELECT ROW_ID
,      ATTACHMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OWNER_USER_ID
,      ATTACHMENT_USED_BY_ID
,      ATTACHMENT_USED_BY
,      VERSION
,      ENABLED_FLAG
,      CAN_FULFILL_ELECTRONIC_FLAG
,      FILE_ID
,      FILE_NAME
,      FILE_EXTENSION
,      KEYWORDS
,      DISPLAY_WIDTH
,      DISPLAY_HEIGHT
,      DISPLAY_LOCATION
,      LINK_TO
,      LINK_URL
,      SEND_FOR_PREVIEW_FLAG
,      ATTACHMENT_TYPE
,      LANGUAGE_CODE
,      APPLICATION_ID
,      DESCRIPTION
,      DEFAULT_STYLE_SHEET
,      DISPLAY_URL
,      DISPLAY_RULE_ID
,      DISPLAY_PROGRAM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      F_DELETEDFLAG
FROM APPS.JTF_FM_AMV_ATTACH_VL;

Dependencies

[top of page]

APPS.JTF_FM_AMV_ATTACH_VL references the following:

APPS: JTF_AMV_ATTACHMENTS_V

APPS.JTF_FM_AMV_ATTACH_VL is referenced by following:

APPS: JTF_FM_QUERY_LINK_PKG - show dependent code