DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on HZ_LOCATIONS

Line 1232: hz_locations loc

1228: INTO l_ship_to_location_id
1229: FROM hz_cust_site_uses_all site_uses,
1230: hz_cust_acct_sites_all acct_site,
1231: hz_party_sites party_site,
1232: hz_locations loc
1233: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
1234: AND acct_site.party_site_id = party_site.party_site_id
1235: AND loc.location_id = party_site.location_id
1236: AND site_uses.site_use_code = 'SHIP_TO'