[Home] [Help]
View: AXFV_DOCUMENT_HISTORIES
Product: | AX - Global Accounting Engine |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT E.EVENT_ID
, APP.APPLICATION_NAME
, SOB.NAME
, E.EVENT_DATE
, E.EVENT_TYPE
, E.EVENT_FIELD1
, E.TRANSLATION_STATUS
, E.MESSAGE_TEXT
, E.APPLICATION_ID
, E.SET_OF_BOOKS_ID
, E.CREATED_BY
, E.CREATION_DATE
, E.LAST_UPDATED_BY
, E.LAST_UPDATE_DATE
FROM AX_EVENTS E
, FND_APPLICATION_VL APP
, GL_SETS_OF_BOOKS SOB
WHERE E.APPLICATION_ID = APP.APPLICATION_ID AND SOB.SET_OF_BOOKS_ID = E.SET_OF_BOOKS_ID WITH READ ONLY
Columns
Name |
EVENT_ID |
APPLICATION_NAME |
SET_OF_BOOKS_NAME |
ACCOUNTING_DATE |
DOCUMENT_CATEGORY |
DOCUMENT_ID |
TRANSLATION_STATUS |
MESSAGE |
APPLICATION_ID |
SET_OF_BOOKS_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |