VIEW: APPS.OKL_CURE_VENDOR_DUE_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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