APPS.IBE_WORKFLOW_PVT dependencies on HZ_PARTY_SITES

Line 176: hz_party_sites shp_party_site,

172: from oe_order_headers_all oh,
173: hz_parties sold_to_party,
174: hz_cust_accounts sold_to_account,
175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,
180: hz_party_sites inv_party_site,

Line 180: hz_party_sites inv_party_site,

176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,
180: hz_party_sites inv_party_site,
181: hz_cust_acct_sites_all inv_acct_site,
182: hz_cust_site_uses_all inv_site_use
183: where oh.header_id=c_order_id
184: and sold_to_party.party_id= sold_to_account.party_id

Line 8664: FROM hz_party_sites

8660: rtrim(postal_code) loc_zip,
8661: rtrim(country) loc_country
8662: FROM hz_locations
8663: WHERE location_id = ( SELECT location_id
8664: FROM hz_party_sites
8665: WHERE party_site_id = p_loc_site_id);
8666: Cursor c_aso_shipments(p_quote_id NUMBER) IS
8667: SELECT ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
8668: FROM aso_shipments