FO_OPPRSRCH_VW

(SQL View)
Index Back

Opportunity search View

Opportunity 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