Product: | OKL - Lease and Finance Management |
---|---|
Description: | This view contains the accounting entries created for all the contract, asset and quote transactions. This view is used to enable sub-ledger accounting architecture to display the accounting entries for each Lease transaction. |
Implementation/DBA Data: | APPS.OKL_AEL_SL_V |
SELECT 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEH.ORG_ID ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AEL.AE_LINE_TYPE_CODE) ACCT_LINE_TYPE_NAME
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, TCL.LINE_NUMBER TRX_LINE_NUMBER
, TCL.CURRENCY_CODE CURRENCY_CODE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SOURCE_ID SOURCE_ID
, AEL.SOURCE_TABLE SOURCE_TABLE
, AVL.NAME ASSET_DESCRIPTION
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, AET.EVENT_TYPE_CODE) ACCOUNTING_EVENT_TYPE_NAME
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AEH.GL_TRANSFER_FLAG
, 0
, 0) GL_TRANSFER_STATUS_NAME
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, AEL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEL.PROGRAM_ID PROGRAM_ID
, AEL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TCN.DATE_TRANSACTION_OCCURRED TRX_DATE
, TRY.TRX_TYPE_CLASS TRX_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS) TRX_CLASS_NAME
, STY.NAME COST_ELEMENT_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER
FROM OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS AEH
, OKL_AE_LINES_ALL AEL
, OKL_TRX_CONTRACTS_ALL TCN
, OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRX_TYPES_B TRY
, OKL_STRM_TYPE_V STY
, OKL_AE_TEMPLATES_ALL AVL
, GL_JE_CATEGORIES_VL JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE AET.ACCOUNTING_EVENT_ID = AEH.ACCOUNTING_EVENT_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AET.SOURCE_ID = TCL.ID
AND TCN.ID = TCL.TCN_ID
AND TCN.TRY_ID = TRY.ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND AEL.REFERENCE1 = AVL.ID (+)
AND TCL.STY_ID = STY.ID (+) UNION ALL SELECT 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEH.ORG_ID ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AEL.AE_LINE_TYPE_CODE) ACCT_LINE_TYPE_NAME
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, ASL.LINE_NUMBER TRX_LINE_NUMBER
, AEL.CURRENCY_CODE CURRENCY_CODE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SOURCE_ID SOURCE_ID
, AEL.SOURCE_TABLE SOURCE_TABLE
, AVL.NAME ASSET_DESCRIPTION
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, AET.EVENT_TYPE_CODE) ACCOUNTING_EVENT_TYPE_NAME
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AEH.GL_TRANSFER_FLAG
, 0
, 0) GL_TRANSFER_STATUS_NAME
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, AEL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEL.PROGRAM_ID PROGRAM_ID
, AEL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AST.DATE_TRANS_OCCURRED TRX_DATE
, TRY.TRX_TYPE_CLASS TRX_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS) TRX_CLASS_NAME
, STY.NAME COST_ELEMENT_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER
FROM OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS AEH
, OKL_AE_LINES_ALL AEL
, OKL_TRX_ASSETS AST
, OKL_TXL_ASSETS_B ASL
, OKL_TRX_TYPES_B TRY
, OKL_STRM_TYPE_V STY
, OKL_AE_TEMPLATES_ALL AVL
, GL_JE_CATEGORIES JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE AET.ACCOUNTING_EVENT_ID = AEH.ACCOUNTING_EVENT_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AET.SOURCE_ID = ASL.ID
AND AST.ID = ASL.TAS_ID
AND AST.TRY_ID = TRY.ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND AEL.REFERENCE1 = AVL.ID (+)
AND AVL.STY_ID = STY.ID