APPS.OKL_CREDIT_MEMO_PVT dependencies on STANDARD

Line 19: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id

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

Line 31: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id

27: AND cle.id = p_kle_id
28: AND cle.BILL_TO_SITE_USE_ID = cs.id1
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

Line 49: -- , cp.standard_terms payment_term_id

45: AND khr.bill_to_site_use_id = cp.site_use_id(+);
46:
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