View: OKL_CONTRACT_STREAMS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CONTRACT_STREAMS_UV

View Text

SELECT STMB.KHR_ID KHR_ID
, STYT.NAME NAME
, STYB.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STYB.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, STMB.SAY_CODE ACTIVITY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STYB.ID
FROM OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKC_K_HEADERS_B CHRB
WHERE STMB.KLE_ID IS NULL
AND STMB.STY_ID = STYB.ID
AND STYB.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')
AND SELB.STM_ID = STMB.ID
AND CHRB.ID = STMB.KHR_ID

Columns