Bookshelf v8.1/8.2: Row Set Look-Up Method

The Row Set Look-Up method looks up each input row in another row set using a specified search expression. For example, it could be used to check for compatibility.

Arguments


Input Argument	Description
Context	Optional. Property set of variables shared across all rows.
Row Set	The set of rows to process.
Output Row Set	Optional. The property set used for output.
Process Condition	A Boolean condition that is evaluated to determine whether to process each row.
Match Row Set	The row set that will be matched with the input row set.
Search Specification	A search expression comprised of literals and variable values from {Context}, {Row}, and {Match}. For example: {Row.Product Id} = {Match.Product Id}
On First Match [1..20]	Actions to perform on the first match for each input row.
On Match [1..20]	Actions to perform on every match for each input row.
On Last Match [1..20]	Actions to perform on the last match for each input row.
On No Match [1..20]	Actions to perform if there are no matches for an input row.

Example

Figure 29 shows an example of arguments for a PSP procedure step named Flag Incompatible Rows, which uses the Row Set Look-Up method.

Siebel Order Management Infrastructure Guide		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.