View: OKL_PROD_STRM_TYPES_UV

Product:	OKL - Leasing and Finance Management
Description:	View on OKL_PROD_STRM_TYPES and OKL_STRM_TYPE_B,OKL_STRM_TYPE_TL
Implementation/DBA Data:	APPS.OKL_PROD_STRM_TYPES_UV

View Text

SELECT PSY.ID ID
, PSY.ACCRUAL_YN ACCRUAL_YN
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_YES_NO'
, PSY.ACCRUAL_YN) ACCRUAL_YN_MEANING
, STYT.NAME NAME
, STYB.START_DATE START_DATE
, STYB.END_DATE END_DATE
, PSY.PDT_ID PDT_ID
, PSY.STY_ID STY_ID
, PSY.FROM_DATE FROM_DATE
, PSY.TO_DATE TO_DATE
, PSY.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FND.MEANING PURPOSE
FROM OKL_PROD_STRM_TYPES PSY
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
, FND_LOOKUPS FND
WHERE PSY.STY_ID = STYB.ID
AND STYB.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')
AND FND.LOOKUP_TYPE='OKL_STREAM_TYPE_PURPOSE'
AND FND.LOOKUP_CODE=STYB.STREAM_TYPE_PURPOSE

Columns