DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on OKX_CUST_SITE_USES_V

Line 86: , okx_cust_site_uses_v cs

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

Line 101: , okx_cust_site_uses_v cs

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