APPS.OKS_QP_INT_PVT dependencies on OKS_K_LINES_B

Line 169: oks_k_lines_b cleb

165: CURSOR cs_subline_discount (cp_subline_id IN NUMBER) IS
166: SELECT kle.lse_id,
167: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty discount
168: FROM okc_k_lines_b kle,
169: oks_k_lines_b cleb
170: WHERE kle.ID = cp_subline_id
171: AND kle.ID = cleb.cle_id
172: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);
173: CURSOR cs_subline_qty (cp_subline_id IN NUMBER) IS

Line 213: oks_k_lines_b cleb

209: CURSOR cs_subline_surcharge(cp_subline_id IN NUMBER) IS
210: SELECT kle.lse_id,
211: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty surcharge
212: FROM okc_k_lines_b kle,
213: oks_k_lines_b cleb
214: WHERE kle.ID = cp_subline_id
215: AND kle.ID = cleb.cle_id
216: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);
217: CURSOR cs_subline_qty(cp_subline_id IN NUMBER) IS

Line 770: FROM oks_k_lines_b

766: )
767: IS
768: SELECT ID,
769: object_version_number
770: FROM oks_k_lines_b
771: WHERE cle_id = p_id;
772: BEGIN
773: -- start debug log
774: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 2654: FROM oks_k_lines_b

2650: p_id NUMBER
2651: )
2652: IS
2653: SELECT price_uom
2654: FROM oks_k_lines_b
2655: WHERE cle_id = p_id;
2656:
2657: CURSOR l_get_hdrid_csr (
2658: p_cle_id NUMBER