VIEW: APPS.OKL_STRM_TMPT_SET_TYPE_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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