Product: | AX - Global Accounting Engine |
---|---|
Description: | Replacement for the AP table, AP_AE_LINES_ALL, when the AX accounting engine is used. |
Implementation/DBA Data: | Not implemented in this database |
SELECT -1 AE_LINE_ID
, AXSL.JOURNAL_SEQUENCE_ID JOURNAL_SEQUENCE_ID
, AXSL.SLE_HEADER_ID AE_HEADER_ID
, AXSL.SLE_LINE_NUM AE_LINE_NUMBER
, AXSL.REFERENCE_14 AE_LINE_TYPE_CODE
, AXSL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AXSL.CURRENCY_CODE CURRENCY_CODE
, AXSL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, AXSL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, AXSL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AXSL.ENTERED_DR ENTERED_DR
, AXSL.ENTERED_CR ENTERED_CR
, AXSL.ACCOUNTED_DR ACCOUNTED_DR
, AXSL.ACCOUNTED_CR ACCOUNTED_CR
, AXSL.SOURCE_TABLE SOURCE_TABLE
, AXSL.SOURCE_ID SOURCE_ID
, TO_NUMBER(AXSL.REFERENCE_15) ACCOUNT_OVERLAY_SOURCE_ID
, AXSL.GL_SL_LINK_ID GL_SL_LINK_ID
, AX_PAYABLES_PKG.AE_LINE_DESCRIPTION (AXE.EVENT_TYPE
, AXSL.REFERENCE_1
, TO_NUMBER(AXSL.REFERENCE_22)
, TO_NUMBER(AXSL.REFERENCE_23)) DESCRIPTION
, NULL ACCOUNTING_ERROR_CODE
, NULL GL_TRANSFER_ERROR_CODE
, AXSL.THIRD_PARTY_ID VENDOR_ID
, AXSL.SUB_ID VENDOR_SITE_ID
, AXSL.STAT_AMOUNT STAT_AMOUNT
, AXE.DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, AXE.DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, AXSL.ORG_ID ORG_ID
, AXSL.CREATION_DATE CREATION_DATE
, AX_PAYABLES_PKG.AE_USSGL_TRANSACTION_CODE (AXE.EVENT_TYPE
, AXSL.REFERENCE_1
, TO_NUMBER(AXSL.REFERENCE_22)
, TO_NUMBER(AXSL.REFERENCE_23)) USSGL_TRANSACTION_CODE
, AXSL.CREATED_BY CREATED_BY
, AXSL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AXSL.LAST_UPDATED_BY LAST_UPDATED_BY
, AXSL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AXSL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AXSL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AXSL.PROGRAM_ID PROGRAM_ID
, AXSL.REQUEST_ID REQUEST_ID
, AXSL.REFERENCE_21 REFERENCE1
, AXSL.REFERENCE_22 REFERENCE2
, AXSL.REFERENCE_23 REFERENCE3
, NULL REFERENCE4
, AXSL.REFERENCE_25 REFERENCE5
, AXSL.REFERENCE_26 REFERENCE6
, AXSL.REFERENCE_27 REFERENCE7
, NULL REFERENCE8
, NULL REFERENCE9
, AXSL.REFERENCE_1 REFERENCE10
, AXSL.APPLIED_FROM_DOC_ENTITY APPLIED_FROM_TRX_HDR_TABLE
, AXSL.APPLIED_FROM_DOC_ID APPLIED_FROM_TRX_HDR_ID
, AXSL.APPLIED_TO_DOC_ENTITY APPLIED_TO_TRX_HDR_TABLE
, AXSL.APPLIED_TO_DOC_ID APPLIED_TO_TRX_HDR_ID
, AXSL.TAX_CODE_ID TAX_CODE_ID
, AXSL.TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, AXSL.TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, AXSL.TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, AXSL.TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, AXSL.TAX_LINK_ID TAX_LINK_ID
, AXSL.THIRD_PARTY_ID THIRD_PARTY_ID
, AXSL.SUB_ID THIRD_PARTY_SUB_ID
FROM AP_SYSTEM_PARAMETERS_ALL APSP
, AX_EVENTS AXE
, AX_SLE_HEADERS AXSH
, AX_SLE_LINES AXSL
WHERE APSP.SET_OF_BOOKS_ID = AXSH.SET_OF_BOOKS_ID
AND AXSH.JOURNAL_SEQUENCE_ID = AXSL.JOURNAL_SEQUENCE_ID
AND AXSH.SLE_HEADER_ID = AXSL.SLE_HEADER_ID
AND AXSH.APPLICATION_ID = 200
AND AXE.EVENT_ID = AXSH.EVENT_ID