APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_K_LINES_B

Line 1663: FROM OKS_K_LINES_B

1659:
1660: -- Rule_information10 in QRE
1661: CURSOR l_usage_type_csr(p_id NUMBER) IS
1662: SELECT Usage_type
1663: FROM OKS_K_LINES_B
1664: WHERE cle_id = p_id;
1665:
1666: -- Rule_information5 in QRE
1667: CURSOR l_default_csr(p_cle_id NUMBER) IS

Line 1669: FROM OKS_K_LINES_B

1665:
1666: -- Rule_information5 in QRE
1667: CURSOR l_default_csr(p_cle_id NUMBER) IS
1668: SELECT Default_quantity
1669: FROM OKS_K_LINES_B
1670: WHERE cle_id = p_cle_id;
1671:
1672: CURSOR l_salescredit_csr(p_cle_id NUMBER) IS
1673: SELECT NVL(SUM(PERCENT), 0)

Line 2980: OKS_K_LINES_B KLN

2976: exempt_reason_code
2977:
2978: FROM
2979: OKC_K_LINES_B CLEB,
2980: OKS_K_LINES_B KLN
2981: WHERE
2982: CLEB.dnz_chr_id = p_chr_id AND
2983: CLEB.ID = KLN.CLE_ID AND
2984: lse_id IN (1, 12, 19, 46);

Line 4920: FROM oks_k_lines_b oks,

4916: oks.object_version_number,
4917: oks.trxn_extension_id,
4918: oks.payment_type,
4919: okc.bill_to_site_use_id
4920: FROM oks_k_lines_b oks,
4921: okc_k_lines_b okc
4922: WHERE oks.dnz_chr_id = p_chr_id
4923: AND oks.cle_id = okc.id
4924: AND okc.date_cancelled IS NULL --4735326

Line 5382: UPDATE oks_k_lines_b

5378:
5379: --Go on to update_Authorization Info of line
5380: --we directly update instead of using public API to avoid locking issues
5381: --auth code could come from either IBY_FNDCPT_TRXN_PUB.Get_Authorization or IBY_FNDCPT_TRXN_PUB.Create_Authorization
5382: UPDATE oks_k_lines_b
5383: SET cc_auth_code = l_auth_result.auth_code
5384: WHERE id = l_oks_lines_rec.id;
5385:
5386: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5550: FROM okc_k_lines_b lines , oks_k_lines_b oks

5546: CURSOR top_line_grp_csr (p_hdr_id NUMBER) IS
5547: SELECT lines.id, lines.lse_id lse_id, lines.cle_id,
5548: lines.start_date, lines.end_date, lines.line_number, date_terminated,
5549: lines.price_negotiated, oks.credit_amount, oks.suppressed_credit, oks.override_amount
5550: FROM okc_k_lines_b lines , oks_k_lines_b oks
5551: WHERE lines.dnz_chr_id = p_hdr_id
5552: AND lines.cle_id IS NULL
5553: AND lines.lse_id IN (1, 12, 19, 46)
5554: AND lines.date_terminated IS NULL -- added by mkhayer 11/21/2002.

Line 5609: FROM oks_k_lines_b --okc_rules_b

5605: --get rle information E/T/P of top line
5606: -- SLH rule
5607: CURSOR get_ETP_csr (p_hdr_id NUMBER, p_cle_id NUMBER) IS
5608: SELECT BILLING_SCHEDULE_TYPE --rule_information1
5609: FROM oks_k_lines_b --okc_rules_b
5610: WHERE dnz_chr_id = p_hdr_id
5611: AND cle_id = p_cle_id;
5612:
5613: CURSOR level_elements_billed_csr (p_id NUMBER) IS

Line 7740: FROM okc_k_lines_b a, oks_k_lines_b b

7736:
7737: -- Gets old line id's that have a lock
7738: CURSOR get_old_line_id(l_old_chr_id NUMBER) IS
7739: SELECT b.cle_id
7740: FROM okc_k_lines_b a, oks_k_lines_b b
7741: WHERE a.id = b.cle_id
7742: AND b.dnz_chr_id = l_old_chr_id
7743: AND b.dnz_chr_id = a.dnz_chr_id
7744: AND a.lse_id IN (12, 13)

Line 7760: FROM oks_k_lines_b

7756: AND orig_system_id1 = l_old_line_id;
7757:
7758: CURSOR check_lock(l_chr_id NUMBER, l_cle_id NUMBER) IS
7759: SELECT cle_id
7760: FROM oks_k_lines_b
7761: WHERE dnz_chr_id = l_chr_id
7762: AND cle_id = l_cle_id
7763: AND LOCKED_PRICE_LIST_ID IS NOT NULL
7764: AND LOCKED_PRICE_LIST_LINE_ID IS NOT NULL;