PV_OPR_BUYER_VW

(SQL View)
 Index Back

Buyers Operator Authorized For

/OPRDESC Showing buyers which are Operator Authorized for and Active in BUYER_TBL.

SELECT A.OPRID , A.BUYER_ID , C.OPRDEFNDESC , A.ADD_AUTH , A.UPDATE_AUTH , A.CLOSE_AUTH FROM PS_OPR_PO_BUYER A , PS_BUYER_TBL B , PSOPRDEFN C WHERE A.BUYER_ID = B.BUYER_ID AND B.ACTIVE_FLG = 'Y' AND A.BUYER_ID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 ADD_AUTH Character(1) VARCHAR2(1) NOT NULL Add Authority

Y/N Table Edit

Default Value: Y

5 UPDATE_AUTH Character(1) VARCHAR2(1) NOT NULL Update Authority

Y/N Table Edit

Default Value: Y

6 CLOSE_AUTH Character(1) VARCHAR2(1) NOT NULL Cancel Authority

Y/N Table Edit

Default Value: Y