[Home] [Help]
View: OKL_CS_PAYMENT_DETAIL_UV
View Text
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
Columns
Name |
KHR_ID |
STREAM_ELEMENT_DATE |
AMOUNT |
CURRENCY_CODE |
DATE_BILLED |
SE_LINE_NUMBER |
STM_ID |
KLE_ID |
STY_ID |