Product: | AX - Global Accounting Engine |
---|---|
Description: | Replacement for the AP table, AP_AE_HEADERS_ALL, when the AX accounting engine is used. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AXSH.JOURNAL_SEQUENCE_ID JOURNAL_SEQUENCE_ID
, AXSH.SLE_HEADER_ID AE_HEADER_ID
, AXSH.EVENT_ID ACCOUNTING_EVENT_ID
, AXE.EVENT_FIELD1 DOCUMENT_ID
, AXSH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AX_PAYABLES_PKG.AE_CATEGORY (AXE.EVENT_TYPE) AE_CATEGORY
, AX_PAYABLES_PKG.AE_CROSS_CURRENCY_FLAG (AXE.EVENT_TYPE
, AXE.EVENT_FIELD1
, AXSH.CURRENCY_CODE) CROSS_CURRENCY_FLAG
, AXSH.PERIOD_NAME PERIOD_NAME
, AXSH.EFFECTIVE_DATE ACCOUNTING_DATE
, AXSH.GL_TRANSFER_FLAG GL_TRANSFER_FLAG
, AXSH.GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, AX_PAYABLES_PKG.AE_HEADER_DESCRIPTION (AXE.EVENT_TYPE
, AXSH.DESCRIPTION) DESCRIPTION
, AXSH.ORG_ID ORG_ID
, AXSH.CREATION_DATE CREATION_DATE
, AXSH.CREATED_BY CREATED_BY
, AXSH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AXSH.LAST_UPDATED_BY LAST_UPDATE_BY
, AXSH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AXSH.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AXSH.PROGRAM_APPLICATION_ID PROGRAM_APLICATION_ID
, AXSH.PROGRAM_ID PROGRAM_ID
, AXSH.REQUEST_ID REQUEST_ID
, NULL ACCOUNTING_ERROR_CODE
, NULL GL_TRANSFER_ERROR_CODE
FROM AX_EVENTS AXE
, AX_SLE_HEADERS AXSH
WHERE AXSH.APPLICATION_ID = 200
AND AXE.EVENT_ID = AXSH.EVENT_ID