APPS.OKS_QA_DATA_INTEGRITY dependencies on OKX_CUST_SITE_USES_V

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

3926:
3927: /******
3928: -- Cursor CHECK_BILL_TO_ADDRESS to check if the bill to
3929: -- address is entered and is valid for all top lines.
3930: -- BTO rule. Replaced okx_cust_site_uses_v with HZ_CUST_SITE_USES_ALL
3931: CURSOR check_address (line_id NUMBER, l_use_code VARCHAR2)
3932: IS
3933: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
3934: FROM okc_k_lines_b rl,

Line 6754: FROM OKX_CUST_SITE_USES_V a,

6750: SELECT
6751: c.cust_account_id CUST_ID1,
6752: p.party_id party_id
6753:
6754: FROM OKX_CUST_SITE_USES_V a,
6755: hz_cust_accounts c,
6756: hz_parties p
6757: WHERE a.id1 = p_bill_to_site_use_id
6758: AND c.cust_account_id = a.cust_account_id

Line 6766: FROM OKX_CUST_SITE_USES_V a,

6762: CURSOR get_shipto_cust_acct(p_ship_to_site_use_id IN NUMBER) IS
6763: SELECT
6764: c.cust_account_id CUST_ID1,
6765: p.party_id party_id
6766: FROM OKX_CUST_SITE_USES_V a,
6767: hz_cust_accounts c,
6768: hz_parties p
6769: WHERE a.id1 = p_ship_to_site_use_id
6770: AND c.cust_account_id = a.cust_account_id

Line 7460: FROM Okx_cust_site_uses_v a

7456: -- Get the ship to address for shipable subscription line.
7457: -- have to use the okx view
7458: CURSOR ship_to_address(p_id IN VARCHAR2, Code VARCHAR2) IS
7459: SELECT a.location_id
7460: FROM Okx_cust_site_uses_v a
7461: WHERE a.id1 = p_id
7462: AND a.site_use_code = Code;
7463:
7464: l_shipable VARCHAR2(1);