VIEW: APPS.OKL_PAYMENT_SCHDLE_DTLS_ALL_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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