FND_DOCUMENTS_VL

Details

• Schema: ATTACHMENTS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID DOCUMENT_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN DATATYPE_CODE BASE_DOCUMENT_ID DESCRIPTION USAGE_TYPE START_DATE_ACTIVE END_DATE_ACTIVE REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE POST_PROCESSING_CLASS POST_PROCESSING_PARAMETERS POST_PROCESSING_STATUS POST_PROCESSING_MESSAGE DM_NODE DM_FOLDER_PATH DM_TYPE DM_DOCUMENT_ID FILE_NAME DM_VERSION_NUMBER URL TITLE DOWNLOAD_STATUS DM_REPOSITORY DOCUMENT_ATTRIBUTES STATUS URI ENT_APP_SHORT_NAME TRUSTED_FLAG OBJECT_BUCKET OBJECT_NAME OBJECT_SIZE OBJECT_CONTENT_TYPE TRACKER_ID CEC_PARENT_ID CEC_FILE_ID SOURCE_CONTENT_TYPE

Query

SQL_Statement

SELECT D.ROWID ROW_ID, D.DOCUMENT_ID, D.CREATION_DATE, D.CREATED_BY, D.LAST_UPDATE_DATE, D.LAST_UPDATED_BY, D.LAST_UPDATE_LOGIN, D.DATATYPE_CODE, D.BASE_DOCUMENT_ID, DL.DESCRIPTION, D.USAGE_TYPE, D.START_DATE_ACTIVE, D.END_DATE_ACTIVE, D.REQUEST_ID, D.PROGRAM_APPLICATION_ID, D.PROGRAM_ID, D.PROGRAM_UPDATE_DATE, D.POST_PROCESSING_CLASS, D.POST_PROCESSING_PARAMETERS, D.POST_PROCESSING_STATUS, D.POST_PROCESSING_MESSAGE, DL.DM_NODE, DL.DM_FOLDER_PATH, DL.DM_TYPE, DL.DM_DOCUMENT_ID, DL.FILE_NAME, DL.DM_VERSION_NUMBER, DL.URL, DL.TITLE, DL.DOWNLOAD_STATUS, DL.DM_REPOSITORY, D.DOCUMENT_ATTRIBUTES, DL.STATUS, DL.URI, DL.ENT_APP_SHORT_NAME, DL.TRUSTED_FLAG, DL.OBJECT_BUCKET, DL.OBJECT_NAME, DL.OBJECT_SIZE, DL.OBJECT_CONTENT_TYPE, DL.TRACKER_ID, DL.CEC_PARENT_ID, DL.CEC_FILE_ID, DL.SOURCE_CONTENT_TYPE FROM FND_DOCUMENTS_TL DL, FND_DOCUMENTS D WHERE D.DOCUMENT_ID = DL.DOCUMENT_ID AND DL.LANGUAGE = USERENV('LANG')