View: WIP_COMMENT_CODES_V

Product:	WIP - Work in Process
Description:	Types of comments that can be attached to WIP entities
Implementation/DBA Data:	APPS.WIP_COMMENT_CODES_V

View Text

SELECT D.DESCRIPTION
, D.SECURITY_ID
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_LOGIN
, T.SHORT_TEXT
, D.DOC_ATTRIBUTE_CATEGORY
, D.DOC_ATTRIBUTE1
, D.DOC_ATTRIBUTE2
, D.DOC_ATTRIBUTE3
, D.DOC_ATTRIBUTE4
, D.DOC_ATTRIBUTE5
, D.DOC_ATTRIBUTE6
, D.DOC_ATTRIBUTE7
, D.DOC_ATTRIBUTE8
, D.DOC_ATTRIBUTE9
, D.DOC_ATTRIBUTE10
, D.DOC_ATTRIBUTE11
, D.DOC_ATTRIBUTE12
, D.DOC_ATTRIBUTE13
, D.DOC_ATTRIBUTE14
, D.DOC_ATTRIBUTE15
, NULL AS APP_SOURCE_VERSION
FROM FND_DOCUMENTS_SHORT_TEXT T
, FND_DOCUMENTS_VL D
, FND_DOCUMENT_CATEGORIES_VL C
WHERE T.MEDIA_ID = D.MEDIA_ID
AND D.DATATYPE_ID = 1
AND D.SECURITY_TYPE = 1
AND D.USAGE_TYPE='S'
AND D.PUBLISH_FLAG = 'N'
AND D.CATEGORY_ID = C.CATEGORY_ID
AND C.NAME = 'WIP_ENTITY_ATTACHMENTS'

Columns