How to retrieve users requisition preferences from tables
Summary:
Can anyone help with tables and views to retrieve requisition user preferences. Most of the information available at
POR_USER_PREFERENCES_ALL, but not able to find the pointer to DELIVER_TO_LOCATION_ID, REQ_BU_ID , DeliverToAddress, DestinationOrganization, PreferenceType etc
API /fscmRestApi/resources/11.13.18.05/requisitionPreferences gives all the info, but looking to build a BI report based on SQL. Thanks for your help.
Version (include the version you are using, if applicable):
25A
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0