APPS.OKE_CLE_PVT dependencies on OKC_K_LINES_B

Line 91: OKC_K_HEADERS_B H, OKC_K_LINES_B L

87: where item.customer_item_id = p_cle_rec.customer_item_id;
88:
89: CURSOR get_intent IS
90: SELECT BUY_OR_SELL FROM
91: OKC_K_HEADERS_B H, OKC_K_LINES_B L
92: WHERE L.DNZ_CHR_ID = H.ID
93: AND L.ID = p_cle_rec.k_line_id;
94:
95: l_intent VARCHAR2(30);

Line 173: from okc_k_lines_b

169: ) IS
170:
171: CURSOR c_dates IS
172: select trunc(start_date)
173: from okc_k_lines_b
174: where id = p_cle_rec.k_line_id;
175:
176:
177: l_start DATE;

Line 240: FROM OKC_K_LINES_B

236: l_header_id NUMBER;
237:
238: CURSOR get_line_info IS
239: SELECT DNZ_CHR_ID, CLE_ID
240: FROM OKC_K_LINES_B
241: WHERE ID = p_cle_rec.K_LINE_ID;
242:
243: CURSOR get_higher IS
244: SELECT KE.PROJECT_ID,KE.TASK_ID

Line 438: FROM OKC_K_LINES_B

434: l_header_id NUMBER;
435:
436: CURSOR get_line_info IS
437: SELECT DNZ_CHR_ID, CLE_ID
438: FROM OKC_K_LINES_B
439: WHERE ID = p_cle_rec.K_LINE_ID;
440:
441: CURSOR get_higher IS
442: SELECT KE.PROJECT_ID,KE.TASK_ID

Line 582: OKC_K_HEADERS_B H,OKC_K_LINES_B L

578: l_lse_id NUMBER;
579:
580: CURSOR get_org IS
581: SELECT INV_ORGANIZATION_ID FROM
582: OKC_K_HEADERS_B H,OKC_K_LINES_B L
583: WHERE H.ID = L.DNZ_CHR_ID
584: AND L.ID = p_cle_rec.k_line_id;
585:
586: CURSOR get_lse_id IS

Line 587: SELECT lse_id from okc_k_lines_b

583: WHERE H.ID = L.DNZ_CHR_ID
584: AND L.ID = p_cle_rec.k_line_id;
585:
586: CURSOR get_lse_id IS
587: SELECT lse_id from okc_k_lines_b
588: WHERE ID = p_cle_rec.k_line_id;
589:
590: CURSOR l_csr IS
591: SELECT 'x' FROM OKE_SYSTEM_ITEMS_V

Line 694: FROM OKC_K_LINES_B

690: ) IS
691:
692: CURSOR get_header IS
693: SELECT DNZ_CHR_ID
694: FROM OKC_K_LINES_B
695: WHERE ID = p_cle_rec.k_line_id;
696:
697: l_header NUMBER;
698: