APPS.OKC_PRICE_PUB dependencies on OKX_CUST_SITE_USES_V

Line 760: from OKX_CUST_SITE_USES_V a, okx_customer_accounts_v c

756: AND RULE_INFORMATION_CATEGORY = l_cat;
757:
758: Cursor Get_Cust_Csr(p_bill_to_id Number, p_party_id number) Is
759: Select c.id1
760: from OKX_CUST_SITE_USES_V a, okx_customer_accounts_v c
761: where a.party_id = p_party_id and
762: c.id1 = a.CUST_ACCOUNT_ID and
763: a.Id1 = p_bill_to_id And a.Name = 'BILL_TO';
764:

Line 2435: okx_cust_site_uses_v b

2431: i pls_integer :=0;
2432: CURSOR get_ship_to_site_id_cur (l_ship_to_org_id NUMBER) IS
2433: SELECT a.party_site_id
2434: FROM okx_cust_sites_v a,
2435: okx_cust_site_uses_v b
2436: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2437: AND b.id1 = l_ship_to_org_id
2438: AND b.site_use_code = 'SHIP_TO';
2439:

Line 2469: okx_cust_site_uses_v b

2465: i pls_integer :=0;
2466: CURSOR get_bill_to_site_id_cur (l_bill_to_org_id NUMBER) IS
2467: SELECT a.party_site_id
2468: FROM okx_cust_sites_v a,
2469: okx_cust_site_uses_v b
2470: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2471: AND b.id1 = l_bill_to_org_id
2472: AND b.site_use_code = 'BILL_TO';
2473: