DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 73: , hz_customer_profiles cp

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(+);
77: */

Line 85: , hz_customer_profiles cp

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

Line 99: , hz_customer_profiles cp

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