View: AMS_P_ACT_ATTACHMENTS_V

Product:	AMS - Marketing
Description:	This Public view returns the attachement associated with marketing activity.
Implementation/DBA Data:	APPS.AMS_P_ACT_ATTACHMENTS_V

View Text

SELECT A.ROW_ID ROW_ID
, A.ATTACHMENT_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.OWNER_USER_ID
, U.USER_NAME
, A.ATTACHMENT_USED_BY_ID
, A.ATTACHMENT_USED_BY
, A.VERSION
, A.ENABLED_FLAG
, A.CAN_FULFILL_ELECTRONIC_FLAG
, A.FILE_ID
, A.FILE_NAME
, A.FILE_EXTENSION
, L.FILE_FORMAT
, A.KEYWORDS
, A.DISPLAY_WIDTH
, A.DISPLAY_HEIGHT
, A.DISPLAY_LOCATION
, A.LINK_TO
, A.LINK_URL
, A.SEND_FOR_PREVIEW_FLAG
, A.ATTACHMENT_TYPE
, K.MEANING
, A.LANGUAGE_CODE
, A.APPLICATION_ID
, A.DESCRIPTION
, A.DEFAULT_STYLE_SHEET
, A.DISPLAY_URL
, A.DISPLAY_RULE_ID
, A.DISPLAY_PROGRAM
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM JTF_AMV_ATTACHMENTS_V A
, FND_USER U
, FND_LOBS L
, AMS_LOOKUPS K
WHERE A.FILE_ID = L.FILE_ID
AND A.OWNER_USER_ID = U.USER_ID
AND K.LOOKUP_TYPE = 'AMS_ATTACHMENT_TYPE'
AND A.ATTACHMENT_TYPE = K.LOOKUP_CODE

Columns