eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FND_ATTACHED_DOCS_FORM_VL

Product:	FND - Application Object Library
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FND_ATTACHED_DOCS_FORM_VL

View Text

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'

Columns

Name
SEQ_NUM
CATEGORY_DESCRIPTION
DOCUMENT_DESCRIPTION
DATATYPE_NAME
STORAGE_TYPE
FILE_NAME
IMAGE_TYPE
USAGE_TYPE
AUTOMATICALLY_ADDED_FLAG
ATTACHED_DOCUMENT_ID
USER_ENTITY_NAME
DATATYPE_ID
DOCUMENT_ID
CREATION_DATE
START_DATE_ACTIVE
END_DATE_ACTIVE
SECURITY_TYPE
SECURITY_ID
PUBLISH_FLAG
CREATED_BY
USER_ENTITY_PROMPT
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ENTITY_NAME
COLUMN1
PK1_VALUE
PK2_VALUE
PK3_VALUE
PK4_VALUE
PK5_VALUE
MEDIA_ID
ROW_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
CATEGORY_ID
FUNCTION_NAME
FUNCTION_TYPE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
DOC_ATTRIBUTE_CATEGORY
DOC_ATTRIBUTE1
DOC_ATTRIBUTE2
DOC_ATTRIBUTE3
DOC_ATTRIBUTE4
DOC_ATTRIBUTE5
DOC_ATTRIBUTE6
DOC_ATTRIBUTE7
DOC_ATTRIBUTE8
DOC_ATTRIBUTE9
DOC_ATTRIBUTE10
DOC_ATTRIBUTE11
DOC_ATTRIBUTE12
DOC_ATTRIBUTE13
DOC_ATTRIBUTE14
DOC_ATTRIBUTE15
URL
TITLE
ORIG_DOC_ID
ORIG_ATTACH_DOC_ID