How to find Application Instance Login URL same database

---Application Instance Login URL

SELECT profile_option_value URL
  FROM fnd_profile_option_values
 WHERE     profile_option_id =
              (SELECT profile_option_id
                 FROM fnd_profile_options
                WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')
       AND level_value = 0;

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