VIEW: APPS.OKL_PYMT_LINE_DTLS_ALL_UV

Source

View Text - Preformatted

SELECT caf.dnz_qte_id QTE_ID, qco.base_source_id BASE_SOURCE_ID, caf.sty_id STY_ID, caf.sts_code STS_CODE, cfl.stub_days STUB_DAYS, cfl.stub_amount STUB_AMOUNT, cfl.number_of_periods PERIODS, cfl.amount PAYMENT_AMOUNT, cfl.fqy_code FQY_CODE, fndlup.meaning FREQUENCY, (nvl((amount * number_of_periods),0) + nvl(stub_amount,0)) TOTAL , cfl.start_date START_DATE, decode(cfl.stub_days,NULL,(add_months(cfl.start_date, decode(cfl.fqy_code,'M',cfl.number_of_periods,'Q',cfl.number_of_periods*3,'S', cfl.number_of_periods*6, 'A', cfl.number_of_periods*12) )-1), (cfl.start_date + cfl.stub_days - 1) ) END_DATE ,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,FND_LOOKUPS FNDLUP,OKC_K_HEADERS_ALL_B HDR WHERE caf.id = cfl.caf_id and caf.cfo_id = cfo.id and cfo.id = qco.cfo_id and caf.cft_code = 'PAYMENT_SCHEDULE' AND hdr.id = caf.dnz_khr_id and fndlup.lookup_type (+) = 'OKL_FREQUENCY' and cfl.fqy_code = fndlup.lookup_code(+) order by cfl.start_date

View Text - HTML Formatted

SELECT CAF.DNZ_QTE_ID QTE_ID
, QCO.BASE_SOURCE_ID BASE_SOURCE_ID
, CAF.STY_ID STY_ID
, CAF.STS_CODE STS_CODE
, CFL.STUB_DAYS STUB_DAYS
, CFL.STUB_AMOUNT STUB_AMOUNT
, CFL.NUMBER_OF_PERIODS PERIODS
, CFL.AMOUNT PAYMENT_AMOUNT
, CFL.FQY_CODE FQY_CODE
, FNDLUP.MEANING FREQUENCY
, (NVL((AMOUNT * NUMBER_OF_PERIODS)
, 0) + NVL(STUB_AMOUNT
, 0)) TOTAL
, CFL.START_DATE START_DATE
, DECODE(CFL.STUB_DAYS
, NULL
, (ADD_MONTHS(CFL.START_DATE
, DECODE(CFL.FQY_CODE
, 'M'
, CFL.NUMBER_OF_PERIODS
, 'Q'
, CFL.NUMBER_OF_PERIODS*3
, 'S'
, CFL.NUMBER_OF_PERIODS*6
, 'A'
, CFL.NUMBER_OF_PERIODS*12) )-1)
, (CFL.START_DATE + CFL.STUB_DAYS - 1) ) END_DATE
, 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
, FND_LOOKUPS FNDLUP
, OKC_K_HEADERS_ALL_B HDR
WHERE CAF.ID = CFL.CAF_ID
AND CAF.CFO_ID = CFO.ID
AND CFO.ID = QCO.CFO_ID
AND CAF.CFT_CODE = 'PAYMENT_SCHEDULE'
AND HDR.ID = CAF.DNZ_KHR_ID
AND FNDLUP.LOOKUP_TYPE (+) = 'OKL_FREQUENCY'
AND CFL.FQY_CODE = FNDLUP.LOOKUP_CODE(+) ORDER BY CFL.START_DATE