View: OKL_CS_PPD_PAYMENTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_PPD_PAYMENTS_UV

View Text

SELECT CFO.SOURCE_ID REQUEST_ID
, CAF.DNZ_KHR_ID DNZ_KHR_ID
, QCO.BASE_SOURCE_ID KLE_ID
, L.NAME ASSET
, CAF.STY_ID STY_ID
, STM1.CODE STREAM_TYPE
, CFL.FQY_CODE FREQUENCY_CODE
, FND_FREQ.MEANING FREQUENCY
, CAF.DUE_ARREARS_YN ARREARS
, CFL.NUMBER_OF_PERIODS
, CFL.AMOUNT
, CFL.STUB_DAYS
, CFL.STUB_AMOUNT
, CFL.START_DATE
, CAF.NUMBER_OF_ADVANCE_PERIODS ADVANCE_PAYMENTS
, HDR.CURRENCY_CODE CURRENCY_CODE
FROM OKL_CASH_FLOWS CAF
, OKL_CASH_FLOW_LEVELS CFL
, OKL_CASH_FLOW_OBJECTS CFO
, OKL_TRX_QTE_CF_OBJECTS QCO
, OKC_K_LINES_V L
, OKC_K_HEADERS_B HDR
, OKL_STRM_TYPE_B STM1
, FND_LOOKUPS FND_FREQ
WHERE CAF.STY_ID = STM1.ID
AND CAF.ID = CFL.CAF_ID
AND CAF.CFO_ID = CFO.ID
AND CFO.ID=QCO.CFO_ID
AND L.ID=QCO.BASE_SOURCE_ID
AND HDR.ID = CAF.DNZ_KHR_ID
AND CFO.OTY_CODE='FINANCIAL_ASSET_LINE'
AND FND_FREQ.LOOKUP_TYPE(+)='OKL_FREQUENCY'
AND FND_FREQ.LOOKUP_CODE(+)=CFL.FQY_CODE ORDER BY KLE_ID
, STREAM_TYPE
, START_DATE

Columns