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]

TABLE: APPLSYS.FND_DOCUMENTS

Object Details

Object Name:	FND_DOCUMENTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_DOCUMENTS
Subobject Name:
Status:	VALID

FND_DOCUMENTS stores language-independent
information about a document. For
example, each row contains a document
identifier, a category identifier, the
method of security used for the document
(SECURITY_TYPE, where 1=Organization,
2=Set of Books, 3=Business unit,
4=None), the period in which the document
is active, and a flag to indicate whether
or not the document can be shared outside
of the security type (PUBLISH_FLAG).

Other specifications in this table include:
datatype (DATATYPE_ID, where 1=short text,
2=long text, 3=image, 4=OLE object), image
type, and storage type (STORAGE_TYPE, where
1=stored in the database, 2=stored in the file system).
The document can be referenced by
many application entities and changed only
in the define document form (USAGE_TYPE=S);
it can be used as a fill-in-the-blanks
document, where each time you use a template,
you make a copy of it (USAGE_TYPE=T); or
it can be used only one time (USAGE_TYPE=O).
Images and OLE Objects cannot be used as
templates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_DOCUMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID
FND_DOCUMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIA_ID
FND_DOCUMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DM_DOCUMENT_ID
FND_DOCUMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FILE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
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
CATEGORY_ID	NUMBER		Yes	Unique identifier sourced from the FND_DOCUMENT_CATEGORIES_S sequence
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
STORAGE_TYPE	NUMBER			Indicates whether the document is stored in the database or in the file system
USAGE_TYPE	VARCHAR2	(1)		Indicator of how the document can be used
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
APP_SOURCE_VERSION	VARCHAR2	(255)		Column to ensure R10 to 10sc compatability
DM_NODE	NUMBER			DM_NODE
DM_FOLDER_PATH	VARCHAR2	(1000)		DM_FOLDER_PATH
DM_TYPE	VARCHAR2	(30)		DM_TYPE
DM_DOCUMENT_ID	NUMBER			For Document managment doc Id
DM_VERSION_NUMBER	VARCHAR2	(225)		DM_VERSION_NUMBER
URL	VARCHAR2	(4000)		url for web page
MEDIA_ID	NUMBER			Identifier of the sub-table in which the document is stored
FILE_NAME	VARCHAR2	(2048)		filename for document

Query Text

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


SELECT DOCUMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DATATYPE_ID
,      CATEGORY_ID
,      SECURITY_TYPE
,      SECURITY_ID
,      PUBLISH_FLAG
,      IMAGE_TYPE
,      STORAGE_TYPE
,      USAGE_TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      APP_SOURCE_VERSION
,      DM_NODE
,      DM_FOLDER_PATH
,      DM_TYPE
,      DM_DOCUMENT_ID
,      DM_VERSION_NUMBER
,      URL
,      MEDIA_ID
,      FILE_NAME
FROM APPLSYS.FND_DOCUMENTS;

Dependencies

[top of page]

APPLSYS.FND_DOCUMENTS does not reference any database object

APPLSYS.FND_DOCUMENTS is referenced by following:

APPS: FND_DOCUMENTS; FND_DOCUMENTS_PO_DAR; FND_DOCUMENTS_PO_UBR