Not all bind variables have a corresponding argument

I think...you have order no, line no, release no in your argument and get but not in your ‘where’ clause.

Linda

In the Get Due AT Dock call use “:” in front of t.line_no,t.order_no and t.release_no 

 Columns on the purchase requisition lines corresponding the the purchase order line are assg_line_no and assg_release_no. 

Just use the PL/SQL Expression, it gets the total remaining quantity due at dock. 

The error “Not all bind variables have a corresponding argument” means that you have parameters declared that you are not using with the colon in front of it with in the query. Just add the colon and the error will go away. All arguments that are listed should be in the format

:argument_name

so just do “Purchase_Order_Line_API.Get_Due_AT_Dock(:t.order_no,:t.line_no,:t.release_no)”

and your error message should go away. 

Hi ​@spetkus2 ,

I did as you said but unfortunately the result has not changed, I continue to get the same error;

Thanks

Hi ​@debber24 ,

First of all, thank you for your response.

I would like to see the relevant quantity information not on an order basis but on a part and supplier basis, so I need the total value under these constraints.

Thanks 

Just keep your original select statement, but remove ,t.order_no,t.line_no,t.release_no from the Arguments, since you’re not using them in the query.

Hi ​@AussieAnders,

First of all, thanks for your response.

I did as you said unfortunately the result has not changed, I continue to get the same error;

Which entity is your custom field on? Is it PurchaseReqLinePart?

If so, and this is your select statement:

Then arguments v.part_no, v.vendor_no should do the trick, but also replace :t. with just : in your select statement. That way, the part number and vendor number will be recognised as bind variables, binding to your arguments. I can’t be bothered retyping the whole thing, but here’s the important part:

1where t.part_no = :part_no
2  and t.invoicing_supplier = :vendor_no