You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a query to get Remit to supplier name for a given supplier.

Accepted answer
702
Views
1
Comments
edited May 6, 2021 11:23AM in Reporting and Analytics for SCM 1 comment

Content

Hello all,

I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion.

I have got to tables joined,

poz_suppliers_v & poz_supplier_sites_all_m, where I picked the rest of the supplier details.

Can anyone tell me the table or provide me with a query to get the field I want "Remit to supplier".

Hereby I'm attaching the field I want from the front end in the 3rd screenshot. I have included the navigation screenshots as well.

 

Regards,

Sushan Peiris.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!