DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_SV dependencies on HR_LOCATIONS

Line 213: select location_code from hr_locations

209:
210: -- As part of hr_location changes bug# 2393886
211:
212: cursor c1 is
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