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

Object Details

Object Name:	AMS_ACT_ATTACHMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_ACT_ATTACHMENTS_V
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)		Unique identifier generated by the database
ATTACHMENT_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard WHO Columns
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes .
OWNER_USER_ID	NUMBER	(15)		Owner user id of the attachment.
USER_NAME	VARCHAR2	(100)	Yes	Owner name of the attachment.
ATTACHMENT_USED_BY_ID	NUMBER		Yes	Column records the Id for the object using a specific attachment. e.g list ID
ATTACHMENT_USED_BY	VARCHAR2	(30)	Yes	Column records the kind of object using a specific attachment e.g. CAMP for Campaign
VERSION	VARCHAR2	(20)		Version of the attachment.Same attachment file can more than one version for eg. 1.0 ,1.1 etc.
ENABLED_FLAG	VARCHAR2	(1)		Indicates wether a particular attachment is enabled or not.
CAN_FULFILL_ELECTRONIC_FLAG	VARCHAR2	(1)		Whether it can be attached electronically (from screen) or it has to be a physical delivery.
FILE_ID	NUMBER			Unique identifier of the file.
FILE_NAME	VARCHAR2	(240)		Name of the File.
FILE_EXTENSION	VARCHAR2	(20)		Extension of the file.
FILE_FORMAT	CHAR	(2)		Format of the file.
KEYWORDS	VARCHAR2	(240)		Keywords associated with this attached file.
DISPLAY_WIDTH	NUMBER	(15)		Display width & height for the attached image file.
DISPLAY_HEIGHT	NUMBER	(15)		Display width & height for the attached image file.
DISPLAY_LOCATION	VARCHAR2	(2000)		Display location for the associated image file. e.g. MID, RIGHT.
LINK_TO	VARCHAR2	(2000)		Link associated with the file.
LINK_URL	VARCHAR2	(2000)		URL associated with the file.
SEND_FOR_PREVIEW_FLAG	VARCHAR2	(1)		Does the attached file needs to be sent for review.
ATTACHMENT_TYPE	VARCHAR2	(30)		Type of Attachment eg. text , image etc.
MEANING	VARCHAR2	(80)	Yes	Meaning of the attachment type.
LANGUAGE_CODE	VARCHAR2	(4)		Language code for the file attached.
APPLICATION_ID	NUMBER		Yes	Application that owns the attachment.
DESCRIPTION	VARCHAR2	(2000)		Description of the attachment.
DEFAULT_STYLE_SHEET	VARCHAR2	(240)		I-Marketing related columns. Stores display parameters for the attached file.
DISPLAY_URL	VARCHAR2	(1024)		I-Marketing related columns. Stores display parameters for the attached file.
DISPLAY_RULE_ID	NUMBER			I-Marketing related columns. Stores display parameters for the attached file.
DISPLAY_PROGRAM	VARCHAR2	(240)		I-Marketing related columns. Stores display parameters for the attached file.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining 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.

Query Text

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


SELECT ROW_ID
,      ATTACHMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OWNER_USER_ID
,      USER_NAME
,      ATTACHMENT_USED_BY_ID
,      ATTACHMENT_USED_BY
,      VERSION
,      ENABLED_FLAG
,      CAN_FULFILL_ELECTRONIC_FLAG
,      FILE_ID
,      FILE_NAME
,      FILE_EXTENSION
,      FILE_FORMAT
,      KEYWORDS
,      DISPLAY_WIDTH
,      DISPLAY_HEIGHT
,      DISPLAY_LOCATION
,      LINK_TO
,      LINK_URL
,      SEND_FOR_PREVIEW_FLAG
,      ATTACHMENT_TYPE
,      MEANING
,      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
FROM APPS.AMS_ACT_ATTACHMENTS_V;

Dependencies

[top of page]

APPS.AMS_ACT_ATTACHMENTS_V references the following:

APPS: AMS_LOOKUPS; FND_USER; JTF_AMV_ATTACHMENTS_V

APPS.AMS_ACT_ATTACHMENTS_V is not referenced by any database object