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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FND_DOCUMENTS_VL

Object Details

Object Name:	FND_DOCUMENTS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_DOCUMENTS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

This view resolves issues regarding which language of a document is
viewed.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
DOCUMENT_ID	NUMBER		Yes	Document identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
DATATYPE_ID	NUMBER		Yes	Datatype identifier
DATATYPE_NAME	VARCHAR2	(80)	Yes	Developer name for the datatype
DESCRIPTION	VARCHAR2	(255)		Document description
FILE_NAME	VARCHAR2	(2048)		File name of the document
MEDIA_ID	NUMBER			Media identifier
STORAGE_TYPE	NUMBER			Indicates whether the document is stored in the database or in the file system
CATEGORY_APPLICATION_ID	NUMBER			Category application identifier
CATEGORY_ID	NUMBER		Yes	Unique identifier sourced from the FND_DOCUMENT_CATEGORIES_S sequence
CATEGORY_DESCRIPTION	VARCHAR2	(255)	Yes	Category description
SECURITY_TYPE	NUMBER		Yes	Method of security used for the document
SECURITY_ID	NUMBER			ID associated with the security type (if security_type <>4)
PUBLISH_FLAG	VARCHAR2	(1)	Yes	A flag that determines if a document is shared outside it's security type
IMAGE_TYPE	VARCHAR2	(10)		Image format
USAGE_TYPE	VARCHAR2	(1)		Indicator of how the document can be used
USAGE_TYPE_DESCR	VARCHAR2	(80)	Yes	Description of the documents usage type
START_DATE_ACTIVE	DATE			Date on which the document is available for use
END_DATE_ACTIVE	DATE			Date on which the document is no longer available for use
REQUEST_ID	NUMBER			Request identifier
PROGRAM_APPLICATION_ID	NUMBER			Program application identifier
PROGRAM_ID	NUMBER			Program identifier
PROGRAM_UPDATE_DATE	DATE			Last update date of this record
DOC_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category
DOC_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
DOC_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
DM_NODE	NUMBER
DM_FOLDER_PATH	VARCHAR2	(1000)
DM_TYPE	VARCHAR2	(30)
DM_DOCUMENT_ID	NUMBER
DM_VERSION_NUMBER	VARCHAR2	(225)
URL	VARCHAR2	(4000)		url for web page
TITLE	VARCHAR2	(80)		title of document

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      DOCUMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DATATYPE_ID
,      DATATYPE_NAME
,      DESCRIPTION
,      FILE_NAME
,      MEDIA_ID
,      STORAGE_TYPE
,      CATEGORY_APPLICATION_ID
,      CATEGORY_ID
,      CATEGORY_DESCRIPTION
,      SECURITY_TYPE
,      SECURITY_ID
,      PUBLISH_FLAG
,      IMAGE_TYPE
,      USAGE_TYPE
,      USAGE_TYPE_DESCR
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      DM_NODE
,      DM_FOLDER_PATH
,      DM_TYPE
,      DM_DOCUMENT_ID
,      DM_VERSION_NUMBER
,      URL
,      TITLE
FROM APPS.FND_DOCUMENTS_VL;

Dependencies

[top of page]

APPS.FND_DOCUMENTS_VL references the following:

APPS: FND_DOCUMENTS; FND_DOCUMENTS_TL; FND_DOCUMENT_CATEGORIES; FND_DOCUMENT_CATEGORIES_TL; FND_DOCUMENT_DATATYPES; FND_LOOKUP_VALUES

APPS.FND_DOCUMENTS_VL is referenced by following:

APPS: ADI_DISPLAY_REPORT - show dependent code; ADI_WEB_FILES_VL; DOM_ATTACHMENT_UTIL_PKG - show dependent code; EAM_WORKORDERREP_PVT - show dependent code; EDR_FILE_UTIL_PUB - show dependent code; EDR_ISIGN_CHECKLIST_PVT - show dependent code; EDR_ISIGN_TEMPLATE_PKG - show dependent code; ENGECOBO - show dependent code; FND_DM_REPOSITORY_PKG - show dependent code; GR_ATTACH_DOCUMENTS_PKG - show dependent code; GR_DISPATCH_HISTORY_PVT - show dependent code; GR_DISPATCH_HISTORY_V; GR_REG_PRINT_DOC - show dependent code; INV_ATTACHMENTS_UTILS - show dependent code; ITG_X_UTILS - show dependent code; OE_FND_ATTACHMENTS_PVT - show dependent code; PON_PRINTING_PKG - show dependent code; PO_COMMUNICATION_PVT - show dependent code; PO_ECX_ATTACHMENTS_V; PO_NEGOTIATIONS_SV2 - show dependent code; PO_XML_UTILS_GRP - show dependent code; PSP_ER_WORKFLOW - show dependent code; PSP_ROLLBACK_EFF_REPORTS - show dependent code; PSP_XMLGEN - show dependent code; RRS_SITE_INFO - show dependent code; WIP_COMMENT_CODES_V; WIP_ENTITY_COMMENTS_V; WIP_OPERATION_INSTRUCTIONS_V