View: OKL_STRM_TMPT_TYPES_ALL_UV

Product:	OKL - Lease and Finance Management
Description:	View to display all the stream template all types
Implementation/DBA Data:	APPS.OKL_STRM_TMPT_TYPES_ALL_UV

View Text

SELECT DISTINCT GLTV.PRIMARY_STY_ID STY_ID
, STY.NAME STY_NAME
, STY.STREAM_TYPE_PURPOSE STY_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) STY_PURPOSE_MEANING
, STY.BILLABLE_YN BILLABLE_YN
, STY.DESCRIPTION DESCRIPTION
FROM OKL_ST_GEN_TMPT_LNS_ALL GLTV
, OKL_STRM_TYPE_V STY
WHERE GLTV.PRIMARY_STY_ID = STY.ID
AND GLTV.PRIMARY_YN = 'Y' UNION ALL SELECT DISTINCT GLTV.DEPENDENT_STY_ID STY_ID
, STY.NAME STY_NAME
, STY.STREAM_TYPE_PURPOSE STY_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) STY_PURPOSE_MEANING
, STY.BILLABLE_YN BILLABLE_YN
, STY.DESCRIPTION DESCRIPTION
FROM OKL_ST_GEN_TMPT_LNS_ALL GLTV
, OKL_STRM_TYPE_V STY
WHERE GLTV.DEPENDENT_STY_ID = STY.ID
AND NVL(GLTV.PRIMARY_YN
, 'N') = 'N'

Columns