APPS.OKS_ARFEEDER_PUB dependencies on HZ_PARTY_SITES

Line 866: SELECT hz.party_id from hz_party_sites hz

862: AND nvl(org_id,p_org_id) = p_org_id;
863:
864: Cursor hdr_party_cur(p_bill_to_site_use_id IN NUMBER,
865: p_org_id IN NUMBER) IS
866: SELECT hz.party_id from hz_party_sites hz
867: where hz.party_site_id in (
868: SELECT site.party_site_id from hz_cust_acct_sites_all site
869: where site.cust_acct_site_id in
870: ( select uses.cust_acct_site_id

Line 2208: hz_party_sites ps,

2204: /* can be used instead of OKX view query above
2205: SELECT ca.cust_account_id, ca.cust_acct_site_id ,
2206: l.location_id ,hca.party_id ,cs.site_use_iD
2207: FROM hz_locations l,
2208: hz_party_sites ps,
2209: hz_cust_accounts hca,
2210: hz_cust_acct_sites_all ca,
2211: hz_cust_site_uses_all cs
2212: WHERE cs.site_use_id = p_id

Line 2646: hz_party_sites c

2642: SELECT c.party_id,
2643: a.party_site_id
2644: FROM hz_cust_acct_sites a,
2645: hz_cust_site_uses b,
2646: hz_party_sites c
2647: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2648: AND c.party_site_id = a.party_site_id
2649: AND b.site_use_id = p_site_use_id;
2650: