APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_SITE_USES

Line 393: , HZ_CUST_SITE_USES s

389: -- get shipto customer based on shipto site
390: CURSOR shipto_cust_account_id_csr(p_site_use_id in number) is
391: select a.cust_account_id
392: FROM HZ_CUST_ACCT_SITES a
393: , HZ_CUST_SITE_USES s
394: WHERE a.cust_acct_site_id = s.cust_acct_site_id
395: and s.site_use_id = p_site_use_id;
396: l_shipto_cust_account_id number;
397:

Line 401: FROM HZ_CUST_SITE_USES

397:
398: --default bill_to based on ship_to
399: CURSOR bill_to_bsd_ship_to_csr (p_shipto_id in number) is
400: SELECT bill_to_site_use_id
401: FROM HZ_CUST_SITE_USES
402: WHERE site_use_id = p_shipto_id;
403:
404: -- default get billto_site and pseudo salesrep_id, contact_id
405: -- from customer account table

Line 411: , HZ_CUST_SITE_USES s

407: CURSOR cust_info_csr (p_cust_acct_id in NUMBER) is
408: SELECT s.site_use_id -- b illto site
409: , s.contact_id -- party relation id (do not store this value- see SQL below)
410: FROM HZ_CUST_ACCT_SITES a
411: , HZ_CUST_SITE_USES s
412: WHERE a.cust_account_id = p_cust_acct_id
413: AND a.cust_acct_site_id = s.cust_acct_site_id
414: AND s.site_use_code = 'BILL_TO'
415: AND s.primary_flag = 'Y';

Line 424: , HZ_CUST_SITE_USES s

420: -- get primary ship to information
421: CURSOR cust_shipinfo_csr (p_cust_acct_id in NUMBER) is
422: SELECT s.site_use_id --shipto site
423: FROM HZ_CUST_ACCT_SITES a
424: , HZ_CUST_SITE_USES s
425: WHERE a.cust_account_id = p_cust_acct_id
426: AND a.cust_acct_site_id = s.cust_acct_site_id
427: AND s.site_use_code = 'SHIP_TO'
428: AND s.primary_flag = 'Y';

Line 446: FROM HZ_CUST_SITE_USES s

442:
443: -- default salesrep resource based on bill to/ship to
444: CURSOR salesrep_csr(p_site_use_id in number) is
445: SELECT s.primary_salesrep_id -- salesrep id, r.name, r.resource_id -- resource id
446: FROM HZ_CUST_SITE_USES s
447: WHERE s.site_use_id = p_site_use_id;
448:
449: CURSOR PRM_SALES_REP_CSR (p_source_object_id in number)is
450: select primary_salesrep_id

Line 786: FROM hz_cust_site_uses

782: -- For Bug#9146716 (-)
783:
784: CURSOR site_use_code_csr(p_site_use_id in number) is
785: SELECT site_use_code
786: FROM hz_cust_site_uses
787: WHERE site_use_id = p_site_use_id;
788:
789: --based on ship to site if found, else bill to site.
790: -- location_id is the primary key for hz_locations.

Line 796: , hz_cust_site_uses su

792: CURSOR location_id_csr(p_site_id in number) IS
793: SELECT ps.location_id
794: FROM hz_party_sites ps
795: , hz_cust_acct_sites ac
796: , hz_cust_site_uses su
797: WHERE ps.party_site_id = ac.party_site_id
798: AND ac.cust_acct_site_id = su.cust_acct_site_id
799: AND su.site_use_id = p_site_id;
800: l_location_id number;

Line 6261: , HZ_CUST_SITE_USES s

6257: -- get shipto customer based on shipto site
6258: CURSOR shipto_cust_account_id_csr(p_site_use_id in number) is
6259: select a.cust_account_id
6260: FROM HZ_CUST_ACCT_SITES a
6261: , HZ_CUST_SITE_USES s
6262: WHERE a.cust_acct_site_id = s.cust_acct_site_id
6263: and s.site_use_id = p_site_use_id;
6264:
6265: CURSOR csr_user_status_info(p_claim_id in number) is

Line 8401: hz_cust_site_uses hcsu

8397: p_site_use_id in number) IS
8398: SELECT count(hcsu.site_use_id)
8399: FROM hz_cust_accounts hca,
8400: hz_cust_acct_sites hcas,
8401: hz_cust_site_uses hcsu
8402: WHERE hcas.cust_acct_site_id = hcsu.cust_acct_site_id
8403: AND hcas.cust_account_id = hca.cust_account_id
8404: AND hcsu.status = 'A'
8405: AND hca.cust_account_id = p_cust_id