VIEW: APPS.OKL_STRM_TMPT_LINES_UV

Source

View Text - Preformatted

SELECT GTLV.ID ID, GTLV.PRIMARY_YN PRIMARY_YN, GTLV.PRIMARY_STY_ID PRIMARY_STY_ID, STYT.NAME PRIMARY_STY_NAME, STY.STREAM_TYPE_PURPOSE PRIMARY_STY_PURPOSE, GTLV.DEPENDENT_STY_ID DEPENDENT_STY_ID, STYT1.NAME DEPENDENT_STY_NAME, STY1.STREAM_TYPE_PURPOSE DEPENDENT_STY_PURPOSE, GTLV.PRICING_NAME PRICING_NAME, GTTV.ID GTT_ID, GTTV.VERSION VERSION, GTTV.START_DATE START_DATE, GTTV.END_DATE END_DATE, GTTV.TMPT_STATUS TMPT_STATUS, GTSV.ID GTS_ID, GTSV.NAME ST_GEN_TMPT_SET_NAME, GTSV.DESCRIPTION DESCRIPTION, GTSV.PRODUCT_TYPE PRODUCT_TYPE, GTSV.TAX_OWNER TAX_OWNER, GTSV.DEAL_TYPE DEAL_TYPE, GTSV.PRICING_ENGINE PRICING_ENGINE, AES.ID AES_ID, AES.NAME AE_TMPT_SET_NAME, PDT.ID PDT_ID, PDT.NAME PRODUCT_NAME FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV,OKL_ST_GEN_TEMPLATES_ALL GTTV,OKL_ST_GEN_TMPT_SETS_ALL GTSV,OKL_AE_TMPT_SETS_ALL AES,OKL_PRODUCTS_V PDT,OKL_STRM_TYPE_B STY,OKL_STRM_TYPE_TL STYT,OKL_STRM_TYPE_B STY1,OKL_STRM_TYPE_TL STYT1 WHERE GTLV.GTT_ID = GTTV.ID AND GTTV.GTS_ID = GTSV.ID AND GTSV.ID = AES.GTS_ID AND AES.ID = PDT.AES_ID AND GTLV.PRIMARY_STY_ID = STY.ID AND GTLV.DEPENDENT_STY_ID = STY1.ID (+) AND STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV('LANG') AND STY1.ID = STYT1.ID(+) AND STYT1.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT GTLV.ID ID
, GTLV.PRIMARY_YN PRIMARY_YN
, GTLV.PRIMARY_STY_ID PRIMARY_STY_ID
, STYT.NAME PRIMARY_STY_NAME
, STY.STREAM_TYPE_PURPOSE PRIMARY_STY_PURPOSE
, GTLV.DEPENDENT_STY_ID DEPENDENT_STY_ID
, STYT1.NAME DEPENDENT_STY_NAME
, STY1.STREAM_TYPE_PURPOSE DEPENDENT_STY_PURPOSE
, GTLV.PRICING_NAME PRICING_NAME
, GTTV.ID GTT_ID
, GTTV.VERSION VERSION
, GTTV.START_DATE START_DATE
, GTTV.END_DATE END_DATE
, GTTV.TMPT_STATUS TMPT_STATUS
, GTSV.ID GTS_ID
, GTSV.NAME ST_GEN_TMPT_SET_NAME
, GTSV.DESCRIPTION DESCRIPTION
, GTSV.PRODUCT_TYPE PRODUCT_TYPE
, GTSV.TAX_OWNER TAX_OWNER
, GTSV.DEAL_TYPE DEAL_TYPE
, GTSV.PRICING_ENGINE PRICING_ENGINE
, AES.ID AES_ID
, AES.NAME AE_TMPT_SET_NAME
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV
, OKL_ST_GEN_TEMPLATES_ALL GTTV
, OKL_ST_GEN_TMPT_SETS_ALL GTSV
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_STRM_TYPE_B STY
, OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STY1
, OKL_STRM_TYPE_TL STYT1
WHERE GTLV.GTT_ID = GTTV.ID
AND GTTV.GTS_ID = GTSV.ID
AND GTSV.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND GTLV.PRIMARY_STY_ID = STY.ID
AND GTLV.DEPENDENT_STY_ID = STY1.ID (+)
AND STY.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')
AND STY1.ID = STYT1.ID(+)
AND STYT1.LANGUAGE(+) = USERENV('LANG')