APPS.OKL_CREDIT_MEMO_PVT dependencies on OKC_K_LINES_B

Line 22: , okc_k_lines_b cle

18: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
19: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
20: FROM okc_k_headers_b khr
21: , okx_cust_site_uses_v cs
22: , okc_k_lines_b cle
23: , hz_customer_profiles cp
24: WHERE khr.id = p_khr_id
25: AND cle.dnz_chr_id = khr.id
26: AND cle.chr_id IS NOT NULL

Line 33: , okc_k_lines_b cle

29: AND khr.bill_to_site_use_id = cp.site_use_id(+)
30: UNION
31: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
32: FROM okc_k_headers_b khr
33: , okc_k_lines_b cle
34: , okc_k_items item
35: , okc_k_lines_b linked_asset
36: , okx_cust_site_uses_v cs
37: , hz_customer_profiles cp

Line 35: , okc_k_lines_b linked_asset

31: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
32: FROM okc_k_headers_b khr
33: , okc_k_lines_b cle
34: , okc_k_items item
35: , okc_k_lines_b linked_asset
36: , okx_cust_site_uses_v cs
37: , hz_customer_profiles cp
38: WHERE khr.id = p_khr_id
39: AND cle.dnz_chr_id = khr.id

Line 156: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

152: okc_k_headers_b chr
153: WHERE
154: EXISTS ( SELECT 'x' FROM okc_k_items cim
155: WHERE cim.object1_id1 = to_char(chr.id) AND
156: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
157: WHERE cle.lse_id = lse.id AND
158: lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND
159: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2
160: WHERE chr2.id = cim.dnz_chr_id AND