APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_LINES_B

Line 177: FROM OKC_K_LINES_B cle,

173:
174: CURSOR l_topsvclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
175: SELECT cle.id,
176: sub_kle.price_negotiated amount
177: FROM OKC_K_LINES_B cle,
178: OKC_K_LINES_B sub_kle,
179: OKC_LINE_STYLES_B ls,
180: OKC_STATUSES_B sts
181: WHERE cle.lse_id = ls.id

Line 178: OKC_K_LINES_B sub_kle,

174: CURSOR l_topsvclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
175: SELECT cle.id,
176: sub_kle.price_negotiated amount
177: FROM OKC_K_LINES_B cle,
178: OKC_K_LINES_B sub_kle,
179: OKC_LINE_STYLES_B ls,
180: OKC_STATUSES_B sts
181: WHERE cle.lse_id = ls.id
182: AND ls.lty_code = ltycode

Line 192: FROM OKC_K_LINES_B cle,

188:
189: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
190: SELECT cle.id,
191: cle.price_negotiated amount
192: FROM OKC_K_LINES_B cle,
193: OKC_LINE_STYLES_B ls,
194: OKC_STATUSES_B sts
195: WHERE cle.lse_id = ls.id
196: AND ls.lty_code = ltycode

Line 278: okc_k_lines_b kle,

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

Line 378: okc_k_lines_b fa,

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

Line 389: from okc_k_lines_b inst,

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

Line 437: FROM okc_k_lines_b cleb,

433: kle_id,
434: rulb2.rule_information2 start_date,rulb2.rule_information3 level_periods,
435: rulb2.rule_information7 stub_days,rulb2.rule_information8 stub_amount,
436: rulb2.rule_information10 arrear_yn
437: FROM okc_k_lines_b cleb,
438: okc_rule_groups_b rgpb,
439: okc_rules_b rulb,
440: okc_rules_b rulb2,
441: okl_strm_type_b styb,