In Oracle Fusion Cloud SCM, finders are filters used for searching collection resources. Each finder has several parameters bound to it.

Using Finders with Parent View

To use a finder filter with a parent view, you need to provide the FinderName in the finder pseudo column and provide values for the finder parameter columns.

SELECT * FROM Shipments WHERE finder = 'PrimaryKey' AND Shipment = 'test';

Using Finders with Child View

To use a finder filter with a child view, you need to provide the FinderName of the parent view in the finder pseudo column and provide values for the finder parameter columns of the parent view.

SELECT * FROM InvoicesinvoiceLinesinvoiceDistributions WHERE finder = 'PrimaryKey' AND InvoiceId = 5484;