APPS.OKC_PRICE_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_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 2104: -- Getting info from OKX_CUSTOMER_ACCOUNTS_V

2100: l_temp_tbl QP_Attr_Mapping_PUB.t_MultiRecord;
2101: i pls_integer;
2102: BEGIN
2103: G_Customer_Info.customer_id := p_cust_id;
2104: -- Getting info from OKX_CUSTOMER_ACCOUNTS_V
2105: BEGIN
2106: SELECT customer_class_code,
2107: sales_channel_code,
2108: gsa_indicator

Line 2113: FROM OKX_CUSTOMER_ACCOUNTS_V

2109: INTO G_Customer_Info.customer_class_code,
2110: G_Customer_Info.sales_channel_code,
2111: G_Customer_Info.gsa_indicator
2112: ---FROM ra_customers
2113: FROM OKX_CUSTOMER_ACCOUNTS_V
2114: WHERE ID1 = p_cust_id;
2115: --- WHERE CUST_ACCOUNT_ID = p_cust_id;
2116: ---FROM RA_customers
2117: --- WHERE customer_id = p_cust_id;

Line 2412: FROM okx_customer_accounts_v

2408: l_party_id NUMBER;
2409:
2410: CURSOR get_party_id_cur(l_sold_to_org_id NUMBER) IS
2411: SELECT party_id
2412: FROM okx_customer_accounts_v
2413: WHERE id1 = l_sold_to_org_id;
2414:
2415: BEGIN
2416: OPEN get_party_id_cur(p_sold_to_org_id);