View: OKL_CS_PAYMENT_DETAIL_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.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