APPS.PO_DISTRIBUTIONS_SV dependencies on HZ_LOCATIONS

Line 217: select (substrb(rtrim(address1)||'-'||rtrim(city),1,20)) location_code from hz_locations

213: select location_code from hr_locations
214: where nvl(inventory_organization_id,x_ship_to_org_id) = x_ship_to_org_id
215: and location_id = x_deliver_to_location_id
216: UNION
217: select (substrb(rtrim(address1)||'-'||rtrim(city),1,20)) location_code from hz_locations
218: where location_id = x_deliver_to_location_id ;
219:
220: /* Bug 1323765
221: and nvl(inactive_date, trunc(sysdate + 1)) > trunc(sysdate);