APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKX_CUST_SITE_USES_V

Line 72: , okx_cust_site_uses_v cs

68: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
69: SELECT cs.cust_acct_site_id
70: , cp.standard_terms payment_term_id
71: FROM okc_k_headers_v khr
72: , okx_cust_site_uses_v cs
73: , hz_customer_profiles cp
74: WHERE khr.id = p_khr_id
75: AND khr.bill_to_site_use_id = cs.id1
76: AND khr.bill_to_site_use_id = cp.site_use_id(+);

Line 83: , okx_cust_site_uses_v cs

79: -- Changed CURSOR line_bill_to_csr SQL definition
80: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
81: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
82: FROM okc_k_headers_b khr
83: , okx_cust_site_uses_v cs
84: , okc_k_lines_b cle
85: , hz_customer_profiles cp
86: WHERE khr.id = p_khr_id
87: AND cle.dnz_chr_id = khr.id

Line 98: , okx_cust_site_uses_v cs

94: FROM okc_k_headers_b khr
95: , okc_k_lines_b cle
96: , okc_k_items item
97: , okc_k_lines_b linked_asset
98: , okx_cust_site_uses_v cs
99: , hz_customer_profiles cp
100: WHERE khr.id = p_khr_id
101: AND cle.dnz_chr_id = khr.id
102: AND cle.id = p_kle_id