Predefined Order Management Search Queries

Several predefined search queries are shipped with PeopleSoft Order Management. The tables will include all system data:

Record Name	Description	Sample Where Clause
SAC_SRCH_QRY	Search Query	SRCH_QRY_ID = 'OM_CUST_SOLDTO'
SAC_SRCH_QRYFLDS	Search Query Fields	SRCH_QRY_ID = 'OM_CUST_SOLDTO'