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 2226: hz_party_sites ps,

2222: /* can be used instead of OKX view query above
2223: SELECT ca.cust_account_id, ca.cust_acct_site_id ,
2224: l.location_id ,hca.party_id ,cs.site_use_iD
2225: FROM hz_locations l,
2226: hz_party_sites ps,
2227: hz_cust_accounts hca,
2228: hz_cust_acct_sites_all ca,
2229: hz_cust_site_uses_all cs
2230: WHERE cs.site_use_id = p_id

Line 2665: hz_party_sites c

2661: SELECT c.party_id,
2662: a.party_site_id
2663: FROM hz_cust_acct_sites a,
2664: hz_cust_site_uses b,
2665: hz_party_sites c
2666: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2667: AND c.party_site_id = a.party_site_id
2668: AND b.site_use_id = p_site_use_id;
2669: