Query for PTAEO Combinations
I am looking if there is any easy way to extract all of the possible PTAEO combinations from EBS for a one time load into an external system. I would need the ability to pull all active combinations that shows the Project, Task, Award, Expenditure Type, and Org. I cannot seem to figure out how to tie all of the tables together in SQL to gather all of the valid combinations. Is anyone aware of an easier way to do this? Any help would be appreciated. Thank you.