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

VIEW: APPLSYS.FND_DOCUMENTS#

Object Details
Object Name: FND_DOCUMENTS#
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

DATATYPE_ID NUMBER
Yes
CATEGORY_ID NUMBER
Yes
SECURITY_TYPE NUMBER
Yes
SECURITY_ID NUMBER

PUBLISH_FLAG VARCHAR2 (1) Yes
IMAGE_TYPE VARCHAR2 (10)
STORAGE_TYPE NUMBER

USAGE_TYPE VARCHAR2 (1)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

APP_SOURCE_VERSION VARCHAR2 (255)
DM_NODE NUMBER

DM_FOLDER_PATH VARCHAR2 (1000)
DM_TYPE VARCHAR2 (30)
DM_DOCUMENT_ID NUMBER

DM_VERSION_NUMBER VARCHAR2 (225)
URL VARCHAR2 (4000)
MEDIA_ID NUMBER

FILE_NAME VARCHAR2 (2048)
ORIG_DOC_ID NUMBER

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
,      ORIG_DOC_ID
FROM APPLSYS.FND_DOCUMENTS#;

Dependencies

[top of page]

APPLSYS.FND_DOCUMENTS# references the following:

SchemaAPPLSYS
TableFND_DOCUMENTS
APPLSYS.FND_DOCUMENTS# is referenced by following:

SchemaAPPS
SynonymFND_DOCUMENTS