Product: | AX - Global Accounting Engine |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT H.JOURNAL_SEQUENCE_ID
, H.SLE_HEADER_ID
, L.SLE_LINE_NUM
, H.EFFECTIVE_DATE
, H.PERIOD_NAME
, '_KF:SQLGL:GL#:GCC'
, L.ENTERED_DR
, L.ENTERED_CR
, L.ACCOUNTED_DR
, L.ACCOUNTED_CR
, L.COMMENT_LINE
, NVL(L.CURRENCY_CODE
, H.CURRENCY_CODE)
, DECODE(L.CURRENCY_CODE
, NULL
, H.CURRENCY_CONVERSION_DATE
, L.CURRENCY_CONVERSION_DATE)
, DECODE(L.CURRENCY_CODE
, NULL
, H.CURRENCY_CONVERSION_RATE
, L.CURRENCY_CONVERSION_RATE)
, DECODE(L.CURRENCY_CODE
, NULL
, H.CURRENCY_CONVERSION_TYPE
, L.CURRENCY_CONVERSION_TYPE)
, L.GL_POSTED_FLAG
, L.BALANCE_FLAG
, H.APPLICATION_ID
, H.SET_OF_BOOKS_ID
, L.CODE_COMBINATION_ID
, H.REFERENCE_1
, L.THIRD_PARTY_ID
, L.SUB_ID
, H.EVENT_ID
, L.GL_TRANSFER_LINE_NUM
, H.GL_TRANSFER_RUN_ID
, L.CREATED_BY
, L.CREATION_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_DATE
FROM AX_SLE_LINES L
, AX_SLE_HEADERS H
, GL_CODE_COMBINATIONS GCC
WHERE H.JOURNAL_SEQUENCE_ID = L.JOURNAL_SEQUENCE_ID
AND H.SLE_HEADER_ID = L.SLE_HEADER_ID
AND L.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY