FND_DOCUMENT_ENTITIES_VL

Details

• Schema: ATTACHMENTS

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID DOCUMENT_ENTITY_ID DATA_OBJECT_CODE TABLE_NAME ENTITY_NAME APPLICATION_ID APPLICATION_NAME MODULE_ID USER_ENTITY_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PK1_COLUMN PK2_COLUMN PK3_COLUMN PK4_COLUMN PK5_COLUMN DM_REPOSITORY DEFAULT_FOLDER CATEGORY_SECURITY_ENABLED EXPIRATION_ENABLED CONTROL_REST_DOWNLOAD ATTACHMENT_SECURITY_ENABLED

Query

SQL_Statement

SELECT FDE.ROWID ROW_ID , FDE.DOCUMENT_ENTITY_ID , FDE.DATA_OBJECT_CODE , FDE.TABLE_NAME , FDE.ENTITY_NAME, FDE.APPLICATION_ID , FATL.APPLICATION_NAME , FDE.MODULE_ID, TL.USER_ENTITY_NAME , FDE.CREATION_DATE , FDE.CREATED_BY , FDE.LAST_UPDATE_DATE , FDE.LAST_UPDATED_BY , FDE.LAST_UPDATE_LOGIN , FDE.PK1_COLUMN , FDE.PK2_COLUMN , FDE.PK3_COLUMN , FDE.PK4_COLUMN , FDE.PK5_COLUMN, FDE.DM_REPOSITORY, FDE.DEFAULT_FOLDER, FDE.CATEGORY_SECURITY_ENABLED, FDE.EXPIRATION_ENABLED, FDE.CONTROL_REST_DOWNLOAD, FDE.ATTACHMENT_SECURITY_ENABLED FROM FND_APPLICATION_VL FATL, FND_DOCUMENT_ENTITIES_TL TL, FND_DOCUMENT_ENTITIES FDE WHERE FDE.DOCUMENT_ENTITY_ID = TL.DOCUMENT_ENTITY_ID AND TL.LANGUAGE = USERENV('LANG') AND FDE.APPLICATION_ID = FATL.APPLICATION_ID