VIEW: APPS.WIP_COMMENT_CODES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'