VIEW: APPS.FND_ATTACHED_DOCS_FORM_VL

Source

View Text - Preformatted

SELECT AD.SEQ_NUM, DCT.USER_NAME, DT.DESCRIPTION , DAT.USER_NAME , D.STORAGE_TYPE , D.FILE_NAME , D.IMAGE_TYPE , D.USAGE_TYPE , AD.AUTOMATICALLY_ADDED_FLAG , AD.ATTACHED_DOCUMENT_ID , DET.USER_ENTITY_NAME , D.DATATYPE_ID , D.DOCUMENT_ID , AD.CREATION_DATE , D.START_DATE_ACTIVE , D.END_DATE_ACTIVE , D.SECURITY_TYPE , D.SECURITY_ID , D.PUBLISH_FLAG , AD.CREATED_BY , DET.USER_ENTITY_PROMPT , AD.LAST_UPDATE_DATE , AD.LAST_UPDATED_BY , AD.LAST_UPDATE_LOGIN , AD.ENTITY_NAME , AD.COLUMN1 , AD.PK1_VALUE , AD.PK2_VALUE , AD.PK3_VALUE , AD.PK4_VALUE , AD.PK5_VALUE , D.MEDIA_ID , AD.ROWID , AD.PROGRAM_APPLICATION_ID , AD.PROGRAM_ID , AD.PROGRAM_UPDATE_DATE , AD.REQUEST_ID , D.CATEGORY_ID , AF.FUNCTION_NAME , AF.FUNCTION_TYPE , AD.ATTRIBUTE_CATEGORY , AD.ATTRIBUTE1 , AD.ATTRIBUTE2 , AD.ATTRIBUTE3 , AD.ATTRIBUTE4 , AD.ATTRIBUTE5 , AD.ATTRIBUTE6 , AD.ATTRIBUTE7 , AD.ATTRIBUTE8 , AD.ATTRIBUTE9 , AD.ATTRIBUTE10 , AD.ATTRIBUTE11 , AD.ATTRIBUTE12 , AD.ATTRIBUTE13 , AD.ATTRIBUTE14 , AD.ATTRIBUTE15 , DT.DOC_ATTRIBUTE_CATEGORY , DT.DOC_ATTRIBUTE1 , DT.DOC_ATTRIBUTE2 , DT.DOC_ATTRIBUTE3 , DT.DOC_ATTRIBUTE4 , DT.DOC_ATTRIBUTE5 , DT.DOC_ATTRIBUTE6 , DT.DOC_ATTRIBUTE7 , DT.DOC_ATTRIBUTE8 , DT.DOC_ATTRIBUTE9 , DT.DOC_ATTRIBUTE10 , DT.DOC_ATTRIBUTE11 , DT.DOC_ATTRIBUTE12 , DT.DOC_ATTRIBUTE13 , DT.DOC_ATTRIBUTE14 , DT.DOC_ATTRIBUTE15, D.URL, DT.TITLE, D.ORIG_DOC_ID, AD.ORIG_ATTACH_DOC_ID FROM FND_DOCUMENT_DATATYPES DAT, FND_DOCUMENT_ENTITIES_TL DET, FND_DOCUMENTS_TL DT, FND_DOCUMENTS D, FND_DOCUMENT_CATEGORIES_TL DCT, FND_DOC_CATEGORY_USAGES DCU, FND_ATTACHMENT_FUNCTIONS AF, FND_ATTACHED_DOCUMENTS AD WHERE D.DOCUMENT_ID = AD.DOCUMENT_ID AND DT.DOCUMENT_ID = D.DOCUMENT_ID AND DT.LANGUAGE = USERENV('LANG') AND DCT.CATEGORY_ID = D.CATEGORY_ID AND DCT.LANGUAGE = USERENV('LANG') AND DCU.CATEGORY_ID = D.CATEGORY_ID AND DCU.ATTACHMENT_FUNCTION_ID = AF.ATTACHMENT_FUNCTION_ID AND D.DATATYPE_ID = DAT.DATATYPE_ID AND DAT.LANGUAGE = USERENV('LANG')AND AD.ENTITY_NAME = DET.DATA_OBJECT_CODE AND DET.LANGUAGE =USERENV('LANG') AND DCU.ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT AD.SEQ_NUM
, DCT.USER_NAME
, DT.DESCRIPTION
, DAT.USER_NAME
, D.STORAGE_TYPE
, D.FILE_NAME
, D.IMAGE_TYPE
, D.USAGE_TYPE
, AD.AUTOMATICALLY_ADDED_FLAG
, AD.ATTACHED_DOCUMENT_ID
, DET.USER_ENTITY_NAME
, D.DATATYPE_ID
, D.DOCUMENT_ID
, AD.CREATION_DATE
, D.START_DATE_ACTIVE
, D.END_DATE_ACTIVE
, D.SECURITY_TYPE
, D.SECURITY_ID
, D.PUBLISH_FLAG
, AD.CREATED_BY
, DET.USER_ENTITY_PROMPT
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_LOGIN
, AD.ENTITY_NAME
, AD.COLUMN1
, AD.PK1_VALUE
, AD.PK2_VALUE
, AD.PK3_VALUE
, AD.PK4_VALUE
, AD.PK5_VALUE
, D.MEDIA_ID
, AD.ROWID
, AD.PROGRAM_APPLICATION_ID
, AD.PROGRAM_ID
, AD.PROGRAM_UPDATE_DATE
, AD.REQUEST_ID
, D.CATEGORY_ID
, AF.FUNCTION_NAME
, AF.FUNCTION_TYPE
, AD.ATTRIBUTE_CATEGORY
, AD.ATTRIBUTE1
, AD.ATTRIBUTE2
, AD.ATTRIBUTE3
, AD.ATTRIBUTE4
, AD.ATTRIBUTE5
, AD.ATTRIBUTE6
, AD.ATTRIBUTE7
, AD.ATTRIBUTE8
, AD.ATTRIBUTE9
, AD.ATTRIBUTE10
, AD.ATTRIBUTE11
, AD.ATTRIBUTE12
, AD.ATTRIBUTE13
, AD.ATTRIBUTE14
, AD.ATTRIBUTE15
, DT.DOC_ATTRIBUTE_CATEGORY
, DT.DOC_ATTRIBUTE1
, DT.DOC_ATTRIBUTE2
, DT.DOC_ATTRIBUTE3
, DT.DOC_ATTRIBUTE4
, DT.DOC_ATTRIBUTE5
, DT.DOC_ATTRIBUTE6
, DT.DOC_ATTRIBUTE7
, DT.DOC_ATTRIBUTE8
, DT.DOC_ATTRIBUTE9
, DT.DOC_ATTRIBUTE10
, DT.DOC_ATTRIBUTE11
, DT.DOC_ATTRIBUTE12
, DT.DOC_ATTRIBUTE13
, DT.DOC_ATTRIBUTE14
, DT.DOC_ATTRIBUTE15
, D.URL
, DT.TITLE
, D.ORIG_DOC_ID
, AD.ORIG_ATTACH_DOC_ID
FROM FND_DOCUMENT_DATATYPES DAT
, FND_DOCUMENT_ENTITIES_TL DET
, FND_DOCUMENTS_TL DT
, FND_DOCUMENTS D
, FND_DOCUMENT_CATEGORIES_TL DCT
, FND_DOC_CATEGORY_USAGES DCU
, FND_ATTACHMENT_FUNCTIONS AF
, FND_ATTACHED_DOCUMENTS AD
WHERE D.DOCUMENT_ID = AD.DOCUMENT_ID
AND DT.DOCUMENT_ID = D.DOCUMENT_ID
AND DT.LANGUAGE = USERENV('LANG')
AND DCT.CATEGORY_ID = D.CATEGORY_ID
AND DCT.LANGUAGE = USERENV('LANG')
AND DCU.CATEGORY_ID = D.CATEGORY_ID
AND DCU.ATTACHMENT_FUNCTION_ID = AF.ATTACHMENT_FUNCTION_ID
AND D.DATATYPE_ID = DAT.DATATYPE_ID
AND DAT.LANGUAGE = USERENV('LANG')AND AD.ENTITY_NAME = DET.DATA_OBJECT_CODE
AND DET.LANGUAGE =USERENV('LANG')
AND DCU.ENABLED_FLAG = 'Y'