DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKC_K_HEADERS_V

Line 4524: FROM okc_k_headers_v khr

4520:
4521: -- K level Bill to Site
4522: CURSOR cust_acct_site_csr (cp_khr_id IN NUMBER) IS
4523: SELECT cs.cust_acct_site_id
4524: FROM okc_k_headers_v khr
4525: , okx_cust_site_uses_v cs
4526: , hz_customer_profiles cp
4527: WHERE khr.id = cp_khr_id
4528: AND khr.bill_to_site_use_id = cs.id1

Line 4535: FROM okc_k_headers_v

4531: -- Customer Account, Org Id cursor
4532: CURSOR cust_acct_csr(p_khr_id IN NUMBER) IS
4533: SELECT cust_acct_id,
4534: authoring_org_id
4535: FROM okc_k_headers_v
4536: WHERE id = p_khr_id;
4537:
4538: -- Customer Name, Customer Account Number
4539: CURSOR c_cust_name(cp_cust_acct_id IN NUMBER) IS