[Home] [Help]
View: OKL_AM_PAYMENT_SCHDLE_DTLS_UV
View Text
SELECT CAF.DNZ_QTE_ID QTE_ID
, CAF.DNZ_KHR_ID DNZ_KHR_ID
, DECODE(CFO.OTY_CODE
, 'FINANCIAL_ASSET_LINE'
, UPPER(L.NAME)
, 'SERVICED_ASSET_LINE'
, UPPER(L.NAME)
, 'SERVICE_LINE'
, UPPER(L.ITEM_DESCRIPTION)
, 'FEE_LINE'
, UPPER(STM2.NAME) ) DESCRIPTION
, DECODE(CFO.OTY_CODE
, 'FINANCIAL_ASSET_LINE'
, 'ASSET'
, 'SERVICE_LINE'
, 'SERVICE'
, 'FEE_LINE'
, 'FEE'
, 'SERVICED_ASSET_LINE'
, 'SERVICED ASSET'
, NULL) LINE_TYPE
, CAF.STY_ID STY_ID
, STM1.CODE STREAM_TYPE
, QCO.BASE_SOURCE_ID BASE_SOURCE_ID
, CAF.DUE_ARREARS_YN ADV_ARR
, CAF.NUMBER_OF_ADVANCE_PERIODS ADVANCE_PAYMENTS
, (NVL(SUM(AMOUNT * NUMBER_OF_PERIODS)
, 0) + NVL(SUM(STUB_AMOUNT)
, 0)) TOTAL
, HDR.CURRENCY_CODE CURRENCY_CODE
, CAF.STS_CODE PAYMENT_STATUS_CODE
, CAF.CFT_CODE CFT_CODE
FROM OKL_CASH_FLOWS CAF
, OKL_CASH_FLOW_LEVELS CFL
, OKL_CASH_FLOW_OBJECTS CFO
, OKC_K_LINES_V L
, OKL_TRX_QTE_CF_OBJECTS QCO
, OKC_K_HEADERS_B HDR
, OKL_STRM_TYPE_B STM1
, OKL_STRM_TYPE_V STM2
, OKC_K_ITEMS CIM
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 QCO.BASE_SOURCE_ID = L.ID(+)
AND HDR.ID = CAF.DNZ_KHR_ID
AND CAF.CFT_CODE = 'PAYMENT_SCHEDULE'
AND L.ID = CIM.CLE_ID(+)
AND CIM.OBJECT1_ID1 = STM2.ID(+) GROUP BY CAF.DNZ_QTE_ID
, CAF.DNZ_KHR_ID
, STM1.CODE
, CAF.STY_ID
, CFO.OTY_CODE
, L.NAME
, STM2.NAME
, L.ITEM_DESCRIPTION
, QCO.BASE_SOURCE_ID
, CAF.DUE_ARREARS_YN
, CAF.NUMBER_OF_ADVANCE_PERIODS
, HDR.CURRENCY_CODE
, CAF.STS_CODE
, CAF.CFT_CODE
Columns
Name |
QTE_ID |
DNZ_KHR_ID |
DESCRIPTION |
LINE_TYPE |
STY_ID |
STREAM_TYPE |
BASE_SOURCE_ID |
ADV_ARR |
ADVANCE_PAYMENTS |
TOTAL |
CURRENCY_CODE |
PAYMENT_STATUS_CODE |
CFT_CODE |