APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1621: FROM HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS

1617: WHERE id1 = p_contact_id;
1618:
1619: CURSOR l_customer_csr(l_billto_siteuse_id IN VARCHAR2) IS
1620: SELECT CA.CUST_ACCOUNT_ID
1621: FROM HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS
1622: WHERE CS.SITE_USE_ID = l_billto_siteuse_id
1623: AND CS.SITE_USE_CODE = 'BILL_TO'
1624: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID;
1625:

Line 2880: FROM hz_cust_acct_sites_all a,

2876: SELECT c.party_id,
2877: a.party_site_id,
2878: a.cust_account_id,
2879: a.org_id
2880: FROM hz_cust_acct_sites_all a,
2881: hz_cust_site_uses_all b,
2882: hz_party_sites c
2883: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2884: AND c.party_site_id = a.party_site_id

Line 2989: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP

2985: CURSOR cust_acct_csr(p_site_use_id NUMBER) IS
2986: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID
2987: FROM
2988: HZ_CUST_SITE_USES_ALL S_SHIP,
2989: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP
2990: WHERE S_SHIP.SITE_USE_ID = p_site_use_id
2991: AND S_SHIP.CUST_ACCT_SITE_ID = acct_site_ship.cust_acct_site_id
2992: ;
2993:

Line 3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,

3693: IS
3694: SELECT prt.party_name
3695: FROM oe_hold_sources_all ohs,
3696: HZ_PARTIES prt,
3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3698: okc_k_headers_all_b rl
3699: WHERE ohs.hold_entity_code = 'C'
3700: AND ohs.released_flag = 'N'
3701: AND ohs.org_id = okc_context.get_okc_org_id

Line 3799: FROM HZ_CUST_ACCT_SITES_ALL CA

3795: ******/
3796:
3797: CURSOR check_site (l_cust_acct_site_id NUMBER) IS
3798: SELECT CA.STATUS STATUS
3799: FROM HZ_CUST_ACCT_SITES_ALL CA
3800: WHERE CA.CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3801:
3802: /******
3803: -- checks bill to address for top lines.

Line 3826: hz_cust_acct_sites_all ca

3822: ca.status site_status,
3823: 'BILL_TO' use_code
3824: FROM okc_k_lines_b rl,
3825: hz_cust_site_uses_all cs,
3826: hz_cust_acct_sites_all ca
3827: WHERE rl.dnz_chr_id = p_chr_id
3828: AND rl.chr_id = p_chr_id
3829: AND rl.cle_id IS NULL
3830: AND rl.lse_id IN (1,12, 14, 19, 46)

Line 3846: hz_cust_acct_sites_all ca

3842: ca.status site_status,
3843: 'SHIP_TO' use_code
3844: FROM okc_k_lines_b rl,
3845: hz_cust_site_uses_all cs,
3846: hz_cust_acct_sites_all ca
3847: WHERE rl.dnz_chr_id = p_chr_id
3848: AND rl.chr_id = p_chr_id
3849: AND rl.cle_id IS NULL
3850: AND rl.lse_id IN (1,12, 14, 19, 46)

Line 3862: TYPE chr1b_tbl_type IS TABLE OF hz_cust_acct_sites_all.status%TYPE INDEX BY BINARY_INTEGER;

3858:
3859: TYPE chr150_tbl_type IS TABLE OF okc_k_lines_b.line_number%TYPE INDEX BY BINARY_INTEGER;
3860: TYPE chr7_tbl_type IS TABLE OF VARCHAR2(7) INDEX BY BINARY_INTEGER;
3861: TYPE chr1a_tbl_type IS TABLE OF hz_cust_site_uses_all.status%TYPE INDEX BY BINARY_INTEGER;
3862: TYPE chr1b_tbl_type IS TABLE OF hz_cust_acct_sites_all.status%TYPE INDEX BY BINARY_INTEGER;
3863: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3864:
3865: l_id_tbl num_tbl_type;
3866: l_line_number_tbl chr150_tbl_type;

Line 4786: hz_cust_acct_sites_all sites,

4782: CURSOR cust_account_csr(p_site_use_id VARCHAR2, p_site_use_code VARCHAR2) IS
4783: SELECT accts.party_id,
4784: sites.cust_account_id
4785: FROM hz_cust_site_uses_all site_uses,
4786: hz_cust_acct_sites_all sites,
4787: hz_cust_accounts accts
4788: WHERE site_uses.site_use_id = p_site_use_id
4789: AND site_uses.site_use_code = p_site_use_code
4790: AND site_uses.cust_acct_site_id = sites.cust_acct_site_id

Line 6563: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

6559:
6560: -- gets ship to customber account id
6561: CURSOR get_ship_to_acct(l_site_use_id NUMBER) IS
6562: SELECT CA.cust_account_id
6563: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA
6564: WHERE CS.SITE_USE_ID = l_site_use_id
6565: AND CS.site_use_code = 'SHIP_TO'
6566: AND CS.cust_acct_site_id = CA.cust_acct_site_id;
6567: