SCP_POABUY_VWFL

(SQL View)
 Index Back

POA Buyers view


SELECT DISTINCT A.OPRID ,B.BUYER_ID FROM PS_SCPVNDUSR_VW_FL A ,PS_SCP_ACKPOLST_FL B WHERE A.SETID=B.VENDOR_SETID AND A.VENDOR_ID=B.VENDOR_ID UNION SELECT 'ALL' ,'All' FROM PS_INSTALLATION

# 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_VW2

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