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
, APP.APPLICATION_NAME
, SOB.NAME
, DOC.NAME
, TP.THIRD_PARTY_NAME
, SUB.SUB_NAME
, 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)
, H.REFERENCE_1
, H.GL_TRANSFER_FLAG
, L.BALANCE_FLAG
, L.CODE_COMBINATION_ID
, H.APPLICATION_ID
, H.SET_OF_BOOKS_ID
, L.THIRD_PARTY_ID
, L.SUB_ID
, H.EVENT_ID
, L.GL_TRANSFER_LINE_NUM
, H.GL_TRANSFER_RUN_ID
, H.CREATED_BY
, H.CREATION_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_DATE
FROM AX_SLE_LINES L
, AX_SLE_HEADERS H
, FND_APPLICATION_VL APP
, GL_SETS_OF_BOOKS SOB
, AX_THIRD_PARTIES_V TP
, AX_SUBS_V SUB
, FND_DOCUMENT_SEQUENCES DOC
, GL_CODE_COMBINATIONS GCC
WHERE H.JOURNAL_SEQUENCE_ID = L.JOURNAL_SEQUENCE_ID
AND H.SLE_HEADER_ID = L.SLE_HEADER_ID
AND APP.APPLICATION_ID = H.APPLICATION_ID
AND SOB.SET_OF_BOOKS_ID = H.SET_OF_BOOKS_ID
AND H.APPLICATION_ID = TP.APPLICATION_ID
AND H.APPLICATION_ID = SUB.APPLICATION_ID
AND L.THIRD_PARTY_ID = TP.THIRD_PARTY_ID
AND L.THIRD_PARTY_ID = SUB.THIRD_PARTY_ID
AND L.SUB_ID = SUB.SUB_ID
AND H.JOURNAL_SEQUENCE_ID = DOC.DOC_SEQUENCE_ID
AND L.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY