58: SELECT
59: NVL(SUM(PRICE_NEGOTIATED)
60: ,0)
61: FROM
62: OKC_K_LINES_B
63: WHERE DNZ_CHR_ID = CONTRACT_ID
64: AND LSE_ID in ( 25 , 7 , 9 , 10 , 8 , 35 , 11 )
65: AND DATE_CANCELLED is NULL
66: AND PRICE_NEGOTIATED between 0
109: ,MONTHS_BETWEEN(P_REGZ_DATE
110: ,KL.START_DATE))))
111: ,0)
112: FROM
113: OKC_K_LINES_B KL
114: WHERE KL.DNZ_CHR_ID = CONTRACT_ID
115: AND KL.LSE_ID in ( 25 , 7 , 9 , 10 , 8 , 35 , 11 )
116: AND KL.PRICE_NEGOTIATED between 0
117: AND 90999999