eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_CUST_SITE_USES_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 2881: hz_cust_site_uses_all b,

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
2885: AND b.site_use_id = p_site_use_id;

Line 2988: HZ_CUST_SITE_USES_ALL S_SHIP,

2984:
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: ;

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 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 3788: HZ_CUST_SITE_USES_ALL CS

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,
3788: HZ_CUST_SITE_USES_ALL CS
3789: WHERE rl.dnz_chr_id = p_chr_id
3790: AND rl.id = line_id
3791: AND CS.SITE_USE_ID = decode(l_use_code, 'BILL_TO', rl.BILL_TO_SITE_USE_ID, rl.SHIP_TO_SITE_USE_ID)
3792: AND CS.SITE_USE_CODE = l_use_code -- 'BILL_TO' or 'SHIP_TO'

Line 3825: hz_cust_site_uses_all cs,

3821: cs.cust_acct_site_id,
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

Line 3845: hz_cust_site_uses_all cs,

3841: cs.cust_acct_site_id,
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

Line 3861: TYPE chr1a_tbl_type IS TABLE OF hz_cust_site_uses_all.status%TYPE INDEX BY BINARY_INTEGER;

3857: AND ca.cust_acct_site_id (+)= cs.cust_acct_site_id;
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;

Line 3882: HZ_CUST_SITE_USES_ALL CS

3878: -- 4132844 --
3879: CURSOR check_address_header(l_site_use_id IN NUMBER, l_site_use_code IN VARCHAR2) IS
3880: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
3881: FROM okc_k_headers_all_b rl,
3882: HZ_CUST_SITE_USES_ALL CS
3883: WHERE rl.id = p_chr_id
3884: AND CS.SITE_USE_ID = l_site_use_id
3885: AND CS.SITE_USE_CODE = l_site_use_code;
3886:

Line 4785: FROM hz_cust_site_uses_all site_uses,

4781:
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

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: