APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_LINES_B

Line 175: FROM OKC_K_LINES_B cle,

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,
177: OKC_LINE_STYLES_B ls,
178: OKC_STATUSES_B sts
179: WHERE cle.lse_id = ls.id

Line 176: OKC_K_LINES_B sub_kle,

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,
177: OKC_LINE_STYLES_B ls,
178: OKC_STATUSES_B sts
179: WHERE cle.lse_id = ls.id
180: AND ls.lty_code = ltycode

Line 190: FROM OKC_K_LINES_B cle,

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,
192: OKC_STATUSES_B sts
193: WHERE cle.lse_id = ls.id
194: AND ls.lty_code = ltycode

Line 276: okc_k_lines_b kle,

272: Cursor l_svcline_csr( kleId NUMBER) is
273: select okx.inventory_item_id,
274: okx.quantity
275: from csi_item_instances okx,
276: okc_k_lines_b kle,
277: OKC_LINE_STYLES_B LS,
278: okc_k_items cim
279: where okx.instance_ID = cim.object1_id1
280: and LS.ID = KLE.LSE_ID

Line 376: okc_k_lines_b fa,

372: Cursor asst_qty_csr (FinAsstid NUMBER) is
373: select cim.number_of_items,
374: fa.id fa_id
375: from okc_k_items cim,
376: okc_k_lines_b fa,
377: okc_line_styles_b fa_lse
378: where cim.cle_id = fa.id
379: and cim.dnz_chr_id = fa.dnz_chr_id
380: and fa.lse_id = fa_lse.id

Line 387: from okc_k_lines_b inst,

383:
384:
385: Cursor ib_qty_csr (FinAsstid NUMBER) is
386: select count(inst.id)
387: from okc_k_lines_b inst,
388: okc_line_styles_b inst_lse
389: where inst.cle_id = FinAsstId
390: and inst.lse_id = inst_lse.id
391: and inst_lse.lty_code = 'FREE_FORM2';