VIEW: APPS.OKL_STRM_TMPT_CONTRACT_UV

Source

View Text - Preformatted

SELECT GTLV.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.CAPITALIZE_YN CAPITALIZE_YN, 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, CHR.ID, CHR.CONTRACT_NUMBER FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV,OKC_K_HEADERS_ALL_B CHR,OKL_K_HEADERS KHR,OKL_ST_GEN_TEMPLATES_ALL GTTV,OKL_ST_GEN_TMPT_SETS GTSV,OKL_AE_TMPT_SETS_ALL AES,OKL_PRODUCTS_V PDT,OKL_STRM_TYPE_V STY WHERE GTLV.GTT_ID = GTTV.ID AND GTTV.GTS_ID = GTSV.ID AND GTTV.TMPT_STATUS = 'ACTIVE' AND GTSV.ID = AES.GTS_ID AND AES.ID = PDT.AES_ID AND GTLV.PRIMARY_STY_ID = STY.ID AND GTLV.PRIMARY_YN = 'Y' AND chr.id = khr.id AND khr.pdt_id = PDT.ID AND trunc(chr.start_date) between trunc(GTTV.START_DATE) and trunc(nvl(GTTV.END_DATE,chr.start_date+1)) UNION SELECT GTLV.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.CAPITALIZE_YN CAPITALIZE_YN, 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, CHR.ID, CHR.CONTRACT_NUMBER FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV, OKL_ST_GEN_TEMPLATES_ALL GTTV, OKL_ST_GEN_TMPT_SETS GTSV, OKL_AE_TMPT_SETS_ALL AES, OKL_PRODUCTS_V PDT, OKL_STRM_TYPE_V STY, OKC_K_HEADERS_ALL_B chr, OKL_K_HEADERS khr WHERE GTLV.GTT_ID = GTTV.ID AND GTTV.GTS_ID = GTSV.ID AND GTTV.TMPT_STATUS = 'ACTIVE' AND GTSV.ID = AES.GTS_ID AND AES.ID = PDT.AES_ID AND GTLV.DEPENDENT_STY_ID = STY.ID AND NVL(GTLV.PRIMARY_YN, 'N') = 'N' AND chr.id = khr.id AND khr.pdt_id = PDT.ID AND trunc(chr.start_date) between trunc(GTTV.START_DATE) and trunc(nvl(GTTV.END_DATE,chr.start_date+1))

View Text - HTML Formatted

SELECT GTLV.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.CAPITALIZE_YN CAPITALIZE_YN
, 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
, CHR.ID
, CHR.CONTRACT_NUMBER
FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV
, OKC_K_HEADERS_ALL_B CHR
, OKL_K_HEADERS KHR
, OKL_ST_GEN_TEMPLATES_ALL GTTV
, OKL_ST_GEN_TMPT_SETS GTSV
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_STRM_TYPE_V STY
WHERE GTLV.GTT_ID = GTTV.ID
AND GTTV.GTS_ID = GTSV.ID
AND GTTV.TMPT_STATUS = 'ACTIVE'
AND GTSV.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND GTLV.PRIMARY_STY_ID = STY.ID
AND GTLV.PRIMARY_YN = 'Y'
AND CHR.ID = KHR.ID
AND KHR.PDT_ID = PDT.ID
AND TRUNC(CHR.START_DATE) BETWEEN TRUNC(GTTV.START_DATE)
AND TRUNC(NVL(GTTV.END_DATE
, CHR.START_DATE+1)) UNION SELECT GTLV.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.CAPITALIZE_YN CAPITALIZE_YN
, 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
, CHR.ID
, CHR.CONTRACT_NUMBER
FROM OKL_ST_GEN_TMPT_LNS_ALL GTLV
, OKL_ST_GEN_TEMPLATES_ALL GTTV
, OKL_ST_GEN_TMPT_SETS GTSV
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_STRM_TYPE_V STY
, OKC_K_HEADERS_ALL_B CHR
, OKL_K_HEADERS KHR
WHERE GTLV.GTT_ID = GTTV.ID
AND GTTV.GTS_ID = GTSV.ID
AND GTTV.TMPT_STATUS = 'ACTIVE'
AND GTSV.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND GTLV.DEPENDENT_STY_ID = STY.ID
AND NVL(GTLV.PRIMARY_YN
, 'N') = 'N'
AND CHR.ID = KHR.ID
AND KHR.PDT_ID = PDT.ID
AND TRUNC(CHR.START_DATE) BETWEEN TRUNC(GTTV.START_DATE)
AND TRUNC(NVL(GTTV.END_DATE
, CHR.START_DATE+1))