I need a Query to get the Open Purchase Requisition Quantity , with these Conditions,
PR Status Approved (and not Returned not Canceled not Finally Closed )
Pr Line not Linked to any Po Number
----
Example1 : Approved PR Line Number 1 have Quantity 100 and not linked to any PO , So the Open PR QTY is 100
Example 2: Approved PR Line Number 1 have Quantity 100 we Made PO with 50 by Auto create Function So The PR now will have Three Lines As the Following : Line 1 , with QTY 100 Not Linked To any PO and Line 2 with QTY 50 Linked to PO and Line 3 with QTY 50 Not Linked To any PO , So the Open PR QTY is only 50 (not 100 and not 150 )
Oracle EBS 12.2.4
Your Support is highly Appreciated.