PV_RSTRTEMPL_VW

(SQL View)
 Index Back

Requestors Opr Authorized For

/OPRDESC This view shows Requestors which are both active and operator authorized.

SELECT DISTINCT A.REQUESTOR_ID , C.OPRDEFNDESC FROM PS_PV_TEMPLATES A , PS_REQUESTOR_TBL B , PSOPRDEFN C WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND B.ACTIVE_FLG ='Y' AND A.REQUESTOR_ID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: REQUESTOR_VW

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user