APPS.WSH_CORE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 118

   select ou.name org_name,
       loc.address_line_1 ship_address1,
       loc.address_line_2 ship_address2,
       loc.address_line_3 ship_address3,
       loc.town_or_city   city,
       loc.region_2       region,
       loc.postal_code    postal_code,
       terr.territory_short_name country
    from   hr_organization_units ou,
           fnd_territories_VL terr,
           hr_locations_no_join loc
    where  ou.organization_id = o_id
    and    loc.location_id(+) = ou.location_id
    and    loc.country = terr.territory_code(+);