APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_ACCT_SITES

Line 392: FROM HZ_CUST_ACCT_SITES a

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

Line 410: FROM HZ_CUST_ACCT_SITES a

406: -- not good performance
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'

Line 423: FROM HZ_CUST_ACCT_SITES a

419:
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'

Line 747: FROM hz_cust_acct_sites

743: l_account_hierarchy number;
744:
745: CURSOR account_code_csr(p_site_id in number)is
746: SELECT party_site_id
747: FROM hz_cust_acct_sites
748: WHERE cust_acct_site_id = p_site_id;
749:
750: CURSOR cust_account_info_csr(p_cust_account_id in number) is
751: SELECT party_id, sales_channel_code

Line 795: , hz_cust_acct_sites ac

791: --to get location_id (verify the sqls)
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;

Line 6260: FROM HZ_CUST_ACCT_SITES a

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

Line 8400: hz_cust_acct_sites hcas,

8396: p_site_use_code in varchar2,
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'