[Home] [Help]
139: From okl_supp_invoice_dtls inv
140: Where inv.fa_cle_id = faid;
141:
142: --Bug#3877032
143: CURSOR l_hdr_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
144: SELECT chr.SCS_CODE,
145: chr.START_DATE,
146: chr.DATE_SIGNED,
147: chr.CURRENCY_CODE,
152: khr.DEAL_TYPE,
153: khr.term_duration term,
154: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
155: FROM OKC_K_HEADERS_B chr,
156: OKL_K_HEADERS khr,
157: OKL_PRODUCTS_V pdt
158: WHERE chr.id = chrid
159: AND chr.id = khr.id
160: --AND khr.pdt_id = pdt.id(+);
168: AND ls.lty_code = 'FREE_FORM1'
169: AND kle.name = n;
170: l_ln l_line_name%ROWTYPE;
171:
172: CURSOR l_topsvclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
173: SELECT cle.id,
174: sub_kle.price_negotiated amount
175: FROM OKC_K_LINES_B cle,
176: OKC_K_LINES_B sub_kle,
183: AND sub_kle.id = lineId
184: AND cle.id = sub_kle.cle_id
185: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
186:
187: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
188: SELECT cle.id,
189: cle.price_negotiated amount
190: FROM OKC_K_LINES_B cle,
191: OKC_LINE_STYLES_B ls,
195: AND cle.dnz_chr_id = chrid
196: AND sts.code = cle.sts_code
197: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
198:
199: CURSOR l_toplne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
200: SELECT kle.name,
201: kle.CURRENCY_CODE,
202: kle.id,
203: kle.RESIDUAL_VALUE,
221: AND sub_kle.id = lineId
222: AND kle.id = sub_kle.cle_id
223: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
224:
225: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
226: SELECT kle.name,
227: kle.amount,
228: kle.CURRENCY_CODE,
229: kle.id,