VIEW: APPS.OKL_AM_PAYMENT_STREAM_TYPE_UV

Source

View Text - Preformatted

SELECT distinct caf.dnz_qte_id qte_id, stm.code stream_type, caf.sts_code sts_code FROM OKL_CASH_FLOWS CAF,OKL_STRM_TYPE_B STM WHERE caf.sty_id = stm.id AND caf.cft_code = 'PAYMENT_SCHEDULE'

View Text - HTML Formatted

SELECT DISTINCT CAF.DNZ_QTE_ID QTE_ID
, STM.CODE STREAM_TYPE
, CAF.STS_CODE STS_CODE
FROM OKL_CASH_FLOWS CAF
, OKL_STRM_TYPE_B STM
WHERE CAF.STY_ID = STM.ID
AND CAF.CFT_CODE = 'PAYMENT_SCHEDULE'