VIEW: APPS.AMS_P_ACT_ATTACHMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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