VIEW: APPS.OKL_POOL_STREAM_ELEMENTS_UV

Source

View Text - Preformatted

SELECT pocb.id poc_id, pocb.khr_id khr_id, pocb.pol_id pol_id, pocb.stm_id, polv.pool_number pool_number, chrb.contract_number contract_number, clet.name asset_number, styv.name stream_type, selb.stream_element_date stream_element_date, selb.date_billed date_billed, selb.amount amount, polv.currency_code currency_code, styv.stream_type_subclass sty_subclass_code, fnds.meaning sty_subclass, styv.stream_type_purpose sty_purpose_code, fndt.meaning stream_type_purpose, chrb.sts_code CONTRACT_STATUS FROM OKL_POOL_CONTENTS POCB,OKL_POOLS POLV,OKL_STRM_ELEMENTS SELB,OKL_STREAMS STMB,OKC_K_HEADERS_ALL_B CHRB,OKC_K_LINES_TL CLET,OKL_STRM_TYPE_V STYV,FND_LOOKUPS FNDS,FND_LOOKUPS FNDT WHERE pocb.pol_id = polv.id AND pocb.khr_id = chrb.id AND pocb.kle_id = clet.id AND clet.LANGUAGE = USERENV('LANG') AND pocb.stm_id = stmb.id AND stmb.id = selb.stm_id AND (selb.stream_element_date BETWEEN pocb.streams_from_date AND NVL(pocb.streams_to_date,TO_DATE('1','j')+5300000) ) AND stmb.sty_id = styv.id AND fnds.lookup_type = 'OKL_STREAM_TYPE_SUBCLASS' AND fnds.lookup_code = styv.stream_type_subclass AND fndt.lookup_type = 'OKL_STREAM_TYPE_PURPOSE' AND fndt.lookup_code = styv.stream_type_purpose ORDER BY stream_element_date

View Text - HTML Formatted

SELECT POCB.ID POC_ID
, POCB.KHR_ID KHR_ID
, POCB.POL_ID POL_ID
, POCB.STM_ID
, POLV.POOL_NUMBER POOL_NUMBER
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLET.NAME ASSET_NUMBER
, STYV.NAME STREAM_TYPE
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.DATE_BILLED DATE_BILLED
, SELB.AMOUNT AMOUNT
, POLV.CURRENCY_CODE CURRENCY_CODE
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, STYV.STREAM_TYPE_PURPOSE STY_PURPOSE_CODE
, FNDT.MEANING STREAM_TYPE_PURPOSE
, CHRB.STS_CODE CONTRACT_STATUS
FROM OKL_POOL_CONTENTS POCB
, OKL_POOLS POLV
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_K_LINES_TL CLET
, OKL_STRM_TYPE_V STYV
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDT
WHERE POCB.POL_ID = POLV.ID
AND POCB.KHR_ID = CHRB.ID
AND POCB.KLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND POCB.STM_ID = STMB.ID
AND STMB.ID = SELB.STM_ID
AND (SELB.STREAM_ELEMENT_DATE BETWEEN POCB.STREAMS_FROM_DATE
AND NVL(POCB.STREAMS_TO_DATE
, TO_DATE('1'
, 'J')+5300000) )
AND STMB.STY_ID = STYV.ID
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STYV.STREAM_TYPE_SUBCLASS
AND FNDT.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDT.LOOKUP_CODE = STYV.STREAM_TYPE_PURPOSE ORDER BY STREAM_ELEMENT_DATE