PO_MANAGER_VW

(SQL View)
 Index Back

Manager search view

This record is created to be used as the Update/Display Search Record for PO_MANAGER_TBL component.

SELECT A.BUYER_ID , B.OPRDEFNDESC FROM PS_BUYER_TBL A , PSOPRDEFN B WHERE A.BUYER_ID = B.OPRID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_MANAGER Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: PO_BUYER_VW

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