VIEW: APPS.OKL_CS_PPD_PAYMENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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