Product: | AX - Global Accounting Engine |
---|---|
Description: | Entry headers |
Implementation/DBA Data: | Not implemented in this database |
SELECT H.ROWID ROW_ID
, H.APPLICATION_ID
, H.SET_OF_BOOKS_ID
, H.JOURNAL_SEQUENCE_ID
, D.NAME JOURNAL_SEQUENCE_NAME
, H.SLE_HEADER_ID
, H.EFFECTIVE_DATE
, H.PERIOD_NAME
, H.REFERENCE_1
, H.CURRENCY_CODE
, H.CURRENCY_CONVERSION_DATE
, H.CURRENCY_CONVERSION_RATE
, H.CURRENCY_CONVERSION_TYPE
, C.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, H.LAST_UPDATE_DATE
, H.LAST_UPDATED_BY
, H.CREATION_DATE
, H.CREATED_BY
, H.LAST_UPDATE_LOGIN
, H.REQUEST_ID
, H.PROGRAM_APPLICATION_ID
, H.PROGRAM_ID
, H.PROGRAM_UPDATE_DATE
, H.EVENT_ID
, H.REFERENCE_2
, H.REFERENCE_3
, H.REFERENCE_4
, H.REFERENCE_5
, H.ORG_ID
, H.LEGAL_SEQUENCE_ID
, H.LEGAL_SEQUENCE_VALUE
, H.TRANSACTION_DATE
, H.REFERENCE_NUM1
, H.REFERENCE_NUM2
, H.REFERENCE_NUM3
, H.REFERENCE_NUM4
, H.REFERENCE_NUM5
, H.REFERENCE_DATE1
, H.REFERENCE_DATE2
, H.REFERENCE_DATE3
, H.REFERENCE_DATE4
, H.REFERENCE_DATE5
, H.DESCRIPTION
, H.DOC_SEQUENCE_ID
, H.DOC_SEQUENCE_NUMBER
, H.GL_TRANSFER_FLAG
, H.GL_TRANSFER_DATE
, H.GL_TRANSFER_RUN_ID
FROM AX_SLE_HEADERS H
, FND_DOCUMENT_SEQUENCES D
, GL_DAILY_CONVERSION_TYPES C
WHERE H.JOURNAL_SEQUENCE_ID = D.DOC_SEQUENCE_ID
AND H.CURRENCY_CONVERSION_TYPE = C.CONVERSION_TYPE (+)