For one of the portlets, when I try to filter for a resource, A, it comes up with the information of another resource B
I checked the query and saw the following mentioned -
SRM_RESOURCES.ID = PAC_MNT_RESOURCES.ID ( + )
As faar as my understanding goes,
PAC_MNT_RESOURCES.ID = This column refers to the unique identifier for a row in this table.
And, the way to get the data for the resource data is to join by the resource_code (user_name) in the CMN_SEC_USERS table.
Please corect if wrong