Friday, 24 April 2015

How to find inventory organization full address

SELECT location_id, location_code, NAME, address_line_1, address_line_2,
       address_line_3, telephone_number_1, postal_code, loc_information14,
       loc_information15, loc_information16
  FROM hr_organization_units_v
  WHERE location_id is not null

No comments:

Post a Comment