Disable wildcard search
Hi
I have built a custom form in Oracle EBS using TEMPLATE.fmb.
Oracle EBS 12.1.3, Form Builder 10.1.2.0.2
It contains a query find block and another block that has the search results.
The WHEN-BUTTON-PRESSED trigger in the query find block is coded as below
:parameter.G_query_find := 'TRUE';
app_find.find('XX_SR');
:parameter.G_query_find := 'FALSE';
The PRE-QUERY trigger in the search result block is coded as below
--START
IF :parameter.G_query_find = 'TRUE' THEN
COPY(:QUERY_FIND.VENDOR_NAME, 'XX_SR.VENDOR_NAME');
COPY(:QUERY_FIND.PO_NUMBER, 'XX_SR.PO_NUMBER');
COPY(:QUERY_FIND.INVOICE_NUM, 'XX_SR.INVOICE_NUM');