[Home] [Help]
View: OKL_AM_PYMT_LINE_DTLS_UV
View Text
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_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
Columns
Name |
QTE_ID |
BASE_SOURCE_ID |
STY_ID |
STS_CODE |
STUB_DAYS |
STUB_AMOUNT |
PERIODS |
PAYMENT_AMOUNT |
FQY_CODE |
FREQUENCY |
TOTAL |
START_DATE |
END_DATE |
CURRENCY_CODE |