Hi,
We are customizing the standard AR Invoice Print Report . in that we have lexical clauses like (&P_DYNAMIC_FROM_CLAUSE,&P_DYNAMIC_WHERE_CLAUSE). When we are commenting this out in our query we are able to get the data, but once we re-add these clauses then our data is not coming. We need these clauses because if we comment out then we would not be able to see invoices from the application.
If anyone came across the issue please let me know!
Attaching the sql query for the reference
Credit Memo header.txt (40.32 KB)