eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QP_INT_PVT dependencies on OKS_K_LINES_B

Line 191: oks_k_lines_b cleb

187: CURSOR cs_subline_discount (cp_subline_id IN NUMBER) IS
188: SELECT kle.lse_id,
189: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty discount
190: FROM okc_k_lines_b kle,
191: oks_k_lines_b cleb
192: WHERE kle.ID = cp_subline_id
193: AND kle.ID = cleb.cle_id
194: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);
195: CURSOR cs_subline_qty (cp_subline_id IN NUMBER) IS

Line 235: oks_k_lines_b cleb

231: CURSOR cs_subline_surcharge(cp_subline_id IN NUMBER) IS
232: SELECT kle.lse_id,
233: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty surcharge
234: FROM okc_k_lines_b kle,
235: oks_k_lines_b cleb
236: WHERE kle.ID = cp_subline_id
237: AND kle.ID = cleb.cle_id
238: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);
239: CURSOR cs_subline_qty(cp_subline_id IN NUMBER) IS

Line 792: FROM oks_k_lines_b

788: )
789: IS
790: SELECT ID,
791: object_version_number
792: FROM oks_k_lines_b
793: WHERE cle_id = p_id;
794: BEGIN
795: -- start debug log
796: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 2690: FROM oks_k_lines_b

2686: p_id NUMBER
2687: )
2688: IS
2689: SELECT price_uom
2690: FROM oks_k_lines_b
2691: WHERE cle_id = p_id;
2692:
2693: CURSOR l_get_hdrid_csr (
2694: p_cle_id NUMBER