FO_OPPRSRCH_VW(SQL View) |
Index Back |
---|---|
Opportunity search ViewOpportunity search View |
SELECT SRCH_TYPE_CD ,OPRID ,SAVED_NAME ,SEARCH_DESCR FROM PS_FO_SRCH_SVD_CFG WHERE SELECT_FLAG ='Y' AND SRCH_TYPE_CD IN ('ORDSR', 'CSTSR', 'CNTSR') AND SRCH_TYPE_CD = ( SELECT MIN(B.SRCH_TYPE_CD) FROM PS_FO_SRCH_SVD_CFG B WHERE B.OPRID = PS_FO_SRCH_SVD_CFG.OPRID AND B.SAVED_NAME = PS_FO_SRCH_SVD_CFG.SAVED_NAME AND B.SRCH_TYPE_CD IN ('ORDSR', 'CSTSR', 'CNTSR') AND B.SELECT_FLAG ='Y') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SRCH_TYPE_CD | Character(5) | VARCHAR2(5) NOT NULL | Search Type |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | SAVED_NAME | Character(15) | VARCHAR2(15) NOT NULL | Saved Search Name |
4 | SEARCH_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Search Description |