View: OKL_STRM_TMPT_SET_TYPE_UV

Product:	OKL - Leasing and Finance Management
Description:	View that holds the stream templates
Implementation/DBA Data:	APPS.OKL_STRM_TMPT_SET_TYPE_UV

View Text

SELECT GTS.ID GTS_ID
, STM.ID STY_ID
, AES.ID AES_ID
, STM.NAME STY_NAME
, STM.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STM.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE_MEAN
FROM OKL_ST_GEN_TMPT_SETS GTS
, OKL_ST_GEN_TEMPLATES_ALL GTT
, OKL_ST_GEN_TMPT_LNS_ALL GTL
, OKL_STRM_TYPE_V STM
, OKL_AE_TMPT_SETS_ALL AES
WHERE GTT.GTS_ID = GTS.ID
AND GTL.GTT_ID = GTT.ID
AND GTL.PRIMARY_STY_ID = STM.ID
AND AES.GTS_ID = GTS.ID UNION SELECT GTS.ID GTS_ID
, STM.ID STY_ID
, AES.ID AES_ID
, STM.NAME STY_NAME
, STM.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STM.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE_MEAN
FROM OKL_ST_GEN_TMPT_SETS GTS
, OKL_ST_GEN_TEMPLATES_ALL GTT
, OKL_ST_GEN_TMPT_LNS_ALL GTL
, OKL_STRM_TYPE_V STM
, OKL_AE_TMPT_SETS_ALL AES
WHERE GTT.GTS_ID = GTS.ID
AND GTL.GTT_ID = GTT.ID
AND GTL.DEPENDENT_STY_ID = STM.ID
AND AES.GTS_ID = GTS.ID

Columns