View: OKL_CURE_VENDOR_DUE_UV

Product:	OKL - Lease and Finance Management
Description:	Vendor Cure view
Implementation/DBA Data:	APPS.OKL_CURE_VENDOR_DUE_UV

View Text

SELECT VND.ID1 VENDOR_ID
, SUM(NVL(NEGOTIATED_AMOUNT
, 0) - NVL(RECEIVED_AMOUNT
, 0)) VENDOR_CURE_DUE
, VND.NAME VENDOR_NAME
FROM OKL_K_HEADERS KHR
, OKC_K_HEADERS_B PROG
, OKC_K_PARTY_ROLES_B PTY
, OKL_CURE_AMOUNTS_ALL CAM
, OKX_VENDORS_V VND
WHERE CAM.CHR_ID = KHR.ID
AND KHR.KHR_ID = PROG.ID
AND PROG.ID = PTY.CHR_ID
AND PTY.RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 =TO_CHAR( VND.ID1)
AND PTY.OBJECT1_ID2 =TO_CHAR( VND.ID2)
AND NVL(CAM.NEGOTIATED_AMOUNT
, 0) > 0
AND CAM.STATUS ='CURESINPROGRESS' GROUP BY VND.ID1
, VND.NAME

Columns