APPS.OE_ITORD_UTIL dependencies on HZ_PARTY_SITES

Line 1089: hz_party_sites party_site,

1085: SELECT loc.location_id
1086: INTO l_ship_to_location_id
1087: FROM hz_cust_site_uses_all site_uses,
1088: hz_cust_acct_sites_all acct_site,
1089: hz_party_sites party_site,
1090: hz_locations loc
1091: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
1092: AND acct_site.party_site_id = party_site.party_site_id
1093: AND loc.location_id = party_site.location_id