How to get default company in IFS
- Rumesh Aponso (RMAX)

- Nov 13, 2024
- 1 min read
-- way 1
SELECT User_Profile_SYS.Get_Default('COMPANY', Fnd_Session_Api.Get_Fnd_User) FROM DUAL;
-- way 2
SELECT Site_API.Get_Company(CONTRACT) company
FROM user_allowed_site_tab
WHERE userid = Fnd_Session_Api.Get_Fnd_User
AND user_site_type = 'DEFAULT SITE';



Comments