Finders
Lists available finders and their attributes for querying views in Oracle Fusion applications.
SELECT
ViewName is required to get the mapping FinderName and finder parameter column.
The ViewName column supports = and IN operators
SELECT * FROM Finders where viewname = 'abc' SELECT * FROM Finders where viewname IN ('abc','pqr')
Columns
Name | Type | Description |
ViewName | String | Specifies the name of the database view for which a finder needs to be identified. |
FinderName | String | The name of the finder, used to retrieve specific records from the view. |
AttributeFinderColumn | String | The attribute within the finder that is used for filtering or searching records. |
Type | String | Data type of the finder attribute, such as String, Integer, or Date. |