APPS.OKL_REPORT_PVT dependencies on OKX_CUST_SITE_USES_V

Line 4525: , okx_cust_site_uses_v cs

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
4529: AND khr.bill_to_site_use_id = cp.site_use_id(+);

Line 4548: CURSOR c_cust_site_name(cp_cust_acct_site_id IN okx_cust_site_uses_v.cust_acct_site_id%TYPE) IS

4544: WHERE hp.id1 = hca.party_id
4545: AND hca.cust_account_id = cp_cust_acct_id;
4546:
4547: -- Customer Site Name
4548: CURSOR c_cust_site_name(cp_cust_acct_site_id IN okx_cust_site_uses_v.cust_acct_site_id%TYPE) IS
4549: SELECT description
4550: FROM okx_cust_sites_v
4551: WHERE cust_acct_site_id = cp_cust_acct_site_id;
4552:

Line 4613: , okx_cust_site_uses_v cs

4609: CURSOR line_bill_to_csr(p_khr_id IN NUMBER,
4610: p_kle_id IN NUMBER) IS
4611: SELECT cs.cust_acct_site_id
4612: FROM okc_k_headers_b khr
4613: , okx_cust_site_uses_v cs
4614: , okc_k_lines_b cle
4615: , hz_customer_profiles cp
4616: WHERE khr.id = p_khr_id
4617: AND cle.dnz_chr_id = khr.id

Line 4628: , okx_cust_site_uses_v cs

4624: FROM okc_k_headers_b khr
4625: , okc_k_lines_b cle
4626: , okc_k_items item
4627: , okc_k_lines_b linked_asset
4628: , okx_cust_site_uses_v cs
4629: , hz_customer_profiles cp
4630: WHERE khr.id = p_khr_id
4631: AND cle.dnz_chr_id = khr.id
4632: AND cle.id = p_kle_id

Line 4799: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;

4795: l_rct_method_code ar_receipt_classes.creation_method_code%TYPE;
4796: l_ext_customer_id Okl_Ext_Sell_Invs_V.customer_id%TYPE;
4797: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4798: l_party_name okx_parties_v.name%TYPE;
4799: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
4800: l_cust_site_name okx_cust_sites_v.description%TYPE;
4801: l_pmth_id1 okc_rules_b.object1_id1%TYPE;
4802: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;
4803: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;