APPS.IBE_WORKFLOW_PVT dependencies on HZ_PARTY_SITES

Line 166: hz_party_sites shp_party_site,

162: from oe_order_headers_all oh,
163: hz_parties sold_to_party,
164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,
170: hz_party_sites inv_party_site,

Line 170: hz_party_sites inv_party_site,

166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,
170: hz_party_sites inv_party_site,
171: hz_cust_acct_sites_all inv_acct_site,
172: hz_cust_site_uses_all inv_site_use
173: where oh.header_id=c_order_id
174: and sold_to_party.party_id= sold_to_account.party_id

Line 8569: FROM hz_party_sites

8565: rtrim(postal_code) loc_zip,
8566: rtrim(country) loc_country
8567: FROM hz_locations
8568: WHERE location_id = ( SELECT location_id
8569: FROM hz_party_sites
8570: WHERE party_site_id = p_loc_site_id);
8571: Cursor c_aso_shipments(p_quote_id NUMBER) IS
8572: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8573: FROM aso_shipments