VIEW: APPS.OKL_STRM_TMPT_CONTRACTS_UV

Source

View Text - Preformatted

SELECT GTL.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, GTS.ID GTS_ID, GTS.NAME ST_GEN_TMPT_SET_NAME, AES.ID AES_ID, AES.NAME AE_TMPT_SET_NAME, PDT.ID PDT_ID, PDT.NAME PRODUCT_NAME, CHR.ID KHR_ID, CHR.CONTRACT_NUMBER FROM OKL_ST_GEN_TMPT_LNS_ALL GTL,OKL_ST_GEN_TEMPLATES_ALL GTT,OKL_ST_GEN_TMPT_SETS_ALL GTS,OKL_AE_TMPT_SETS_ALL AES,OKL_PRODUCTS_V PDT,OKL_STRM_TYPE_V STY,OKL_K_HEADERS KHR,OKC_K_HEADERS_ALL_B CHR WHERE GTL.GTT_ID = GTT.ID AND GTL.PRIMARY_YN = 'Y' AND GTL.PRIMARY_STY_ID = STY.ID AND GTT.GTS_ID = GTS.ID AND GTT.TMPT_STATUS = 'ACTIVE' AND GTS.ID = AES.GTS_ID AND AES.ID = PDT.AES_ID AND PDT.ID = KHR.PDT_ID AND KHR.ID = CHR.ID AND TRUNC(CHR.START_DATE) >= TRUNC(GTT.START_DATE) AND (TRUNC(CHR.START_DATE) <= TRUNC(GTT.END_DATE) OR GTT.END_DATE IS NULL) UNION ALL SELECT GTL.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, GTS.ID GTS_ID, GTS.NAME ST_GEN_TMPT_SET_NAME, AES.ID AES_ID, AES.NAME AE_TMPT_SET_NAME, PDT.ID PDT_ID, PDT.NAME PRODUCT_NAME, CHR.ID KHR_ID, CHR.CONTRACT_NUMBER FROM OKL_ST_GEN_TMPT_LNS_ALL GTL, OKL_ST_GEN_TEMPLATES_ALL GTT, OKL_ST_GEN_TMPT_SETS_ALL GTS, OKL_AE_TMPT_SETS_ALL AES, OKL_PRODUCTS_V PDT, OKL_STRM_TYPE_V STY, OKL_K_HEADERS KHR, OKC_K_HEADERS_ALL_B CHR WHERE GTL.GTT_ID = GTT.ID AND NVL(GTL.PRIMARY_YN, 'N') = 'N' AND GTL.DEPENDENT_STY_ID = STY.ID AND GTT.GTS_ID = GTS.ID AND GTT.TMPT_STATUS = 'ACTIVE' AND GTS.ID = AES.GTS_ID AND AES.ID = PDT.AES_ID AND PDT.ID = KHR.PDT_ID AND KHR.ID = CHR.ID AND TRUNC(CHR.START_DATE) >= TRUNC(GTT.START_DATE) AND (TRUNC(CHR.START_DATE) <= TRUNC(GTT.END_DATE) OR GTT.END_DATE IS NULL)

View Text - HTML Formatted

SELECT GTL.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
, GTS.ID GTS_ID
, GTS.NAME ST_GEN_TMPT_SET_NAME
, AES.ID AES_ID
, AES.NAME AE_TMPT_SET_NAME
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
, CHR.ID KHR_ID
, CHR.CONTRACT_NUMBER
FROM OKL_ST_GEN_TMPT_LNS_ALL GTL
, OKL_ST_GEN_TEMPLATES_ALL GTT
, OKL_ST_GEN_TMPT_SETS_ALL GTS
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_STRM_TYPE_V STY
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B CHR
WHERE GTL.GTT_ID = GTT.ID
AND GTL.PRIMARY_YN = 'Y'
AND GTL.PRIMARY_STY_ID = STY.ID
AND GTT.GTS_ID = GTS.ID
AND GTT.TMPT_STATUS = 'ACTIVE'
AND GTS.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND PDT.ID = KHR.PDT_ID
AND KHR.ID = CHR.ID
AND TRUNC(CHR.START_DATE) >= TRUNC(GTT.START_DATE)
AND (TRUNC(CHR.START_DATE) <= TRUNC(GTT.END_DATE) OR GTT.END_DATE IS NULL) UNION ALL SELECT GTL.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
, GTS.ID GTS_ID
, GTS.NAME ST_GEN_TMPT_SET_NAME
, AES.ID AES_ID
, AES.NAME AE_TMPT_SET_NAME
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
, CHR.ID KHR_ID
, CHR.CONTRACT_NUMBER
FROM OKL_ST_GEN_TMPT_LNS_ALL GTL
, OKL_ST_GEN_TEMPLATES_ALL GTT
, OKL_ST_GEN_TMPT_SETS_ALL GTS
, OKL_AE_TMPT_SETS_ALL AES
, OKL_PRODUCTS_V PDT
, OKL_STRM_TYPE_V STY
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B CHR
WHERE GTL.GTT_ID = GTT.ID
AND NVL(GTL.PRIMARY_YN
, 'N') = 'N'
AND GTL.DEPENDENT_STY_ID = STY.ID
AND GTT.GTS_ID = GTS.ID
AND GTT.TMPT_STATUS = 'ACTIVE'
AND GTS.ID = AES.GTS_ID
AND AES.ID = PDT.AES_ID
AND PDT.ID = KHR.PDT_ID
AND KHR.ID = CHR.ID
AND TRUNC(CHR.START_DATE) >= TRUNC(GTT.START_DATE)
AND (TRUNC(CHR.START_DATE) <= TRUNC(GTT.END_DATE) OR GTT.END_DATE IS NULL)