APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_ACCT_SITES

Line 339: FROM HZ_CUST_ACCT_SITES a

335:
336: -- get shipto customer based on shipto site
337: CURSOR shipto_cust_account_id_csr(p_site_use_id in number) is
338: select a.cust_account_id
339: FROM HZ_CUST_ACCT_SITES a
340: , HZ_CUST_SITE_USES s
341: WHERE a.cust_acct_site_id = s.cust_acct_site_id
342: and s.site_use_id = p_site_use_id;
343: l_shipto_cust_account_id number;

Line 357: FROM HZ_CUST_ACCT_SITES a

353: -- not good performance
354: CURSOR cust_info_csr (p_cust_acct_id in NUMBER) is
355: SELECT s.site_use_id -- b illto site
356: , s.contact_id -- party relation id (do not store this value- see SQL below)
357: FROM HZ_CUST_ACCT_SITES a
358: , HZ_CUST_SITE_USES s
359: WHERE a.cust_account_id = p_cust_acct_id
360: AND a.cust_acct_site_id = s.cust_acct_site_id
361: AND s.site_use_code = 'BILL_TO'

Line 370: FROM HZ_CUST_ACCT_SITES a

366:
367: -- get primary ship to information
368: CURSOR cust_shipinfo_csr (p_cust_acct_id in NUMBER) is
369: SELECT s.site_use_id --shipto site
370: FROM HZ_CUST_ACCT_SITES a
371: , HZ_CUST_SITE_USES s
372: WHERE a.cust_account_id = p_cust_acct_id
373: AND a.cust_acct_site_id = s.cust_acct_site_id
374: AND s.site_use_code = 'SHIP_TO'

Line 694: FROM hz_cust_acct_sites

690: l_account_hierarchy number;
691:
692: CURSOR account_code_csr(p_site_id in number)is
693: SELECT party_site_id
694: FROM hz_cust_acct_sites
695: WHERE cust_acct_site_id = p_site_id;
696:
697: CURSOR cust_account_info_csr(p_cust_account_id in number) is
698: SELECT party_id, sales_channel_code

Line 731: , hz_cust_acct_sites ac

727: --to get location_id (verify the sqls)
728: CURSOR location_id_csr(p_site_id in number) IS
729: SELECT ps.location_id
730: FROM hz_party_sites ps
731: , hz_cust_acct_sites ac
732: , hz_cust_site_uses su
733: WHERE ps.party_site_id = ac.party_site_id
734: AND ac.cust_acct_site_id = su.cust_acct_site_id
735: AND su.site_use_id = p_site_id;

Line 5370: FROM HZ_CUST_ACCT_SITES a

5366:
5367: -- get shipto customer based on shipto site
5368: CURSOR shipto_cust_account_id_csr(p_site_use_id in number) is
5369: select a.cust_account_id
5370: FROM HZ_CUST_ACCT_SITES a
5371: , HZ_CUST_SITE_USES s
5372: WHERE a.cust_acct_site_id = s.cust_acct_site_id
5373: and s.site_use_id = p_site_use_id;
5374:

Line 6747: hz_cust_acct_sites hcas,

6743: p_site_use_code in varchar2,
6744: p_site_use_id in number) IS
6745: SELECT count(hcsu.site_use_id)
6746: FROM hz_cust_accounts hca,
6747: hz_cust_acct_sites hcas,
6748: hz_cust_site_uses hcsu
6749: WHERE hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6750: AND hcas.cust_account_id = hca.cust_account_id
6751: AND hcsu.status = 'A'