VIEW: APPS.OKL_STRM_TMPT_TYPES_ALL_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'