I tried different combinations but this is what I got from beautifier:
SELECT a.Invoice_Id
INTO v_Invoice_Id
FROM Ap_Invoices a,
Po_Vendors b
WHERE a.Invoice_Num = v_Invoice_Number AND a.Vendor_Id = b.Vendor_Id AND b.Segment1 = TRIM(i.Gps_Vendor_Number);
I would like to see the AND and OR per line (one item per line) and aligned by the SELECT.
SELECT a.Invoice_Id
INTO v_Invoice_Id
FROM Ap_Invoices a,
Po_Vendors b
WHERE a.Invoice_Num = v_Invoice_Number AND a.Vendor_Id = b.Vendor_Id AND b.Segment1 = TRIM(i.Gps_Vendor_Number);
I would like to see the AND and OR per line (one item per line) and aligned by the SELECT.