VIEW: APPS.OKL_MISC_TMPL_UV

Source

View Text - Preformatted

SELECT a.ID ID, a.name NAME, a.description DESCRIPTION, a.start_date START_DATE, a.end_date END_DATE, d.contract_number CONTRACT_NUMBER , sty.name STREAM_TYPE, Okl_Accounting_Util.get_lookup_meaning('OKL_STREAM_TYPE_PURPOSE', sty.stream_type_purpose) stream_type_purpose FROM OKL_AE_TEMPLATES_ALL A,OKL_PRODUCTS B,OKL_K_HEADERS C,OKC_K_HEADERS_B D,OKL_STRM_TYPE_V STY WHERE a.aes_id = b.aes_id and b.id = c.pdt_id and c.id = d.id and a.start_date <= sysdate and (a.end_date >= sysdate or a.end_date is null) AND a.sty_id = sty.id

View Text - HTML Formatted

SELECT A.ID ID
, A.NAME NAME
, A.DESCRIPTION DESCRIPTION
, A.START_DATE START_DATE
, A.END_DATE END_DATE
, D.CONTRACT_NUMBER CONTRACT_NUMBER
, STY.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
FROM OKL_AE_TEMPLATES_ALL A
, OKL_PRODUCTS B
, OKL_K_HEADERS C
, OKC_K_HEADERS_B D
, OKL_STRM_TYPE_V STY
WHERE A.AES_ID = B.AES_ID
AND B.ID = C.PDT_ID
AND C.ID = D.ID
AND A.START_DATE <= SYSDATE
AND (A.END_DATE >= SYSDATE OR A.END_DATE IS NULL)
AND A.STY_ID = STY.ID