FND_DOCUMENT_ENTITIES_VL
詳細
-
スキーマ: ATTACHMENTS
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 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 |