DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 88: , hz_customer_profiles cp

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
91: AND cle.chr_id IS NOT NULL
92: AND cle.id = p_kle_id

Line 102: , hz_customer_profiles cp

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
106: AND cle.chr_id IS NULL