OPRPO_BUYSRC_VW

(SQL View)
 Index Back

Buyers Operator Authorized

Used in Alt sources of supply. 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 , A.DELETE_AUTH FROM PS_OPR_PO_BUYER A , PS_BUYER_TBL B ,PSOPRDEFN C WHERE A.BUYER_ID = B.BUYER_ID AND A.BUYER_ID = C.OPRID AND B.BUYER_ID = C.OPRID AND B.ACTIVE_FLG = 'Y'

# 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

7 DELETE_AUTH Character(1) VARCHAR2(1) NOT NULL Delete Authority

Y/N Table Edit

Default Value: N