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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

I need an sql query where I had to fetch the main details of Requisition when it returned to buyer

Summary:

SQL query to get the details of requisitions returned by Buyer

Content (please ensure you mask any confidential information):

I have fetched all the details but is struggling to fetch two columns

Version (include the version you are using, if applicable):

Oracle fusion ERP

Code Snippet (add any code snippets that support your topic, if applicable):

Requisition number                                          
-  Requisition Creation Date                               
-  Requisition Approval Date                                  
-  Requisition “Returned” by the Buyer Date **
-  Requisition “Return” reason                                 por_requisition_lines_all
-  Assigned Buyer Name    **                                     
-  PR Preparer Name **
-  PR Requestor Name**
-  Supplier Name                                               poz_suppliers_v

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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