View: OKL_MISC_TMPL_UV

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

View Text

SELECT A.ID ID
, A.NAME NAME
, A.DESCRIPTION DESCRIPTION
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, D.CONTRACT_NUMBER CONTRACT_NUMBER
, STY.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
FROM OKL_AE_TEMPLATES_ALL A
, OKL_PRODUCTS B
, OKL_K_HEADERS C
, OKC_K_HEADERS_B D
, OKL_STRM_TYPE_V STY
WHERE A.AES_ID = B.AES_ID
AND B.ID = C.PDT_ID
AND C.ID = D.ID
AND A.START_DATE <= SYSDATE
AND (A.END_DATE >= SYSDATE OR A.END_DATE IS NULL)
AND A.STY_ID = STY.ID

Columns