APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_K_LINES_B

Line 1594: FROM OKS_K_LINES_B

1590:
1591: -- Rule_information10 in QRE
1592: CURSOR l_usage_type_csr(p_id NUMBER) IS
1593: SELECT Usage_type
1594: FROM OKS_K_LINES_B
1595: WHERE cle_id = p_id;
1596:
1597: -- Rule_information5 in QRE
1598: CURSOR l_default_csr(p_cle_id NUMBER) IS

Line 1600: FROM OKS_K_LINES_B

1596:
1597: -- Rule_information5 in QRE
1598: CURSOR l_default_csr(p_cle_id NUMBER) IS
1599: SELECT Default_quantity
1600: FROM OKS_K_LINES_B
1601: WHERE cle_id = p_cle_id;
1602:
1603: CURSOR l_salescredit_csr(p_cle_id NUMBER) IS
1604: SELECT NVL(SUM(PERCENT), 0)

Line 2911: OKS_K_LINES_B KLN

2907: exempt_reason_code
2908:
2909: FROM
2910: OKC_K_LINES_B CLEB,
2911: OKS_K_LINES_B KLN
2912: WHERE
2913: CLEB.dnz_chr_id = p_chr_id AND
2914: CLEB.ID = KLN.CLE_ID AND
2915: lse_id IN (1, 12, 19, 46);

Line 4773: FROM oks_k_lines_b oks,

4769: oks.object_version_number,
4770: oks.trxn_extension_id,
4771: oks.payment_type,
4772: okc.bill_to_site_use_id
4773: FROM oks_k_lines_b oks,
4774: okc_k_lines_b okc
4775: WHERE oks.dnz_chr_id = p_chr_id
4776: AND oks.cle_id = okc.id
4777: AND okc.date_cancelled IS NULL --4735326

Line 5235: UPDATE oks_k_lines_b

5231:
5232: --Go on to update_Authorization Info of line
5233: --we directly update instead of using public API to avoid locking issues
5234: --auth code could come from either IBY_FNDCPT_TRXN_PUB.Get_Authorization or IBY_FNDCPT_TRXN_PUB.Create_Authorization
5235: UPDATE oks_k_lines_b
5236: SET cc_auth_code = l_auth_result.auth_code
5237: WHERE id = l_oks_lines_rec.id;
5238:
5239: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5403: FROM okc_k_lines_b lines , oks_k_lines_b oks

5399: CURSOR top_line_grp_csr (p_hdr_id NUMBER) IS
5400: SELECT lines.id, lines.lse_id lse_id, lines.cle_id,
5401: lines.start_date, lines.end_date, lines.line_number, date_terminated,
5402: lines.price_negotiated, oks.credit_amount, oks.suppressed_credit, oks.override_amount
5403: FROM okc_k_lines_b lines , oks_k_lines_b oks
5404: WHERE lines.dnz_chr_id = p_hdr_id
5405: AND lines.cle_id IS NULL
5406: AND lines.lse_id IN (1, 12, 19, 46)
5407: AND lines.date_terminated IS NULL -- added by mkhayer 11/21/2002.

Line 5462: FROM oks_k_lines_b --okc_rules_b

5458: --get rle information E/T/P of top line
5459: -- SLH rule
5460: CURSOR get_ETP_csr (p_hdr_id NUMBER, p_cle_id NUMBER) IS
5461: SELECT BILLING_SCHEDULE_TYPE --rule_information1
5462: FROM oks_k_lines_b --okc_rules_b
5463: WHERE dnz_chr_id = p_hdr_id
5464: AND cle_id = p_cle_id;
5465:
5466: CURSOR level_elements_billed_csr (p_id NUMBER) IS

Line 7591: FROM okc_k_lines_b a, oks_k_lines_b b

7587:
7588: -- Gets old line id's that have a lock
7589: CURSOR get_old_line_id(l_old_chr_id NUMBER) IS
7590: SELECT b.cle_id
7591: FROM okc_k_lines_b a, oks_k_lines_b b
7592: WHERE a.id = b.cle_id
7593: AND b.dnz_chr_id = l_old_chr_id
7594: AND b.dnz_chr_id = a.dnz_chr_id
7595: AND a.lse_id IN (12, 13)

Line 7611: FROM oks_k_lines_b

7607: AND orig_system_id1 = l_old_line_id;
7608:
7609: CURSOR check_lock(l_chr_id NUMBER, l_cle_id NUMBER) IS
7610: SELECT cle_id
7611: FROM oks_k_lines_b
7612: WHERE dnz_chr_id = l_chr_id
7613: AND cle_id = l_cle_id
7614: AND LOCKED_PRICE_LIST_ID IS NOT NULL
7615: AND LOCKED_PRICE_LIST_LINE_ID IS NOT NULL;