APPS.OKL_CREDIT_MEMO_PVT dependencies on OKX_CUST_SITE_USES_V

Line 15: --cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;

11: --
12: -- Known limitations/enhancements and/or remarks:
13: --
14: ------------------------------------------------------------------------------
15: --cust_acct_site_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
16:
17:
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

Line 21: , okx_cust_site_uses_v cs

17:
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

Line 36: , okx_cust_site_uses_v cs

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
40: AND cle.id = p_kle_id

Line 51: , okx_cust_site_uses_v cs

47: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
48: SELECT cs.cust_acct_site_id
49: -- , cp.standard_terms payment_term_id
50: FROM okc_k_headers_v khr
51: , okx_cust_site_uses_v cs
52: , hz_customer_profiles cp
53: WHERE khr.id = p_khr_id
54: AND khr.bill_to_site_use_id = cs.id1
55: AND khr.bill_to_site_use_id = cp.site_use_id(+);