Predefined Search Query Data
Several predefined search query data sets shipped with PeopleSoft Order Management. The tables will include all system data:
| Record Name | Description | Sample Where Clause |
|---|---|---|
|
SAC_SRCH_RSLT |
Search Result |
SRCH_RSLT_ID = 'OM_CUST_SOLDTO' |
|
SAC_SRCH_RSLTFDS |
Search Result Fields |
SRCH_RSLT_ID = 'OM_CUST_SOLDTO' |
|
SAC_SRCH_RLTQRY |
Search Result Query Association |
SRCH_RSLT_ID = 'OM_CUST_SOLDTO' |