View: OKL_AEL_GL_TRX_V

Product:	OKL - Leasing and Finance Management
Description:	This view contains the transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Loss Provision, Accrual, Miscellaneous and Adjust
Implementation/DBA Data:	APPS.OKL_AEL_GL_TRX_V

View Text

SELECT CHR.CONTRACT_NUMBER
, PRODUCT.DESCRIPTION
, CHR.START_DATE
, CHR.END_DATE
, CHR.STS_CODE
, PRT.PARTY_NAME
, PROGRAM.CONTRACT_NUMBER PA_AGREEMENT_NUM
, TCL.ID
, TCN.TRX_NUMBER
, TCN.CURRENCY_CODE
, TCN.DATE_TRANSACTION_OCCURRED
, TCN.TSU_CODE
, AVL.NAME
, FMA.NAME
, STY.CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE)
, TRY.TRX_TYPE_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS)
, AEL.ACCOUNTED_DR
, AEL.ACCOUNTED_CR
, REF.JE_HEADER_ID
, REF.JE_LINE_NUM
, 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID
, AEH.ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, AEL.THIRD_PARTY_ID THIRD_PARTY_ID
, AEL.SUBLEDGER_DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, 'OKLECL' AEL_TABLE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.CURRENCY_CODE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SUBLEDGER_DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, 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
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, AEL.SOURCE_ID
, AEL.SOURCE_TABLE
FROM GL_IMPORT_REFERENCES REF
, OKL_AE_LINES_ALL AEL
, OKL_AE_HEADERS_ALL AEH
, OKL_ACC_EVENTS_ALL AET
, OKL_AE_TEMPLATES_ALL AVL
, OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRX_CONTRACTS_ALL TCN
, OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B PROGRAM
, OKC_K_PARTY_ROLES_B RLE
, OKL_PRODUCTS PRODUCT
, HZ_PARTIES PRT
, OKL_TRX_TYPES_B TRY
, OKL_FORMULAE_B FMA
, OKL_STRM_TYPE_V STY
, GL_JE_CATEGORIES_VL JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE TCN.KHR_ID = KHR.ID
AND KHR.ID = RLE.CHR_ID
AND RLE.RLE_CODE = 'LESSEE'
AND PRT.PARTY_ID = RLE.OBJECT1_ID1
AND RLE.OBJECT1_ID2 = '#'
AND TCN.ID = TCL.TCN_ID
AND TCN.TRY_ID = TRY.ID
AND AET.SOURCE_ID = TCL.ID
AND AEL.REFERENCE1 = AVL.ID(+)
AND TCL.STY_ID = STY.ID(+)
AND AVL.FMA_ID = FMA.ID(+)
AND AEH.AE_CATEGORY IN ('LOSS PROVISION'
, 'ADJUSTMENT'
, 'ACCRUAL'
, 'MISCELLANEOUS'
, 'LEASE ACCRUAL')
AND AEH.ACCOUNTING_EVENT_ID = AET.ACCOUNTING_EVENT_ID
AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND REF.GL_SL_LINK_ID = AEL.GL_SL_LINK_ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND REF.GL_SL_LINK_TABLE = 'OKLECL'

Columns