VIEW: APPS.OKL_CS_PAYMENT_DETAIL_UV

Source

View Text - Preformatted

SELECT STM.KHR_ID KHR_ID ,SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE ,SELB.AMOUNT AMOUNT ,CHRB.CURRENCY_CODE CURRENCY_CODE ,SELB.DATE_BILLED DATE_BILLED ,SELB.SE_LINE_NUMBER SE_LINE_NUMBER ,SELB.STM_ID STM_ID ,stm.kle_id , stm.sty_id from okl_strm_elements selb, okl_streams stm, okc_k_headers_b chrb WHERE stm.say_code = 'CURR' and (selb.date_billed is null or (selb.date_billed is not null and selb.bill_adj_flag is null)) and stm.id = selb.stm_id and stm.khr_id = chrb.id and stm.active_yn = 'Y' UNION SELECT STM.KHR_ID KHR_ID , SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE , SELB.AMOUNT AMOUNT , CHRB.CURRENCY_CODE CURRENCY_CODE , SELB.DATE_BILLED DATE_BILLED , SELB.SE_LINE_NUMBER SE_LINE_NUMBER , SELB.STM_ID STM_ID, stm.kle_id, stm.sty_id from okl_strm_elements selb, okl_streams stm, okc_k_headers_b chrb where stm.say_code = 'HIST' and selb.date_billed is not null and selb.bill_adj_flag is null and stm.id = selb.stm_id and stm.khr_id = chrb.id

View Text - HTML Formatted

SELECT STM.KHR_ID KHR_ID
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, SELB.DATE_BILLED DATE_BILLED
, SELB.SE_LINE_NUMBER SE_LINE_NUMBER
, SELB.STM_ID STM_ID
, STM.KLE_ID
, STM.STY_ID
FROM OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STM
, OKC_K_HEADERS_B CHRB
WHERE STM.SAY_CODE = 'CURR'
AND (SELB.DATE_BILLED IS NULL OR (SELB.DATE_BILLED IS NOT NULL
AND SELB.BILL_ADJ_FLAG IS NULL))
AND STM.ID = SELB.STM_ID
AND STM.KHR_ID = CHRB.ID
AND STM.ACTIVE_YN = 'Y' UNION SELECT STM.KHR_ID KHR_ID
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, SELB.DATE_BILLED DATE_BILLED
, SELB.SE_LINE_NUMBER SE_LINE_NUMBER
, SELB.STM_ID STM_ID
, STM.KLE_ID
, STM.STY_ID
FROM OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STM
, OKC_K_HEADERS_B CHRB
WHERE STM.SAY_CODE = 'HIST'
AND SELB.DATE_BILLED IS NOT NULL
AND SELB.BILL_ADJ_FLAG IS NULL
AND STM.ID = SELB.STM_ID
AND STM.KHR_ID = CHRB.ID