FND_ATTACHED_DOCUMENTS_VL

Details

• Schema: ATTACHMENTS

• Object owner: FND

• Object type: VIEW

Columns

Name
ATTACHED_DOCUMENT_ID DOCUMENT_ID ENTITY_NAME PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE CATEGORY_NAME PRIMARY_CATEGORY_FLAG DM_DOCUMENT_ID DM_VERSION_NUMBER TITLE DESCRIPTION SEQ_NUM EXPIRATION_DATE ENTITY_ATTRIBUTES PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE REQUEST_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ATTACHED_DOCUMENT_ID ATTACHED_DOCUMENT_ID, B.DOCUMENT_ID DOCUMENT_ID, B.ENTITY_NAME ENTITY_NAME, B.PK1_VALUE PK1_VALUE, B.PK2_VALUE PK2_VALUE, B.PK3_VALUE PK3_VALUE, B.PK4_VALUE PK4_VALUE, B.PK5_VALUE PK5_VALUE, B.CATEGORY_NAME CATEGORY_NAME, B.PRIMARY_CATEGORY_FLAG PRIMARY_CATEGORY_FLAG, T.DM_DOCUMENT_ID DM_DOCUMENT_ID, T.DM_VERSION_NUMBER DM_VERSION_NUMBER, T.TITLE TITLE, T.DESCRIPTION DESCRIPTION, B.SEQ_NUM SEQ_NUM, B.EXPIRATION_DATE EXPIRATION_DATE, B.ENTITY_ATTRIBUTES ENTITY_ATTRIBUTES, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, B.PROGRAM_ID PROGRAM_ID, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, B.REQUEST_ID REQUEST_ID, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM FND_ATTACHED_DOCUMENTS B, FND_ATTACHED_DOCUMENTS_TL T WHERE B.ATTACHED_DOCUMENT_ID = T.ATTACHED_DOCUMENT_ID AND T.LANGUAGE = USERENV('LANG')