APPS.OKS_QA_DATA_INTEGRITY dependencies on OKX_CUST_SITE_USES_V

Line 3783: -- BTO rule. Replaced okx_cust_site_uses_v with HZ_CUST_SITE_USES_ALL

3779:
3780: /******
3781: -- Cursor CHECK_BILL_TO_ADDRESS to check if the bill to
3782: -- address is entered and is valid for all top lines.
3783: -- BTO rule. Replaced okx_cust_site_uses_v with HZ_CUST_SITE_USES_ALL
3784: CURSOR check_address (line_id NUMBER, l_use_code VARCHAR2)
3785: IS
3786: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
3787: FROM okc_k_lines_b rl,

Line 6607: FROM OKX_CUST_SITE_USES_V a,

6603: SELECT
6604: c.cust_account_id CUST_ID1,
6605: p.party_id party_id
6606:
6607: FROM OKX_CUST_SITE_USES_V a,
6608: hz_cust_accounts c,
6609: hz_parties p
6610: WHERE a.id1 = p_bill_to_site_use_id
6611: AND c.cust_account_id = a.cust_account_id

Line 6619: FROM OKX_CUST_SITE_USES_V a,

6615: CURSOR get_shipto_cust_acct(p_ship_to_site_use_id IN NUMBER) IS
6616: SELECT
6617: c.cust_account_id CUST_ID1,
6618: p.party_id party_id
6619: FROM OKX_CUST_SITE_USES_V a,
6620: hz_cust_accounts c,
6621: hz_parties p
6622: WHERE a.id1 = p_ship_to_site_use_id
6623: AND c.cust_account_id = a.cust_account_id

Line 7311: FROM Okx_cust_site_uses_v a

7307: -- Get the ship to address for shipable subscription line.
7308: -- have to use the okx view
7309: CURSOR ship_to_address(p_id IN VARCHAR2, Code VARCHAR2) IS
7310: SELECT a.location_id
7311: FROM Okx_cust_site_uses_v a
7312: WHERE a.id1 = p_id
7313: AND a.site_use_code = Code;
7314:
7315: l_shipable VARCHAR2(1);