I need a query that would give me all the detail that Supplier Payment History would
We are using oracle ebs r12.2.4 and we have over 60 organizations setup in the system.
I am trying to figure out the query that would give me all the supplier detail, (similar data as supplier payment history report but for all orgs), 1099 info, address, vendor name etc with payment detail for the last year organized by org_id from hr_operating_units. This is for 1099 reporting.
Thank you,
Monika