APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_SITE_USES

Line 340: , HZ_CUST_SITE_USES s

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

Line 348: FROM HZ_CUST_SITE_USES

344:
345: --default bill_to based on ship_to
346: CURSOR bill_to_bsd_ship_to_csr (p_shipto_id in number) is
347: SELECT bill_to_site_use_id
348: FROM HZ_CUST_SITE_USES
349: WHERE site_use_id = p_shipto_id;
350:
351: -- default get billto_site and pseudo salesrep_id, contact_id
352: -- from customer account table

Line 358: , HZ_CUST_SITE_USES s

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'
362: AND s.primary_flag = 'Y';

Line 371: , HZ_CUST_SITE_USES s

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'
375: AND s.primary_flag = 'Y';

Line 393: FROM HZ_CUST_SITE_USES s

389:
390: -- default salesrep resource based on bill to/ship to
391: CURSOR salesrep_csr(p_site_use_id in number) is
392: SELECT s.primary_salesrep_id -- salesrep id, r.name, r.resource_id -- resource id
393: FROM HZ_CUST_SITE_USES s
394: WHERE s.site_use_id = p_site_use_id;
395:
396: CURSOR PRM_SALES_REP_CSR (p_source_object_id in number)is
397: select primary_salesrep_id

Line 722: FROM hz_cust_site_uses

718: AND site_use_id = p_site_use_id;
719:
720: CURSOR site_use_code_csr(p_site_use_id in number) is
721: SELECT site_use_code
722: FROM hz_cust_site_uses
723: WHERE site_use_id = p_site_use_id;
724:
725: --based on ship to site if found, else bill to site.
726: -- location_id is the primary key for hz_locations.

Line 732: , hz_cust_site_uses su

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;
736: l_location_id number;

Line 5371: , HZ_CUST_SITE_USES s

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:
5375: CURSOR csr_user_status_info(p_claim_id in number) is

Line 6748: hz_cust_site_uses hcsu

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'
6752: AND hca.cust_account_id = p_cust_id