Hi Tom,

Hope you had a great vacation.
This is regd. a suggestion that I came across recently, On a query which fetches the data from a table.

Please go through below example for brief analysis.

Select ail.invoice_id,
(select tax_rate_code from zx_rates_all where tax_rate_id=ail.tax_rate_id) tax_rate_code
from ap_invoice_lines_all ail where ail.invoice_id=:P_INVOICE_ID;

In above query, I can pull tax rate code from an inline query, a standalone function (by writing inline query inside fn. and returning tax rate code).
Assuming the query is executing for bulk number of records (which may have same tax rate id), Can you please let me know which method will you prefer and explaining each method's pros and cons?
Adding to this, is there any difference between (performance wise) standalone function vs creating the same function in a package which will be called from a SQL query inside a concurrent program?

Thanks in Advance