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