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


VIEW: APPS.AMS_P_ACT_ATTACHMENTS_V

Object Details
Object Name: AMS_P_ACT_ATTACHMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_P_ACT_ATTACHMENTS_V
Subobject Name:
Status: VALID

View Type

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


This Public view returns the attachement associated with marketing activity.


[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 VARCHAR2 (10) Yes Format of the file.
KEYWORDS VARCHAR2 (240)
Keywords associated with the attached file.
DISPLAY_WIDTH NUMBER (15)
Display height, width and location for the attached image file. These columns are used by i-marketing application.
DISPLAY_HEIGHT NUMBER (15)
Display height, width and location for the attached image file. These columns are used by i-marketing application.
DISPLAY_LOCATION VARCHAR2 (2000)
Display height, width and location for the attached image file. These columns are used by i-marketing application.
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)
These columns are used by i-marketing application. Stores the display parameters for the attached file.
DISPLAY_URL VARCHAR2 (1024)
These columns are used by i-marketing application. Stores the display parameters for the attached file.
DISPLAY_RULE_ID NUMBER

These columns are used by i-marketing application. Stores the display parameters for the attached file.
DISPLAY_PROGRAM VARCHAR2 (240)
These columns are used by i-marketing application. Stores the 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_P_ACT_ATTACHMENTS_V;

Dependencies

[top of page]

APPS.AMS_P_ACT_ATTACHMENTS_V references the following:

SchemaAPPS
ViewAMS_LOOKUPS
SynonymFND_LOBS
SynonymFND_USER
ViewJTF_AMV_ATTACHMENTS_V

APPS.AMS_P_ACT_ATTACHMENTS_V is not referenced by any database object