View: OKL_PAYMENT_SCHDLE_DTLS_ALL_UV

Product:	OKL - Lease and Finance Management
Description:	View gives the Detailed about the Payment Schedule Details.
Implementation/DBA Data:	APPS.OKL_PAYMENT_SCHDLE_DTLS_ALL_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_ALL_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