Is there a PL/SQL function that I could use to get the ENTERPRISE_ID of the logged in user so that I can use it in a report query for example as below.
'package.function' should be able to return the ENTERPRISE_ID of the logged in user.
I think you can access the ENTERPRISE_ID with:
Assuming that the ApplCore session has been initialized or alternatively:
Note that since this is related to VPD implementation you cannot simply query across enterprises, rather restrictions are applied on the table level. Also do note that since its internal code it is subject to change without notice.
Fusion Applications Developer Relations