View: OKL_AE_TEMPLATES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AE_TEMPLATES_UV

View Text

SELECT AVL.ID ID
, AVL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AVL.STY_ID STY_ID
, STY.NAME STY_NAME
, STY.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE_MEAN
, AVL.TRY_ID TRY_ID
, TRY.NAME TRY_NAME
, AVL.AES_ID AES_ID
, AES.NAME AES_NAME
, AVL.FMA_ID FMA_ID
, FMA.NAME FMA_NAME
, AVL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AVL.NAME NAME
, AVL.SYT_CODE SYT_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SYNDICATION_CODE'
, AVL.SYT_CODE) SYT_DESC
, AVL.FAC_CODE FAC_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_FACTORING_CODE'
, AVL.FAC_CODE ) FAC_DESC
, AVL.INV_CODE INV_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INVESTOR_CODE'
, AVL.INV_CODE ) INV_DESC
, AVL.ADVANCE_ARREARS ADVANCE_ARREARS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ADVANCE_ARREARS'
, AVL.FAC_CODE) ADVANCE_ARREARS_DESC
, AVL.POST_TO_GL POST_TO_GL
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AVL.POST_TO_GL
, 0
, 0) POST_TO_GL_DESC
, AVL.VERSION VERSION
, AVL.START_DATE START_DATE
, AVL.MEMO_YN MEMO_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AVL.MEMO_YN
, 0
, 0) MEMO_YN_DESC
, AVL.PRIOR_YEAR_YN PRIOR_YEAR_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AVL.PRIOR_YEAR_YN
, 0
, 0) PRIOR_YEAR_YN_DESC
, AVL.DESCRIPTION DESCRIPTION
, AVL.FACTORING_SYND_FLAG FACTORING_SYND_FLAG
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_FACTORING_SYNDICATION'
, AVL.FACTORING_SYND_FLAG) FACTORING_SYND_FLAG_DESC
, AVL.END_DATE END_DATE
, AVL.ACCRUAL_YN ACCRUAL_YN
, AVL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AVL.ATTRIBUTE1 ATTRIBUTE1
, AVL.ATTRIBUTE2 ATTRIBUTE2
, AVL.ATTRIBUTE3 ATTRIBUTE3
, AVL.ATTRIBUTE4 ATTRIBUTE4
, AVL.ATTRIBUTE5 ATTRIBUTE5
, AVL.ATTRIBUTE6 ATTRIBUTE6
, AVL.ATTRIBUTE7 ATTRIBUTE7
, AVL.ATTRIBUTE8 ATTRIBUTE8
, AVL.ATTRIBUTE9 ATTRIBUTE9
, AVL.ATTRIBUTE10 ATTRIBUTE10
, AVL.ATTRIBUTE11 ATTRIBUTE11
, AVL.ATTRIBUTE12 ATTRIBUTE12
, AVL.ATTRIBUTE13 ATTRIBUTE13
, AVL.ATTRIBUTE14 ATTRIBUTE14
, AVL.ATTRIBUTE15 ATTRIBUTE15
, AVL.ORG_ID ORG_ID
, AVL.CREATED_BY CREATED_BY
, AVL.CREATION_DATE CREATION_DATE
, AVL.LAST_UPDATED_BY LAST_UPDATED_BY
, AVL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AVL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRY.ACCOUNTING_EVENT_CLASS_CODE ACCOUNTING_EVENT_CLASS_CODE
, TRY.FORMULA_YN FORMULA_YN
FROM OKL_AE_TEMPLATES AVL
, OKL_STRM_TYPE_V STY
, OKL_TRX_TYPES_V TRY
, OKL_AE_TMPT_SETS_V AES
, OKL_FORMULAE_V FMA
WHERE AVL.STY_ID = STY.ID
AND AVL.FMA_ID = FMA.ID(+)
AND AVL.TRY_ID = TRY.ID
AND AVL.AES_ID = AES.ID

Columns