View: OKL_AEL_GL_AST_V

Product:	OKL - Leasing and Finance Management
Description:	This view contains all the asset related 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 'Asset Disposition' journal cate
Implementation/DBA Data:	APPS.OKL_AEL_GL_AST_V

View Text

SELECT TL.ASSET_NUMBER
, B.DATE_PLACED_IN_SERVICE
, A.ATTRIBUTE_CATEGORY_CODE
, K.CONTRACT_NUMBER
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(L.START_DATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(TRUNC(L.END_DATE)
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) ASSET_STATUS
, V.VENDOR_NAME VENDOR
, TL.CORPORATE_BOOK
, TL.ID
, TRANS_NUMBER TRX_NUMBER
, AEL.CURRENCY_CODE TRX_CURRENCY_CODE
, AST.DATE_TRANS_OCCURRED
, NULL TRANSACTION_STATUS
, 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 OKL_TXL_ASSETS_B TL
, OKL_TRX_ASSETS AST
, OKC_K_HEADERS_B K
, FA_BOOKS B
, FA_ADDITIONS_B A
, OKC_K_LINES_B L
, PO_VENDORS V
, OKC_K_PARTY_ROLES_B R
, OKL_TRX_TYPES_B TRY
, OKL_AE_TEMPLATES_ALL AVL
, OKL_FORMULAE_B FMA
, OKL_STRM_TYPE_B STY
, OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS_ALL AEH
, OKL_AE_LINES_ALL AEL
, GL_IMPORT_REFERENCES REF
, GL_DAILY_CONVERSION_TYPES GLCT
, GL_JE_CATEGORIES_VL JC
WHERE AST.ID = TL.TAS_ID
AND TL.TAL_TYPE = 'RFL'
AND TL.DNZ_KHR_ID = K.ID
AND TL.DNZ_ASSET_ID = B.ASSET_ID
AND TL.CORPORATE_BOOK = B.BOOK_TYPE_CODE
AND B.DATE_INEFFECTIVE IS NULL
AND B.TRANSACTION_HEADER_ID_OUT IS NULL
AND TL.DNZ_ASSET_ID = A.ASSET_ID
AND TL.KLE_ID = L.CLE_ID
AND TL.KLE_ID = R.CLE_ID(+)
AND R.RLE_CODE(+)='VENDOR'
AND R.OBJECT1_ID1 = V.VENDOR_ID(+)
AND AET.SOURCE_ID = TL.ID
AND AEL.REFERENCE1 = AVL.ID
AND AVL.STY_ID = STY.ID
AND AVL.FMA_ID = FMA.ID(+)
AND AST.TRY_ID = TRY.ID
AND AEH.ACCOUNTING_EVENT_ID = AET.ACCOUNTING_EVENT_ID
AND AEH.AE_CATEGORY IN ('ASSET DISPOSITION')
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