Friday, 24 April 2015

How to find Application Instance Login URL same database

SELECT PROFILE_OPTION_VALUE
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